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