Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.78 ms
(80.82%)
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
  396609
  396744
  397358
  397960
  399414
  400946
  410319
  413593
  414342
  415961
  416596
  416626
  418142
  418661
  418821
  419420
  421415
  426284
  426301
  427970
  429594
  429844
  430262
  432927
  432933
  442990
  443242
  445275
  446165
  447098
  448405
  448851
  448854
  451246
  451261
  451560
  457751
  460804
  461673
  463493
  465128
  465651
  465808
  467904
  468046
  475811
  476055
  483742
  486150
  486510
  486776
  488817
  489676
  489812
  491299
  492168
  494617
  496013
  497695
  498319
  498483
  501384
  503105
  504781
  509429
  509820
  511235
  511240
  512129
  512351
  517572
  517782
  518055
  519095
  519481
  521864
  524062
  529034
  530623
  531352
  533376
  536292
  536580
  536889
  537931
  540944
  541859
  542610
  546315
  547481
  550882
  551440
  551886
  552699
  552704
  555124
  560348
  561021
  565246
  567127
  568655
  568981
  571968
  571999
  577316
  579624
  581781
  648859
  651136
  656913
  660399
  661256
  664794
  665957
  669012
  669361
  669376
  696450
  700291
]
18.46 ms
(12.45%)
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
  418821
  426301
  448851
  451560
  465651
  465808
  467904
  475811
  413593
  418142
  427970
  432933
  448405
  396744
  399414
  415961
  426284
  447098
  421415
  445275
  451246
  460804
  509820
  512129
  517782
  489812
  491299
  498483
  509429
  511235
  518055
  521864
  496013
  498319
  512351
  517572
  529034
  483742
  486150
  486510
  489676
  492168
  501384
  519481
  531352
  661256
  494617
  396609
  397358
  397960
  400946
  410319
  419420
  414342
  416596
  416626
  429844
  430262
  432927
  418661
  429594
  442990
  443242
  555124
  448854
  451261
  463493
  465128
  468046
  446165
  457751
  461673
  486776
  497689
  497695
  519095
  537931
  503105
  504781
  524062
  533376
  536580
  511240
  530623
  536292
  536889
  476055
  488817
  540944
  542610
  547481
  567127
  571999
  577316
  541859
  550882
  551440
  552704
  565246
  568981
  571968
  579624
  551886
  552699
  560348
  568655
  581781
  651136
  660399
  665957
  696450
  648859
  656913
  700291
  664794
  669012
  669361
  669376
  546315
  561021
]
2.64 ms
(1.78%)
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
  396609
  396744
  397358
  397960
  399414
  400946
  410319
  413593
  414342
  415961
  416596
  416626
  418142
  418661
  418821
  419420
  421415
  426284
  426301
  427970
  429594
  429844
  430262
  432927
  432933
  442990
  443242
  445275
  446165
  447098
  448405
  448851
  448854
  451246
  451261
  451560
  457751
  460804
  461673
  463493
  465128
  465651
  465808
  467904
  468046
  475811
  476055
  483742
  486150
  486510
  486776
  488817
  489676
  489812
  491299
  492168
  494617
  496013
  497695
  498319
  498483
  501384
  503105
  504781
  509429
  509820
  511235
  511240
  512129
  512351
  517572
  517782
  518055
  519095
  519481
  521864
  524062
  529034
  530623
  531352
  533376
  536292
  536580
  536889
  537931
  540944
  541859
  542610
  546315
  547481
  550882
  551440
  551886
  552699
  552704
  555124
  560348
  561021
  565246
  567127
  568655
  568981
  571968
  571999
  577316
  579624
  581781
  648859
  651136
  656913
  660399
  661256
  664794
  665957
  669012
  669361
  669376
  696450
  700291
]
2.16 ms
(1.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny huge"
]
1.88 ms
(1.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые огромные"
]
1.62 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.