Query Metrics

7 Database Queries
7 Different statements
385.25 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
211.33 ms
(54.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hair teen анал"
]
150.14 ms
(38.97%)
1
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  382888
  412749
  416737
  417366
  417952
  420836
  427246
  428655
  429384
  441567
  441584
  444338
  453790
  459233
  479973
  491487
  492280
  496087
  496750
  502774
  510679
  511862
  512882
  530795
  532798
  533724
  534040
  536251
  543637
  556166
  572028
  574924
  575095
  575212
  590165
  594162
  594226
  594463
  595446
  595515
  596594
  596995
  597567
  597803
  597987
  598010
  598478
  598599
  598796
  598805
  602014
  603464
  604245
  604259
  609645
  610657
  612718
  620922
  624184
  634159
  635064
  637690
  644246
  650118
  652882
  653229
  659324
  662047
  666458
  678125
  683877
  684145
  693111
  698101
  709837
  718690
  719214
  720372
  720375
  721329
  721419
  722592
  722629
  722899
  727852
  728226
  728745
  731485
  731984
  732303
  735957
  740651
  742144
  742941
  743232
  747447
  748407
  748787
  749990
  752725
  753031
  753800
  753911
  754182
  756196
  760919
  773600
  777138
  786522
  789273
  794809
  798986
  800575
  817660
  818860
  819198
  819677
  823491
  823721
  825018
]
14.77 ms
(3.83%)
1
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  722592
  718690
  721419
  597987
  598805
  597567
  603464
  637690
  590165
  594226
  598010
  620922
  597803
  598599
  610657
  612718
  773600
  798986
  727852
  728226
  756196
  742941
  748787
  732303
  635064
  441584
  459233
  510679
  678125
  491487
  575212
  427246
  823721
  817660
  819198
  650118
  652882
  693111
  719214
  720375
  666458
  683877
  698101
  720372
  556166
  598796
  644246
  596995
  598478
  753031
  735957
  742144
  754182
  748407
  760919
  728745
  731485
  743232
  749990
  709837
  789273
  417366
  818860
  819677
  825018
  492280
  721329
  722629
  722899
  653229
  659324
  662047
  596594
  595446
  602014
  594162
  595515
  604259
  800575
  740651
  753800
  794809
  752725
  753911
  731984
  747447
  609645
  777138
  786522
  575095
  536251
  574924
  684145
  594463
  624184
  634159
  604245
  444338
  496087
  382888
  412749
  416737
  420836
  428655
  417952
  441567
  429384
  823491
  479973
  453790
  532798
  502774
  511862
  512882
  530795
  496750
  533724
  534040
  543637
  572028
]
3.53 ms
(0.92%)
1
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  382888
  412749
  416737
  417366
  417952
  420836
  427246
  428655
  429384
  441567
  441584
  444338
  453790
  459233
  479973
  491487
  492280
  496087
  496750
  502774
  510679
  511862
  512882
  530795
  532798
  533724
  534040
  536251
  543637
  556166
  572028
  574924
  575095
  575212
  590165
  594162
  594226
  594463
  595446
  595515
  596594
  596995
  597567
  597803
  597987
  598010
  598478
  598599
  598796
  598805
  602014
  603464
  604245
  604259
  609645
  610657
  612718
  620922
  624184
  634159
  635064
  637690
  644246
  650118
  652882
  653229
  659324
  662047
  666458
  678125
  683877
  684145
  693111
  698101
  709837
  718690
  719214
  720372
  720375
  721329
  721419
  722592
  722629
  722899
  727852
  728226
  728745
  731485
  731984
  732303
  735957
  740651
  742144
  742941
  743232
  747447
  748407
  748787
  749990
  752725
  753031
  753800
  753911
  754182
  756196
  760919
  773600
  777138
  786522
  789273
  794809
  798986
  800575
  817660
  818860
  819198
  819677
  823491
  823721
  825018
]
1.94 ms
(0.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hair teen anal"
]
1.79 ms
(0.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hair teen анал"
]
1.73 ms
(0.45%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No loaded entities.