Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.28 ms
(80.88%)
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
  5565
  54301
  96503
  152508
  210355
  312919
  384373
  384972
  385316
  385674
  387325
  387785
  389560
  397579
  397664
  398543
  399563
  400715
  400987
  404185
  409984
  411823
  414226
  424419
  426394
  427181
  427770
  427949
  429941
  443044
  445024
  447773
  448568
  454421
  456721
  456937
  459096
  460550
  470214
  470461
  472580
  474451
  475395
  476995
  481466
  482039
  484413
  488293
  489032
  490306
  490310
  491447
  491790
  495238
  497025
  519161
  519717
  524245
  545531
  557787
  566231
  568025
  580393
  585410
  589824
  591594
  593098
  593144
  594853
  596322
  603340
  609551
  612329
  623147
  635786
  638302
  649586
  651794
  663438
  663921
  663964
  667897
  669754
  675956
  677270
  678221
  684977
  693322
  693388
  695151
  709309
  715698
  724628
  728172
  734693
  734725
  738901
  740545
  740965
  747607
  755203
  755411
  761385
  763349
  764524
  768884
  769158
  771211
  771867
  776651
  790664
  795409
  797240
  797262
  799503
  801408
  808238
  813578
  818999
  821294
]
20.38 ms
(12.85%)
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
  818999
  821294
  210355
  385674
  568025
  448568
  456937
  470214
  519161
  454421
  476995
  470461
  491447
  495238
  524245
  385316
  400715
  580393
  400987
  429941
  490306
  409984
  426394
  813578
  557787
  545531
  663438
  667897
  669754
  675956
  678221
  695151
  651794
  663921
  677270
  684977
  596322
  635786
  638302
  594853
  603340
  593098
  589824
  593144
  776651
  795409
  799503
  808238
  734693
  747607
  761385
  764524
  769158
  797240
  797262
  728172
  740545
  771211
  768884
  734725
  738901
  740965
  755411
  771867
  709309
  801408
  152508
  404185
  424419
  491790
  612329
  475395
  460550
  497025
  427949
  649586
  459096
  482039
  489032
  566231
  663964
  591594
  474451
  384373
  387325
  387785
  490310
  715698
  481466
  427770
  519717
  312919
  389560
  397664
  472580
  447773
  397579
  411823
  384972
  54301
  96503
  398543
  445024
  443044
  427181
  693388
  693322
  623147
  585410
  609551
  763349
  790664
  724628
  755203
  414226
  5565
  399563
  484413
  488293
  456721
]
2.80 ms
(1.77%)
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
  5565
  54301
  96503
  152508
  210355
  312919
  384373
  384972
  385316
  385674
  387325
  387785
  389560
  397579
  397664
  398543
  399563
  400715
  400987
  404185
  409984
  411823
  414226
  424419
  426394
  427181
  427770
  427949
  429941
  443044
  445024
  447773
  448568
  454421
  456721
  456937
  459096
  460550
  470214
  470461
  472580
  474451
  475395
  476995
  481466
  482039
  484413
  488293
  489032
  490306
  490310
  491447
  491790
  495238
  497025
  519161
  519717
  524245
  545531
  557787
  566231
  568025
  580393
  585410
  589824
  591594
  593098
  593144
  594853
  596322
  603340
  609551
  612329
  623147
  635786
  638302
  649586
  651794
  663438
  663921
  663964
  667897
  669754
  675956
  677270
  678221
  684977
  693322
  693388
  695151
  709309
  715698
  724628
  728172
  734693
  734725
  738901
  740545
  740965
  747607
  755203
  755411
  761385
  763349
  764524
  768884
  769158
  771211
  771867
  776651
  790664
  795409
  797240
  797262
  799503
  801408
  808238
  813578
  818999
  821294
]
2.02 ms
(1.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.85 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "natural tits blonde"
]
1.81 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "натуральная натуральные сиськ без силикон беловолосая"
]
1.46 ms
(0.92%)
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.