Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.44 ms
(86.10%)
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
  405525
  407444
  407721
  411845
  412396
  415566
  419710
  419950
  420515
  424927
  435211
  442414
  443649
  456448
  456616
  457310
  457825
  457975
  459357
  460079
  460893
  464388
  464424
  467564
  468480
  468540
  469483
  469586
  472266
  472543
  473660
  475752
  478473
  478665
  481766
  482610
  491401
  491429
  495686
  497469
  497531
  504825
  505827
  509503
  510461
  514097
  514106
  515669
  518745
  519877
  521316
  521810
  522134
  525624
  525634
  526556
  531065
  533978
  534561
  534680
  535014
  537481
  538703
  541808
  543518
  548848
  550633
  551817
  554912
  559575
  561391
  561452
  562898
  564741
  566140
  569919
  570737
  571042
  571358
  572189
  575441
  579123
  579648
  581876
  585637
  586553
  586910
  590954
  591875
  592862
  594933
  597839
  598422
  600586
  601347
  602194
  604431
  604436
  605639
  606467
  606482
  606929
  609165
  610039
  610766
  611950
  614097
  616097
  617137
  618293
  620150
  625443
  626849
  637460
  640837
  642702
  664444
  673577
  681104
  690902
]
13.73 ms
(8.54%)
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
  457310
  472543
  456616
  464388
  538703
  515669
  519877
  468480
  475752
  566140
  571358
  579123
  579648
  562898
  569919
  581876
  600586
  594933
  602194
  642702
  419710
  459357
  509503
  526556
  525624
  521810
  591875
  592862
  534680
  495686
  505827
  605639
  420515
  481766
  442414
  457825
  457975
  468540
  473660
  521316
  537481
  571042
  664444
  618293
  610039
  597839
  611950
  472266
  478665
  586553
  497469
  514106
  535014
  550633
  548848
  572189
  620150
  616097
  625443
  510461
  637460
  606482
  405525
  407721
  424927
  570737
  690902
  681104
  610766
  626849
  443649
  617137
  531065
  407444
  419950
  460893
  467564
  673577
  590954
  614097
  585637
  604431
  412396
  456448
  561452
  469586
  575441
  606467
  601347
  533978
  609165
  478473
  497531
  435211
  469483
  491401
  514097
  554912
  559575
  598422
  640837
  604436
  534561
  491429
  522134
  541808
  606929
  464424
  586910
  543518
  415566
  411845
  482610
  460079
  525634
  504825
  518745
  564741
  551817
  561391
]
2.42 ms
(1.51%)
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
  405525
  407444
  407721
  411845
  412396
  415566
  419710
  419950
  420515
  424927
  435211
  442414
  443649
  456448
  456616
  457310
  457825
  457975
  459357
  460079
  460893
  464388
  464424
  467564
  468480
  468540
  469483
  469586
  472266
  472543
  473660
  475752
  478473
  478665
  481766
  482610
  491401
  491429
  495686
  497469
  497531
  504825
  505827
  509503
  510461
  514097
  514106
  515669
  518745
  519877
  521316
  521810
  522134
  525624
  525634
  526556
  531065
  533978
  534561
  534680
  535014
  537481
  538703
  541808
  543518
  548848
  550633
  551817
  554912
  559575
  561391
  561452
  562898
  564741
  566140
  569919
  570737
  571042
  571358
  572189
  575441
  579123
  579648
  581876
  585637
  586553
  586910
  590954
  591875
  592862
  594933
  597839
  598422
  600586
  601347
  602194
  604431
  604436
  605639
  606467
  606482
  606929
  609165
  610039
  610766
  611950
  614097
  616097
  617137
  618293
  620150
  625443
  626849
  637460
  640837
  642702
  664444
  673577
  681104
  690902
]
2.09 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ðÁð▒ÐâÐé Ðü Ðüð©ð╗ð©ð║ð¥ð¢ð¥ð▓ð¥ð╣ ð¢ð░ÔÔǪ"
]
1.40 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс силиконов на"
]
1.32 ms
(0.82%)
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.