Query Metrics
72
Database Queries
12
Different statements
44.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
8.15 ms (18.34%) |
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" "46" "603" "1045" "840" "519" "676" "292" "45" "444" "605" "829" "830" "186" "828" "852" "843" "723" "473" "747" "533" "357" "672" "505" "532" "658" "419" "683" "434" "700" "436" "630" "866" "726" "495" "483" "466" "465" "484" "489" "84" "62" "211" "478" "481" "468" "490" "493" "426" "316" "507" "743" "657" "422" "621" "486" "662" "482" "474" "613" "439" "609" "335" "622" "430" "623" "258" "458" "252" "472" "487" "467" "859" "328" "870" "868" "871" "411" "516" "504" "517" "508" "511" "425" "530" "650" "423" "515" "514" "524" "448" "370" "547" "445" "861" "612" "462" "479" "506" "550" "611" "867" "601" "648" "525" "441" "513" "376" "352" "518" "581" "501" "598" "617" "637" "636" "634" "570" "615" "633" "614" "457" "701" "412" "331" "471" "391" "631" "746" "420" "470" "225" "456" "413" "905" "664" "628" "392" "428" "459" "350" "497" "461" "414" "34" "460" "675" "689" "690" "421" "415" "863" "684" "834" "857" "853" "418" "666" "15" "393" "523" "653" "529" "624" "556" "558" "536" "469" "599" "585" "549" "541" "540" "566" "608" "403" "619" "704" "682" "433" "387" "696" "832" "632" "699" "417" "253" "1023" "610" "35" "264" "63" "65" "67" "95" "120" "124" "125" "136" "155" "246" "300" "154" "321" "287" "192" "363" "216" "233" "245" "606" "781" "171" "446" "819" "301" "786" "20" "27" "99" "656" "377" "404" "731" "447" "271" "575" "307" "308" "54" "435" "440" "324" "437" "179" "587" "438" "176" "2" "424" "673" "175" "174" "578" "442" "877" "248" "496" "463" "476" "3" "371" "406" "1" "410" "416" "13" "14" "386" "145" "780" "750" "751" "772" "677" "824" "602" "87" "812" "232" "178" "546" "802" "803" "785" "810" "563" "811" "734" "783" "816" "807" "744" "705" "814" "4" "1025" "39" "385" "168" "37" "44" "61" "78" "83" "91" "105" "117" "126" "161" "169" "207" "238" "261" "266" "282" "90" "43" "97" "33" "659" "764" "754" "688" "629" "738" "152" "223" "720" "721" "725" "594" "269" "215" "96" "500" "522" "7" "596" "365" "521" "644" "660" "286" "231" "397" "706" "649" "618" "429" "172" "534" "625" "559" "818" "813" "694" "535" "806" "193" "815" "745" "755" "805" "641" "310" "173" "389" "604" "800" "103" "241" "427" "791" "711" "767" "771" "801" "661" "763" "809" "749" "748" "794" "779" "808" "768" "569" "799" "759" "499" "492" "498" "742" "402" "149" "719" "348" "36" "707" "153" "770" "527" "520" "753" "162" "740" "194" "349" "776" "793" "475" "757" "488" "485" "774" "784" "531" "665" "480" "761" "477" "551" "548" "89" "491" "729" "494" "756" "709" "792" "713" "687" "698" "528" "543" "544" "545" "17" "712" "567" "512" "589" "597" "992" "993" "995" "996" "999" "1001" "1002" "1004" "831" "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" "562" "255" "112" "875" "106" "139" "760" "775" "1043" "1034" "1016" "854" "960" "1026" "943" "1005" "787" "1036" "972" "1007" "902" "737" "940" "788" "820" "954" "555" "645" "953" "642" "955" "593" "939" "360" "1012" "1038" "973" "961" "1022" "710" "941" "911" "1044" "1040" "952" "1024" "907" "646" "1010" "390" "356" "1006" "580" "923" "1000" "862" "590" "170" "49" "71" "542" "552" "395" "663" "584" "502" "983" "503" "595" "588" "708" "697" "582" "652" "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" "835" "654" "849" "856" "848" "968" "838" "858" "850" "826" "841" "833" "980" "985" "971" "388" "678" "846" "695" "944" "994" "855" "982" "864" "932" "922" "929" "1008" "298" "975" "160" "925" "976" "997" "358" "934" "945" "851" "30" "986" "933" "947" "94" "978" "509" "924" "928" "1015" "70" "797" "974" "984" "399" "931" "28" "651" "260" "921" "568" "431" "150" "554" "946" "1035" "1042" "920" "957" "362" "915" "959" "1027" "796" "691" "817" "766" "822" "758" "1037" "908" "821" "762" "798" "773" "949" "769" "782" "860" "913" "1041" "394" "538" "916" "777" "735" "930" "1021" "1030" "778" "804" "938" "948" "865" "909" "202" "935" "962" "951" "616" "635" "869" "576" "510" "874" "873" "926" "398" "586" "537" "823" "539" "927" "405" "361" "977" "443" "1014" "963" "883" "752" "917" "884" "839" "765" "795" ]
|
||||||||||||||||||||||||||||
|
6.53 ms (14.69%) |
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:
[
246
]
|
||||||||||||||||||||||||||||
|
6.44 ms (14.50%) |
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:
[] |
||||||||||||||||||||||||||||
|
6.38 ms (14.36%) |
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:
[
246
]
|
||||||||||||||||||||||||||||
|
6.04 ms (13.60%) |
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:
[
246
]
|
||||||||||||||||||||||||||||
|
5.16 ms (11.62%) |
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.78 ms (4.01%) |
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.52 ms (3.42%) |
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:
[] |
||||||||||||||||||||||||||||
|
0.86 ms (1.93%) |
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.53 ms (1.19%) |
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.52 ms (1.17%) |
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-19 01:34:27" "2026-02-19 01:34:27" ]
|
||||||||||||||||||||||||||||
|
0.52 ms (1.17%) |
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. |