Symfony Profiler

Query Metrics

58 Database Queries

21 Different statements

60.26 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

14.37 ms
(23.84%)

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"
  "444"
  "605"
  "840"
  "519"
  "829"
  "830"
  "676"
  "292"
  "45"
  "186"
  "290"
  "843"
  "852"
  "828"
  "570"
  "723"
  "746"
  "462"
  "479"
  "473"
  "391"
  "460"
  "459"
  "392"
  "853"
  "118"
  "681"
  "457"
  "675"
  "598"
  "701"
  "530"
  "471"
  "556"
  "511"
  "331"
  "631"
  "225"
  "425"
  "470"
  "508"
  "504"
  "666"
  "418"
  "412"
  "664"
  "832"
  "747"
  "420"
  "529"
  "456"
  "433"
  "515"
  "680"
  "413"
  "628"
  "428"
  "533"
  "905"
  "357"
  "682"
  "448"
  "15"
  "573"
  "414"
  "558"
  "653"
  "834"
  "506"
  "601"
  "415"
  "540"
  "421"
  "836"
  "350"
  "34"
  "704"
  "863"
  "517"
  "672"
  "505"
  "857"
  "445"
  "690"
  "566"
  "689"
  "525"
  "532"
  "648"
  "536"
  "658"
  "861"
  "419"
  "612"
  "550"
  "370"
  "611"
  "683"
  "547"
  "434"
  "29"
  "501"
  "700"
  "436"
  "577"
  "213"
  "630"
  "376"
  "352"
  "518"
  "441"
  "403"
  "523"
  "866"
  "726"
  "495"
  "483"
  "466"
  "465"
  "484"
  "489"
  "378"
  "624"
  "633"
  "614"
  "84"
  "62"
  "211"
  "478"
  "632"
  "481"
  "468"
  "867"
  "469"
  "617"
  "615"
  "490"
  "549"
  "636"
  "637"
  "634"
  "619"
  "253"
  "311"
  "493"
  "426"
  "316"
  "516"
  "507"
  "581"
  "743"
  "657"
  "650"
  "422"
  "621"
  "486"
  "662"
  "482"
  "474"
  "904"
  "524"
  "608"
  "514"
  "541"
  "387"
  "613"
  "497"
  "439"
  "572"
  "609"
  "335"
  "585"
  "699"
  "622"
  "430"
  "623"
  "258"
  "458"
  "696"
  "252"
  "393"
  "472"
  "487"
  "467"
  "571"
  "315"
  "383"
  "668"
  "599"
  "859"
  "328"
  "417"
  "872"
  "235"
  "870"
  "461"
  "868"
  "871"
  "513"
  "684"
  "411"
  "1023"
  "610"
  "35"
  "264"
  "145"
  "63"
  "113"
  "4"
  "65"
  "67"
  "72"
  "93"
  "95"
  "120"
  "124"
  "125"
  "136"
  "138"
  "155"
  "214"
  "246"
  "254"
  "270"
  "300"
  "154"
  "321"
  "602"
  "272"
  "287"
  "192"
  "363"
  "196"
  "216"
  "386"
  "233"
  "245"
  "780"
  "816"
  "606"
  "744"
  "751"
  "734"
  "810"
  "807"
  "811"
  "772"
  "783"
  "785"
  "781"
  "639"
  "677"
  "277"
  "219"
  "133"
  "546"
  "464"
  "22"
  "114"
  "171"
  "814"
  "87"
  "119"
  "638"
  "446"
  "640"
  "819"
  "301"
  "76"
  "786"
  "147"
  "198"
  "824"
  "151"
  "26"
  "21"
  "20"
  "27"
  "99"
  "180"
  "656"
  "338"
  "377"
  "284"
  "295"
  "404"
  "731"
  "750"
  "56"
  "144"
  "309"
  "275"
  "296"
  "55"
  "803"
  "447"
  "278"
  "271"
  "802"
  "279"
  "307"
  "308"
  "280"
  "299"
  "54"
  "435"
  "440"
  "324"
  "437"
  "179"
  "587"
  "438"
  "176"
  "2"
  "424"
  "673"
  "175"
  "174"
  "578"
  "178"
  "189"
  "442"
  "877"
  "341"
  "248"
  "563"
  "156"
  "496"
  "476"
  "716"
  "3"
  "812"
  "371"
  "234"
  "276"
  "318"
  "289"
  "705"
  "406"
  "232"
  "1"
  "410"
  "416"
  "197"
  "13"
  "14"
  "86"
  "1025"
  "39"
  "385"
  "168"
  "37"
  "41"
  "44"
  "61"
  "78"
  "81"
  "82"
  "83"
  "91"
  "105"
  "117"
  "126"
  "135"
  "161"
  "169"
  "205"
  "207"
  "238"
  "261"
  "266"
  "267"
  "274"
  "282"
  "90"
  "43"
  "97"
  "33"
  "659"
  "793"
  "764"
  "754"
  "774"
  "784"
  "761"
  "740"
  "753"
  "776"
  "688"
  "757"
  "665"
  "792"
  "756"
  "729"
  "349"
  "89"
  "629"
  "738"
  "152"
  "709"
  "288"
  "50"
  "223"
  "722"
  "720"
  "721"
  "724"
  "725"
  "594"
  "269"
  "215"
  "545"
  "565"
  "564"
  "527"
  "92"
  "567"
  "74"
  "528"
  "520"
  "195"
  "730"
  "6"
  "557"
  "96"
  "500"
  "396"
  "522"
  "741"
  "194"
  "127"
  "7"
  "596"
  "548"
  "543"
  "365"
  "531"
  "551"
  "544"
  "521"
  "512"
  "432"
  "111"
  "685"
  "644"
  "660"
  "19"
  "715"
  "209"
  "286"
  "77"
  "231"
  "397"
  "53"
  "320"
  "706"
  "649"
  "712"
  "618"
  "429"
  "172"
  "713"
  "263"
  "218"
  "692"
  "162"
  "48"
  "534"
  "625"
  "559"
  "339"
  "240"
  "818"
  "813"
  "694"
  "535"
  "806"
  "193"
  "17"
  "815"
  "745"
  "755"
  "733"
  "805"
  "641"
  "310"
  "173"
  "389"
  "604"
  "800"
  "103"
  "241"
  "427"
  "251"
  "791"
  "711"
  "242"
  "767"
  "771"
  "801"
  "661"
  "763"
  "809"
  "243"
  "749"
  "702"
  "748"
  "794"
  "687"
  "779"
  "808"
  "768"
  "569"
  "799"
  "759"
  "717"
  "491"
  "69"
  "477"
  "499"
  "492"
  "560"
  "494"
  "561"
  "485"
  "18"
  "714"
  "498"
  "488"
  "742"
  "322"
  "698"
  "402"
  "317"
  "719"
  "348"
  "36"
  "707"
  "153"
  "480"
  "770"
  "589"
  "992"
  "993"
  "995"
  "996"
  "999"
  "1001"
  "1002"
  "1003"
  "1004"
  "353"
  "831"
  "8"
  "32"
  "38"
  "57"
  "64"
  "66"
  "68"
  "73"
  "75"
  "79"
  "88"
  "98"
  "100"
  "101"
  "104"
  "107"
  "108"
  "132"
  "137"
  "141"
  "163"
  "165"
  "166"
  "167"
  "203"
  "204"
  "206"
  "210"
  "220"
  "237"
  "259"
  "293"
  "323"
  "367"
  "562"
  "255"
  "112"
  "1033"
  "875"
  "106"
  "229"
  "139"
  "739"
  "769"
  "930"
  "920"
  "773"
  "804"
  "758"
  "735"
  "766"
  "778"
  "760"
  "777"
  "775"
  "782"
  "796"
  "821"
  "762"
  "951"
  "916"
  "889"
  "890"
  "962"
  "893"
  "882"
  "935"
  "948"
  "909"
  "936"
  "957"
  "881"
  "880"
  "913"
  "964"
  "908"
  "959"
  "860"
  "1043"
  "1037"
  "1041"
  "1034"
  "1016"
  "854"
  "960"
  "943"
  "1005"
  "787"
  "1036"
  "972"
  "1007"
  "1039"
  "538"
  "902"
  "737"
  "1014"
  "884"
  "940"
  "788"
  "820"
  "954"
  "645"
  "752"
  "953"
  "642"
  "691"
  "892"
  "955"
  "593"
  "939"
  "360"
  "1012"
  "1038"
  "961"
  "1011"
  "1022"
  "894"
  "710"
  "895"
  "946"
  "674"
  "941"
  "911"
  "1044"
  "886"
  "1040"
  "952"
  "907"
  "1035"
  "150"
  "568"
  "1021"
  "765"
  "1017"
  "1010"
  "390"
  "222"
  "221"
  "667"
  "899"
  "364"
  "903"
  "431"
  "583"
  "40"
  "897"
  "900"
  "670"
  "669"
  "1006"
  "914"
  "313"
  "80"
  "825"
  "607"
  "227"
  "580"
  "923"
  "537"
  "553"
  "109"
  "244"
  "312"
  "226"
  "901"
  "990"
  "693"
  "1000"
  "1013"
  "351"
  "942"
  "862"
  "16"
  "1020"
  "1030"
  "394"
  "134"
  "921"
  "885"
  "554"
  "927"
  "110"
  "590"
  "865"
  "635"
  "170"
  "616"
  "736"
  "586"
  "247"
  "727"
  "49"
  "915"
  "158"
  "817"
  "159"
  "896"
  "912"
  "967"
  "142"
  "918"
  "31"
  "71"
  "542"
  "539"
  "183"
  "552"
  "888"
  "230"
  "395"
  "663"
  "405"
  "584"
  "502"
  "983"
  "503"
  "595"
  "588"
  "212"
  "708"
  "837"
  "697"
  "582"
  "652"
  "823"
  "919"
  "257"
  "703"
  "454"
  "600"
  "85"
  "647"
  "671"
  "201"
  "236"
  "898"
  "11"
  "620"
  "969"
  "956"
  "384"
  "958"
  "42"
  "262"
  "239"
  "291"
  "910"
  "643"
  "728"
  "981"
  "655"
  "998"
  "979"
  "294"
  "626"
  "591"
  "627"
  "592"
  "146"
  "991"
  "827"
  "876"
  "988"
  "987"
  "989"
  "977"
  "835"
  "361"
  "654"
  "849"
  "856"
  "848"
  "844"
  "968"
  "838"
  "718"
  "858"
  "850"
  "265"
  "826"
  "177"
  "841"
  "833"
  "985"
  "686"
  "398"
  "388"
  "678"
  "679"
  "25"
  "878"
  "847"
  "846"
  "879"
  "845"
  "695"
  "944"
  "994"
  "883"
  "855"
  "982"
  "864"
  "906"
  "208"
  "842"
  "932"
  "922"
  "929"
  "1008"
  "891"
  "298"
  "975"
  "160"
  "925"
  "976"
  "443"
  "997"
  "358"
  "917"
  "934"
  "945"
  "297"
  "926"
  "574"
  "148"
  "851"
  "30"
  "986"
  "933"
  "947"
  "94"
  "822"
  "978"
  "509"
  "924"
  "928"
  "965"
  "1015"
  "70"
  "797"
  "1009"
  "966"
  "974"
  "839"
  "984"
  "217"
  "732"
  "510"
  "798"
  "931"
  "576"
  "362"
  "28"
  "1042"
  "319"
  "1019"
  "938"
  "651"
  "873"
  "9"
  "285"
  "874"
  "869"
  "256"
  "283"
  "949"
  "887"
  "260"
  "795"
]

View formatted query View runnable query Explain query View query backtrace

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 (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )

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 ('1028', '46', '603', '1045', '444', '605', '840', '519', '829', '830', '676', '292', '45', '186', '290', '843', '852', '828', '570', '723', '746', '462', '479', '473', '391', '460', '459', '392', '853', '118', '681', '457', '675', '598', '701', '530', '471', '556', '511', '331', '631', '225', '425', '470', '508', '504', '666', '418', '412', '664', '832', '747', '420', '529', '456', '433', '515', '680', '413', '628', '428', '533', '905', '357', '682', '448', '15', '573', '414', '558', '653', '834', '506', '601', '415', '540', '421', '836', '350', '34', '704', '863', '517', '672', '505', '857', '445', '690', '566', '689', '525', '532', '648', '536', '658', '861', '419', '612', '550', '370', '611', '683', '547', '434', '29', '501', '700', '436', '577', '213', '630', '376', '352', '518', '441', '403', '523', '866', '726', '495', '483', '466', '465', '484', '489', '378', '624', '633', '614', '84', '62', '211', '478', '632', '481', '468', '867', '469', '617', '615', '490', '549', '636', '637', '634', '619', '253', '311', '493', '426', '316', '516', '507', '581', '743', '657', '650', '422', '621', '486', '662', '482', '474', '904', '524', '608', '514', '541', '387', '613', '497', '439', '572', '609', '335', '585', '699', '622', '430', '623', '258', '458', '696', '252', '393', '472', '487', '467', '571', '315', '383', '668', '599', '859', '328', '417', '872', '235', '870', '461', '868', '871', '513', '684', '411', '1023', '610', '35', '264', '145', '63', '113', '4', '65', '67', '72', '93', '95', '120', '124', '125', '136', '138', '155', '214', '246', '254', '270', '300', '154', '321', '602', '272', '287', '192', '363', '196', '216', '386', '233', '245', '780', '816', '606', '744', '751', '734', '810', '807', '811', '772', '783', '785', '781', '639', '677', '277', '219', '133', '546', '464', '22', '114', '171', '814', '87', '119', '638', '446', '640', '819', '301', '76', '786', '147', '198', '824', '151', '26', '21', '20', '27', '99', '180', '656', '338', '377', '284', '295', '404', '731', '750', '56', '144', '309', '275', '296', '55', '803', '447', '278', '271', '802', '279', '307', '308', '280', '299', '54', '435', '440', '324', '437', '179', '587', '438', '176', '2', '424', '673', '175', '174', '578', '178', '189', '442', '877', '341', '248', '563', '156', '496', '476', '716', '3', '812', '371', '234', '276', '318', '289', '705', '406', '232', '1', '410', '416', '197', '13', '14', '86', '1025', '39', '385', '168', '37', '41', '44', '61', '78', '81', '82', '83', '91', '105', '117', '126', '135', '161', '169', '205', '207', '238', '261', '266', '267', '274', '282', '90', '43', '97', '33', '659', '793', '764', '754', '774', '784', '761', '740', '753', '776', '688', '757', '665', '792', '756', '729', '349', '89', '629', '738', '152', '709', '288', '50', '223', '722', '720', '721', '724', '725', '594', '269', '215', '545', '565', '564', '527', '92', '567', '74', '528', '520', '195', '730', '6', '557', '96', '500', '396', '522', '741', '194', '127', '7', '596', '548', '543', '365', '531', '551', '544', '521', '512', '432', '111', '685', '644', '660', '19', '715', '209', '286', '77', '231', '397', '53', '320', '706', '649', '712', '618', '429', '172', '713', '263', '218', '692', '162', '48', '534', '625', '559', '339', '240', '818', '813', '694', '535', '806', '193', '17', '815', '745', '755', '733', '805', '641', '310', '173', '389', '604', '800', '103', '241', '427', '251', '791', '711', '242', '767', '771', '801', '661', '763', '809', '243', '749', '702', '748', '794', '687', '779', '808', '768', '569', '799', '759', '717', '491', '69', '477', '499', '492', '560', '494', '561', '485', '18', '714', '498', '488', '742', '322', '698', '402', '317', '719', '348', '36', '707', '153', '480', '770', '589', '992', '993', '995', '996', '999', '1001', '1002', '1003', '1004', '353', '831', '8', '32', '38', '57', '64', '66', '68', '73', '75', '79', '88', '98', '100', '101', '104', '107', '108', '132', '137', '141', '163', '165', '166', '167', '203', '204', '206', '210', '220', '237', '259', '293', '323', '367', '562', '255', '112', '1033', '875', '106', '229', '139', '739', '769', '930', '920', '773', '804', '758', '735', '766', '778', '760', '777', '775', '782', '796', '821', '762', '951', '916', '889', '890', '962', '893', '882', '935', '948', '909', '936', '957', '881', '880', '913', '964', '908', '959', '860', '1043', '1037', '1041', '1034', '1016', '854', '960', '943', '1005', '787', '1036', '972', '1007', '1039', '538', '902', '737', '1014', '884', '940', '788', '820', '954', '645', '752', '953', '642', '691', '892', '955', '593', '939', '360', '1012', '1038', '961', '1011', '1022', '894', '710', '895', '946', '674', '941', '911', '1044', '886', '1040', '952', '907', '1035', '150', '568', '1021', '765', '1017', '1010', '390', '222', '221', '667', '899', '364', '903', '431', '583', '40', '897', '900', '670', '669', '1006', '914', '313', '80', '825', '607', '227', '580', '923', '537', '553', '109', '244', '312', '226', '901', '990', '693', '1000', '1013', '351', '942', '862', '16', '1020', '1030', '394', '134', '921', '885', '554', '927', '110', '590', '865', '635', '170', '616', '736', '586', '247', '727', '49', '915', '158', '817', '159', '896', '912', '967', '142', '918', '31', '71', '542', '539', '183', '552', '888', '230', '395', '663', '405', '584', '502', '983', '503', '595', '588', '212', '708', '837', '697', '582', '652', '823', '919', '257', '703', '454', '600', '85', '647', '671', '201', '236', '898', '11', '620', '969', '956', '384', '958', '42', '262', '239', '291', '910', '643', '728', '981', '655', '998', '979', '294', '626', '591', '627', '592', '146', '991', '827', '876', '988', '987', '989', '977', '835', '361', '654', '849', '856', '848', '844', '968', '838', '718', '858', '850', '265', '826', '177', '841', '833', '985', '686', '398', '388', '678', '679', '25', '878', '847', '846', '879', '845', '695', '944', '994', '883', '855', '982', '864', '906', '208', '842', '932', '922', '929', '1008', '891', '298', '975', '160', '925', '976', '443', '997', '358', '917', '934', '945', '297', '926', '574', '148', '851', '30', '986', '933', '947', '94', '822', '978', '509', '924', '928', '965', '1015', '70', '797', '1009', '966', '974', '839', '984', '217', '732', '510', '798', '931', '576', '362', '28', '1042', '319', '1019', '938', '651', '873', '9', '285', '874', '869', '256', '283', '949', '887', '260', '795');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 52)
6	FOS\ElasticaBundle\Doctrine\ORM\ElasticaToModelTransformer->findByIdentifiers (line 86)
7	FOS\ElasticaBundle\Doctrine\AbstractElasticaToModelTransformer->transform (line 48)
8	FOS\ElasticaBundle\Finder\TransformedFinder->find (line 146)
9	App\Elasticsearch\BaseEsService->getAll (line 72)
10	App\Controller\IndexController->catalogueIndex (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 23)

7.67 ms
(12.73%)

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 INNER JOIN establishment_category ON t0.id = establishment_category.establishment_id WHERE establishment_category.category_id = ?

Parameters:

[
  8
]

View formatted query View runnable query Explain query View query backtrace

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
  INNER JOIN establishment_category ON t0.id = establishment_category.establishment_id
WHERE
  establishment_category.category_id = ?

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 INNER JOIN establishment_category ON t0.id = establishment_category.establishment_id WHERE establishment_category.category_id = 8;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1051)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 980)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2712)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 627)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 396)
8	Doctrine\ORM\PersistentCollection->count (line 182)
9	App\Entity\Category->getEstablishmentCount (line 1635)
10	twig_get_attribute (line 421)
11	__TwigTemplate_5db7a1a2f1a1e20540b47fd07cbbafa4->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 379)
14	Twig\Template->render (line 38)
15	Twig\TemplateWrapper->render (line 280)
16	Twig\Environment->render (line 448)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 78)
20	App\Controller\IndexController->catalogueIndex (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 23)

5.34 ms
(8.85%)

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:

[]

View formatted query View runnable query Explain query View query backtrace

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

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 64)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 182)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 193)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 465)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 238)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	Symfony\Component\Form\Form->createView (line 82)
21	App\Controller\IndexController->catalogueIndex (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 23)

3.82 ms
(6.33%)

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 INNER JOIN job_offert_establishment ON t0.id = job_offert_establishment.establishment_id WHERE job_offert_establishment.job_offert_id = ?

Parameters:

[
  35
]

View formatted query View runnable query Explain query View query backtrace

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
  INNER JOIN job_offert_establishment ON t0.id = job_offert_establishment.establishment_id
WHERE
  job_offert_establishment.job_offert_id = ?

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 INNER JOIN job_offert_establishment ON t0.id = job_offert_establishment.establishment_id WHERE job_offert_establishment.job_offert_id = 35;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1051)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 980)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2712)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 627)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 396)
8	Doctrine\ORM\PersistentCollection->count (line 643)
9	App\Entity\JobOffert->hasEstablishment (line 1635)
10	twig_get_attribute (line 282)
11	__TwigTemplate_5db7a1a2f1a1e20540b47fd07cbbafa4->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 379)
14	Twig\Template->render (line 38)
15	Twig\TemplateWrapper->render (line 280)
16	Twig\Environment->render (line 448)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 78)
20	App\Controller\IndexController->catalogueIndex (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 23)

3.72 ms
(6.18%)

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 WHERE t0.popular_category_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

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
WHERE
  t0.popular_category_id = ?

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 WHERE t0.popular_category_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2708)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 627)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 406)
8	__TwigTemplate_5db7a1a2f1a1e20540b47fd07cbbafa4->doDisplay (line 394)
9	Twig\Template->displayWithErrorHandling (line 367)
10	Twig\Template->display (line 379)
11	Twig\Template->render (line 38)
12	Twig\TemplateWrapper->render (line 280)
13	Twig\Environment->render (line 448)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 78)
17	App\Controller\IndexController->catalogueIndex (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 23)

3.40 ms
(5.64%)

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.logos_id = ?

Parameters:

[
  1045
]

View formatted query View runnable query Explain query View query backtrace

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.logos_id = ?

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.logos_id = 1045;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2708)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 627)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 396)
8	Doctrine\ORM\PersistentCollection->count (line 931)
9	App\Entity\Establishment->hasLogos (line 1635)
10	twig_get_attribute (line 282)
11	__TwigTemplate_5db7a1a2f1a1e20540b47fd07cbbafa4->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 379)
14	Twig\Template->render (line 38)
15	Twig\TemplateWrapper->render (line 280)
16	Twig\Environment->render (line 448)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 78)
20	App\Controller\IndexController->catalogueIndex (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 23)

2.95 ms
(4.89%)

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:

[
  444
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = 444;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1051)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 980)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2712)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 627)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 653)
8	twig_slice (line 683)
9	twig_first (line 486)
10	__TwigTemplate_5db7a1a2f1a1e20540b47fd07cbbafa4->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 379)
13	Twig\Template->render (line 38)
14	Twig\TemplateWrapper->render (line 280)
15	Twig\Environment->render (line 448)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 78)
19	App\Controller\IndexController->catalogueIndex (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 23)

2.70 ms
(4.47%)

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 job_offert_category ON t0.id = job_offert_category.category_id WHERE job_offert_category.job_offert_id = ?

Parameters:

[
  35
]

View formatted query View runnable query Explain query View query backtrace

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 job_offert_category ON t0.id = job_offert_category.category_id
WHERE
  job_offert_category.job_offert_id = ?

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 job_offert_category ON t0.id = job_offert_category.category_id WHERE job_offert_category.job_offert_id = 35;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1051)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 980)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2712)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 627)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 356)
8	__TwigTemplate_5db7a1a2f1a1e20540b47fd07cbbafa4->doDisplay (line 394)
9	Twig\Template->displayWithErrorHandling (line 367)
10	Twig\Template->display (line 379)
11	Twig\Template->render (line 38)
12	Twig\TemplateWrapper->render (line 280)
13	Twig\Environment->render (line 448)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 78)
17	App\Controller\IndexController->catalogueIndex (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 23)

2.44 ms
(4.04%)

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:

[]

View formatted query View runnable query Explain query View query backtrace

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

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 64)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 182)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 193)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 465)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 238)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	Symfony\Component\Form\Form->createView (line 82)
21	App\Controller\IndexController->catalogueIndex (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 23)

2.28 ms
(3.78%)

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:

[]

View formatted query View runnable query Explain query View query backtrace

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_

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_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 64)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 182)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 208)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 465)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 238)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	Symfony\Component\Form\Form->createView (line 90)
21	App\Controller\IndexController->catalogueIndex (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 23)

1.99 ms
(3.30%)

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_ ORDER BY e0_.view_number DESC LIMIT 5

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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_
ORDER BY
  e0_.view_number DESC
LIMIT
  5

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_ ORDER BY e0_.view_number DESC LIMIT 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 47)
7	App\Repository\EstablishmentRepository->findBestView (line 43)
8	App\Controller\IndexController->catalogueIndex (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 23)

1.81 ms
(3.00%)

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 WHERE t0.parent_id = ?

Parameters:

[
  113
]

View formatted query View runnable query Explain query View query backtrace

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
WHERE
  t0.parent_id = ?

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 WHERE t0.parent_id = 113;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2708)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 627)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 396)
8	Doctrine\ORM\PersistentCollection->count (line 1127)
9	twig_length_filter (line 586)
10	__TwigTemplate_5db7a1a2f1a1e20540b47fd07cbbafa4->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 379)
13	Twig\Template->render (line 38)
14	Twig\TemplateWrapper->render (line 280)
15	Twig\Environment->render (line 448)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 78)
19	App\Controller\IndexController->catalogueIndex (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 23)

1.65 ms
(2.74%)

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 ORDER BY t0.score DESC LIMIT 8

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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
ORDER BY
  t0.score DESC
LIMIT
  8

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 ORDER BY t0.score DESC LIMIT 8;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 64)
5	App\Controller\IndexController->catalogueIndex (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 23)

1.50 ms
(2.49%)

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_.score DESC LIMIT 3

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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_.score DESC
LIMIT
  3

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_.score DESC LIMIT 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 35)
7	App\Repository\CategoryRepository->findBestScore (line 42)
8	App\Controller\IndexController->catalogueIndex (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 23)

1.05 ms
(1.75%)

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 WHERE t0.parent_id IS NULL ORDER BY t0.name DESC LIMIT 4

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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
WHERE
  t0.parent_id IS NULL
ORDER BY
  t0.name DESC
LIMIT
  4

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 WHERE t0.parent_id IS NULL ORDER BY t0.name DESC LIMIT 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 63)
5	App\Controller\IndexController->catalogueIndex (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 23)

0.89 ms
(1.47%)

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.landing_page_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

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.landing_page_id = ?

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.landing_page_id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2708)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 627)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 167)
7	Doctrine\Common\Collections\AbstractLazyCollection->first (line 91)
8	App\Controller\IndexController->catalogueIndex (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 23)

0.84 ms
(1.39%)

SELECT j0_.slug AS slug_0, j0_.title AS title_1, j0_.salaire_brut_annuel AS salaire_brut_annuel_2, j0_.salaire_net_annuel AS salaire_net_annuel_3, j0_.salaire_brut_heure AS salaire_brut_heure_4, j0_.salaire_net_heure AS salaire_net_heure_5, j0_.salaire_brut_mensuel AS salaire_brut_mensuel_6, j0_.salaire_net_mensuel AS salaire_net_mensuel_7, j0_.status AS status_8, j0_.type AS type_9, j0_.description AS description_10, j0_.complement_information AS complement_information_11, j0_.advantage AS advantage_12, j0_.prime AS prime_13, j0_.tele_travail AS tele_travail_14, j0_.started_at AS started_at_15, j0_.ended_at AS ended_at_16, j0_.number_position AS number_position_17, j0_.position_status AS position_status_18, j0_.experience AS experience_19, j0_.foreign_language AS foreign_language_20, j0_.profil AS profil_21, j0_.mission AS mission_22, j0_.establishment_description AS establishment_description_23, j0_.reference AS reference_24, j0_.job_start_date AS job_start_date_25, j0_.job_address AS job_address_26, j0_.job_time AS job_time_27, j0_.offert_type AS offert_type_28, j0_.remuneration AS remuneration_29, j0_.offert_link AS offert_link_30, j0_.id AS id_31, j0_.created_at AS created_at_32, j0_.updated_at AS updated_at_33, j0_.operator_id AS operator_id_34 FROM job_offert j0_ WHERE j0_.status = ? AND j0_.ended_at IS NOT NULL AND j0_.ended_at >= ? ORDER BY j0_.created_at DESC

Parameters:

[
  1
  "2026-02-19 00:14:04"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j0_.slug AS slug_0,
  j0_.title AS title_1,
  j0_.salaire_brut_annuel AS salaire_brut_annuel_2,
  j0_.salaire_net_annuel AS salaire_net_annuel_3,
  j0_.salaire_brut_heure AS salaire_brut_heure_4,
  j0_.salaire_net_heure AS salaire_net_heure_5,
  j0_.salaire_brut_mensuel AS salaire_brut_mensuel_6,
  j0_.salaire_net_mensuel AS salaire_net_mensuel_7,
  j0_.status AS status_8,
  j0_.type AS type_9,
  j0_.description AS description_10,
  j0_.complement_information AS complement_information_11,
  j0_.advantage AS advantage_12,
  j0_.prime AS prime_13,
  j0_.tele_travail AS tele_travail_14,
  j0_.started_at AS started_at_15,
  j0_.ended_at AS ended_at_16,
  j0_.number_position AS number_position_17,
  j0_.position_status AS position_status_18,
  j0_.experience AS experience_19,
  j0_.foreign_language AS foreign_language_20,
  j0_.profil AS profil_21,
  j0_.mission AS mission_22,
  j0_.establishment_description AS establishment_description_23,
  j0_.reference AS reference_24,
  j0_.job_start_date AS job_start_date_25,
  j0_.job_address AS job_address_26,
  j0_.job_time AS job_time_27,
  j0_.offert_type AS offert_type_28,
  j0_.remuneration AS remuneration_29,
  j0_.offert_link AS offert_link_30,
  j0_.id AS id_31,
  j0_.created_at AS created_at_32,
  j0_.updated_at AS updated_at_33,
  j0_.operator_id AS operator_id_34
FROM
  job_offert j0_
WHERE
  j0_.status = ?
  AND j0_.ended_at IS NOT NULL
  AND j0_.ended_at >= ?
ORDER BY
  j0_.created_at DESC

SELECT j0_.slug AS slug_0, j0_.title AS title_1, j0_.salaire_brut_annuel AS salaire_brut_annuel_2, j0_.salaire_net_annuel AS salaire_net_annuel_3, j0_.salaire_brut_heure AS salaire_brut_heure_4, j0_.salaire_net_heure AS salaire_net_heure_5, j0_.salaire_brut_mensuel AS salaire_brut_mensuel_6, j0_.salaire_net_mensuel AS salaire_net_mensuel_7, j0_.status AS status_8, j0_.type AS type_9, j0_.description AS description_10, j0_.complement_information AS complement_information_11, j0_.advantage AS advantage_12, j0_.prime AS prime_13, j0_.tele_travail AS tele_travail_14, j0_.started_at AS started_at_15, j0_.ended_at AS ended_at_16, j0_.number_position AS number_position_17, j0_.position_status AS position_status_18, j0_.experience AS experience_19, j0_.foreign_language AS foreign_language_20, j0_.profil AS profil_21, j0_.mission AS mission_22, j0_.establishment_description AS establishment_description_23, j0_.reference AS reference_24, j0_.job_start_date AS job_start_date_25, j0_.job_address AS job_address_26, j0_.job_time AS job_time_27, j0_.offert_type AS offert_type_28, j0_.remuneration AS remuneration_29, j0_.offert_link AS offert_link_30, j0_.id AS id_31, j0_.created_at AS created_at_32, j0_.updated_at AS updated_at_33, j0_.operator_id AS operator_id_34 FROM job_offert j0_ WHERE j0_.status = 1 AND j0_.ended_at IS NOT NULL AND j0_.ended_at >= '2026-02-19 00:14:04' ORDER BY j0_.created_at DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 34)
7	App\Repository\JobOffertRepository->findByStatusEndedAt (line 68)
8	App\Controller\IndexController->catalogueIndex (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 23)

0.79 ms
(1.31%)

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_.id ASC LIMIT 40

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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_.id ASC
LIMIT
  40

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_.id ASC LIMIT 40;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 29)
7	App\Repository\SubPrefectureRepository->findTeenCities (line 83)
8	App\Controller\IndexController->catalogueIndex (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 23)

0.44 ms
(0.73%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 65)
6	App\Controller\IndexController->catalogueIndex (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 23)

0.38 ms
(0.62%)

SELECT l0_.title AS title_0, l0_.description AS description_1, l0_.link AS link_2, l0_.created_at AS created_at_3, l0_.updated_at AS updated_at_4, l0_.id AS id_5 FROM landing_page l0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.title AS title_0,
  l0_.description AS description_1,
  l0_.link AS link_2,
  l0_.created_at AS created_at_3,
  l0_.updated_at AS updated_at_4,
  l0_.id AS id_5
FROM
  landing_page l0_

SELECT l0_.title AS title_0, l0_.description AS description_1, l0_.link AS link_2, l0_.created_at AS created_at_3, l0_.updated_at AS updated_at_4, l0_.id AS id_5 FROM landing_page l0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 52)
7	App\Repository\LandingPageRepository->getRandom (line 67)
8	App\Controller\IndexController->catalogueIndex (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 23)

0.26 ms
(0.42%)

SELECT t0.name AS name_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM popular_category t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.id AS id_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4
FROM
  popular_category t0

SELECT t0.name AS name_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM popular_category t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 66)
6	App\Controller\IndexController->catalogueIndex (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 23)

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\Category	No errors.
App\Entity\PopularCategory	No errors.
App\Entity\Quotation	No errors.
App\Entity\Establishment	No errors.
App\Entity\JobOffert	No errors.
App\Entity\Region	No errors.
App\Entity\Commune	No errors.
App\Entity\City	No errors.
App\Entity\Quartier	No errors.
App\Entity\SubPrefecture	No errors.
App\Entity\Prefecture	No errors.
App\Entity\Campagne	No errors.
App\Entity\Operator	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\Amenity	No errors.
App\Entity\LandingPage	No errors.

Symfony Profiler

POST http://193.70.3.237/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping