Query Metrics
72
Database Queries
12
Different statements
45.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
7.74 ms (16.96%) |
1 |
SELECT e0_.name AS name_0, e0_.note AS note_1, e0_.manager AS manager_2, e0_.reference AS reference_3, e0_.phone AS phone_4, e0_.description AS description_5, e0_.website AS website_6, e0_.email AS email_7, e0_.phone2 AS phone2_8, e0_.view_number AS view_number_9, e0_.verified AS verified_10, e0_.score AS score_11, e0_.keywords AS keywords_12, e0_.place_id AS place_id_13, e0_.platform AS platform_14, e0_.version AS version_15, e0_.google_type AS google_type_16, e0_.google_photos AS google_photos_17, e0_.map_url AS map_url_18, e0_.weekday_text AS weekday_text_19, e0_.enabled AS enabled_20, e0_.ranks AS ranks_21, e0_.full_address AS full_address_22, e0_.latitude AS latitude_23, e0_.longitude AS longitude_24, e0_.created_at AS created_at_25, e0_.updated_at AS updated_at_26, e0_.slug AS slug_27, e0_.id AS id_28, e0_.facebook AS facebook_29, e0_.youtube AS youtube_30, e0_.instagram AS instagram_31, e0_.twitter AS twitter_32, e0_.google_plus AS google_plus_33, e0_.region_id AS region_id_34, e0_.commune_id AS commune_id_35, e0_.city_id AS city_id_36, e0_.quartier_id AS quartier_id_37, e0_.sub_prefecture_id AS sub_prefecture_id_38, e0_.prefecture_id AS prefecture_id_39, e0_.campagne_id AS campagne_id_40, e0_.operator_id AS operator_id_41, e0_.quotation_id AS quotation_id_42 FROM establishment e0_ WHERE e0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "1028" "603" "46" "1045" "519" "829" "830" "840" "292" "676" "45" "605" "444" "186" "852" "843" "828" "870" "570" "723" "684" "258" "696" "252" "746" "699" "487" "462" "479" "473" "461" "391" "460" "459" "622" "623" "328" "458" "392" "853" "393" "457" "675" "598" "430" "417" "701" "530" "471" "556" "511" "331" "631" "225" "425" "470" "508" "504" "666" "418" "412" "664" "832" "747" "420" "529" "456" "423" "433" "515" "413" "628" "428" "533" "905" "871" "357" "682" "448" "15" "414" "558" "653" "834" "506" "601" "415" "540" "421" "350" "513" "34" "704" "863" "517" "672" "505" "585" "857" "445" "690" "566" "689" "525" "532" "648" "536" "658" "861" "419" "612" "550" "370" "611" "683" "547" "434" "411" "501" "700" "436" "630" "599" "376" "352" "518" "441" "403" "523" "866" "726" "495" "483" "466" "465" "467" "484" "489" "472" "624" "633" "614" "84" "62" "211" "478" "632" "481" "468" "867" "469" "617" "615" "490" "549" "636" "637" "634" "619" "253" "493" "426" "316" "516" "507" "581" "743" "859" "657" "650" "422" "621" "486" "662" "482" "474" "524" "608" "514" "541" "387" "613" "497" "439" "609" "335" "868" "1023" "610" "35" "264" "145" "63" "4" "65" "67" "95" "120" "124" "125" "136" "155" "246" "300" "154" "321" "496" "476" "602" "410" "416" "406" "1" "705" "442" "877" "14" "287" "192" "363" "248" "232" "216" "463" "386" "233" "245" "780" "816" "606" "744" "751" "734" "810" "807" "811" "772" "783" "785" "781" "677" "546" "171" "814" "87" "812" "446" "819" "301" "786" "824" "563" "20" "27" "99" "656" "377" "404" "731" "750" "371" "803" "447" "271" "802" "575" "307" "308" "54" "435" "440" "324" "437" "179" "587" "438" "176" "2" "13" "424" "673" "175" "174" "3" "578" "178" "1025" "39" "385" "168" "36" "37" "44" "61" "78" "83" "91" "105" "117" "126" "153" "161" "169" "207" "238" "261" "266" "282" "90" "43" "97" "33" "498" "491" "659" "477" "488" "480" "499" "494" "763" "748" "742" "771" "794" "809" "749" "808" "779" "801" "799" "767" "711" "569" "759" "791" "768" "793" "764" "754" "774" "784" "761" "740" "753" "776" "688" "757" "665" "792" "756" "729" "349" "89" "629" "738" "152" "709" "149" "661" "427" "719" "223" "720" "721" "725" "348" "594" "269" "687" "698" "215" "475" "545" "527" "567" "528" "520" "96" "500" "522" "194" "7" "596" "548" "543" "365" "531" "551" "544" "521" "402" "512" "644" "660" "492" "770" "485" "286" "231" "397" "706" "707" "649" "712" "618" "429" "172" "713" "162" "534" "625" "559" "818" "813" "694" "535" "806" "193" "17" "815" "745" "755" "805" "641" "310" "173" "389" "604" "800" "103" "241" "589" "597" "869" "992" "993" "995" "996" "999" "1001" "1002" "1004" "831" "873" "94" "32" "38" "64" "66" "68" "73" "75" "101" "104" "132" "137" "141" "163" "164" "165" "166" "167" "203" "204" "206" "210" "220" "237" "259" "323" "367" "509" "562" "255" "112" "875" "106" "139" "798" "202" "769" "28" "949" "930" "920" "934" "922" "928" "929" "931" "932" "358" "510" "982" "773" "804" "758" "735" "766" "778" "760" "777" "775" "782" "796" "821" "762" "951" "916" "962" "935" "948" "909" "957" "938" "913" "908" "959" "860" "1043" "1037" "1041" "1034" "1016" "854" "960" "1026" "943" "1005" "787" "1036" "972" "1007" "538" "902" "737" "1014" "884" "940" "788" "820" "954" "555" "645" "752" "953" "642" "851" "691" "955" "593" "939" "974" "360" "1012" "855" "1038" "973" "961" "1022" "710" "946" "941" "911" "1044" "443" "1040" "1042" "952" "1024" "907" "1035" "150" "568" "976" "646" "975" "1021" "984" "765" "986" "1010" "933" "925" "390" "926" "963" "795" "874" "651" "399" "30" "1008" "356" "160" "797" "997" "924" "260" "839" "1027" "298" "978" "917" "1015" "70" "945" "431" "1006" "580" "923" "537" "1000" "822" "862" "1030" "394" "362" "921" "554" "927" "590" "865" "635" "170" "947" "616" "586" "49" "915" "817" "71" "542" "539" "552" "576" "395" "663" "405" "584" "502" "983" "503" "595" "588" "708" "697" "582" "652" "823" "919" "257" "703" "454" "600" "85" "647" "620" "910" "643" "981" "655" "979" "294" "626" "591" "627" "592" "146" "991" "281" "827" "876" "988" "987" "989" "970" "977" "835" "361" "654" "849" "856" "848" "968" "838" "858" "850" "826" "841" "833" "980" "985" "398" "971" "388" "678" "846" "864" "695" "883" "944" "994" ]
|
||||||||||||||||||||||||||||
|
7.47 ms (16.38%) |
20 |
SELECT t0.name AS name_1, t0.second_name AS second_name_2, t0.reference AS reference_3, t0.icon AS icon_4, t0.score AS score_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.slug AS slug_8, t0.id AS id_9, t0.parent_id AS parent_id_10, t0.popular_category_id AS popular_category_id_11, t0.quotation_id AS quotation_id_12 FROM category t0 INNER JOIN establishment_category ON t0.id = establishment_category.category_id WHERE establishment_category.establishment_id = ?
Parameters:
[
677
]
|
||||||||||||||||||||||||||||
|
7.08 ms (15.51%) |
22 |
SELECT t0.name AS name_1, t0.size AS size_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.establishment_id AS establishment_id_5, t0.comment_id AS comment_id_6, t0.logos_id AS logos_id_7, t0.campagne_id AS campagne_id_8, t0.job_offert_id AS job_offert_id_9, t0.landing_page_id AS landing_page_id_10 FROM image t0 WHERE t0.establishment_id = ?
Parameters:
[
677
]
|
||||||||||||||||||||||||||||
|
6.65 ms (14.58%) |
20 |
SELECT t0.content AS content_1, t0.rating AS rating_2, t0.value_money AS value_money_3, t0.location AS location_4, t0.cleanliness AS cleanliness_5, t0.author_url AS author_url_6, t0.google_comment_created_at AS google_comment_created_at_7, t0.enabled AS enabled_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_id AS parent_id_12, t0.establishement_id AS establishement_id_13, t0.author_id AS author_id_14 FROM COMMENT t0 WHERE t0.establishement_id = ?
Parameters:
[
677
]
|
||||||||||||||||||||||||||||
|
6.11 ms (13.40%) |
1 |
SELECT e0_.name AS name_0, e0_.note AS note_1, e0_.manager AS manager_2, e0_.reference AS reference_3, e0_.phone AS phone_4, e0_.description AS description_5, e0_.website AS website_6, e0_.email AS email_7, e0_.phone2 AS phone2_8, e0_.view_number AS view_number_9, e0_.verified AS verified_10, e0_.score AS score_11, e0_.keywords AS keywords_12, e0_.place_id AS place_id_13, e0_.platform AS platform_14, e0_.version AS version_15, e0_.google_type AS google_type_16, e0_.google_photos AS google_photos_17, e0_.map_url AS map_url_18, e0_.weekday_text AS weekday_text_19, e0_.enabled AS enabled_20, e0_.ranks AS ranks_21, e0_.full_address AS full_address_22, e0_.latitude AS latitude_23, e0_.longitude AS longitude_24, e0_.created_at AS created_at_25, e0_.updated_at AS updated_at_26, e0_.slug AS slug_27, e0_.id AS id_28, e0_.facebook AS facebook_29, e0_.youtube AS youtube_30, e0_.instagram AS instagram_31, e0_.twitter AS twitter_32, e0_.google_plus AS google_plus_33, e0_.region_id AS region_id_34, e0_.commune_id AS commune_id_35, e0_.city_id AS city_id_36, e0_.quartier_id AS quartier_id_37, e0_.sub_prefecture_id AS sub_prefecture_id_38, e0_.prefecture_id AS prefecture_id_39, e0_.campagne_id AS campagne_id_40, e0_.operator_id AS operator_id_41, e0_.quotation_id AS quotation_id_42 FROM establishment e0_
Parameters:
[] |
||||||||||||||||||||||||||||
|
3.85 ms (8.44%) |
1 |
SELECT c0_.name AS name_0, c0_.second_name AS second_name_1, c0_.reference AS reference_2, c0_.icon AS icon_3, c0_.score AS score_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.slug AS slug_7, c0_.id AS id_8, c0_.parent_id AS parent_id_9, c0_.popular_category_id AS popular_category_id_10, c0_.quotation_id AS quotation_id_11 FROM category c0_ ORDER BY c0_.name ASC
Parameters:
[] |
||||||||||||||||||||||||||||
|
1.91 ms (4.18%) |
1 |
SELECT s0_.name AS name_0, s0_.latitude AS latitude_1, s0_.longitude AS longitude_2, s0_.id AS id_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.slug AS slug_6, s0_.prefecture_id AS prefecture_id_7 FROM sub_prefecture s0_ ORDER BY s0_.name ASC
Parameters:
[] |
||||||||||||||||||||||||||||
|
1.60 ms (3.51%) |
1 |
SELECT c0_.name AS name_0, c0_.second_name AS second_name_1, c0_.reference AS reference_2, c0_.icon AS icon_3, c0_.score AS score_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.slug AS slug_7, c0_.id AS id_8, c0_.parent_id AS parent_id_9, c0_.popular_category_id AS popular_category_id_10, c0_.quotation_id AS quotation_id_11 FROM category c0_
Parameters:
[] |
||||||||||||||||||||||||||||
|
1.16 ms (2.55%) |
2 |
SELECT t0.name AS name_1, t0.note AS note_2, t0.manager AS manager_3, t0.reference AS reference_4, t0.phone AS phone_5, t0.description AS description_6, t0.website AS website_7, t0.email AS email_8, t0.phone2 AS phone2_9, t0.view_number AS view_number_10, t0.verified AS verified_11, t0.score AS score_12, t0.keywords AS keywords_13, t0.place_id AS place_id_14, t0.platform AS platform_15, t0.version AS version_16, t0.google_type AS google_type_17, t0.google_photos AS google_photos_18, t0.map_url AS map_url_19, t0.weekday_text AS weekday_text_20, t0.enabled AS enabled_21, t0.ranks AS ranks_22, t0.full_address AS full_address_23, t0.latitude AS latitude_24, t0.longitude AS longitude_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.slug AS slug_28, t0.id AS id_29, t0.facebook AS facebook_30, t0.youtube AS youtube_31, t0.instagram AS instagram_32, t0.twitter AS twitter_33, t0.google_plus AS google_plus_34, t0.region_id AS region_id_35, t0.commune_id AS commune_id_36, t0.city_id AS city_id_37, t0.quartier_id AS quartier_id_38, t0.sub_prefecture_id AS sub_prefecture_id_39, t0.prefecture_id AS prefecture_id_40, t0.campagne_id AS campagne_id_41, t0.operator_id AS operator_id_42, t0.quotation_id AS quotation_id_43 FROM establishment t0 WHERE t0.campagne_id = ?
Parameters:
[
9
]
|
||||||||||||||||||||||||||||
|
0.98 ms (2.15%) |
1 |
SELECT t0.name AS name_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.slug AS slug_7 FROM region t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"conakry"
]
|
||||||||||||||||||||||||||||
|
0.56 ms (1.23%) |
1 |
SELECT c0_.name AS name_0, c0_.start_at AS start_at_1, c0_.end_at AS end_at_2, c0_.status AS status_3, c0_.space AS space_4, c0_.type AS type_5, c0_.title AS title_6, c0_.content AS content_7, c0_.ranks AS ranks_8, c0_.summary AS summary_9, c0_.link AS link_10, c0_.id AS id_11, c0_.created_at AS created_at_12, c0_.updated_at AS updated_at_13 FROM campagne c0_ WHERE c0_.status = ? AND c0_.start_at <= ? AND c0_.end_at >= ? ORDER BY c0_.id ASC LIMIT 4
Parameters:
[ 1 "2026-02-18 22:48:13" "2026-02-18 22:48:13" ]
|
||||||||||||||||||||||||||||
|
0.51 ms (1.12%) |
1 |
SELECT r0_.name AS name_0, r0_.latitude AS latitude_1, r0_.longitude AS longitude_2, r0_.id AS id_3, r0_.created_at AS created_at_4, r0_.updated_at AS updated_at_5, r0_.slug AS slug_6 FROM region r0_
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Region | No errors. |
| App\Entity\Prefecture | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Establishment | No errors. |
| App\Entity\Commune | No errors. |
| App\Entity\City | No errors. |
| App\Entity\Quartier | No errors. |
| App\Entity\SubPrefecture | No errors. |
| App\Entity\Campagne | No errors. |
| App\Entity\Operator | No errors. |
| App\Entity\Quotation | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\OpeningHours | No errors. |
| App\Entity\PricingList | No errors. |
| App\Entity\Comment | No errors. |
| App\Entity\Address | No errors. |
| App\Entity\Booking | No errors. |
| App\Entity\EstablishmentAdd | No errors. |
| App\Entity\JobOffert | No errors. |
| App\Entity\Amenity | No errors. |
| App\Entity\PopularCategory | No errors. |
| App\Entity\LandingPage | No errors. |
| App\Entity\Author | No errors. |