Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.61 ms
(78.81%)
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
  72431
  314128
  382862
  385262
  400191
  405525
  405850
  405977
  406990
  407292
  407494
  408797
  410843
  413890
  415566
  416817
  416959
  418959
  418963
  419136
  421017
  425961
  426540
  427362
  428474
  429196
  430240
  430630
  430829
  439534
  442745
  443003
  443472
  448667
  450998
  452084
  452247
  453450
  459907
  460590
  460642
  461903
  464327
  468641
  469434
  469475
  471522
  472506
  476252
  480786
  484126
  487509
  494752
  508430
  512217
  512222
  513059
  517601
  517650
  518312
  520151
  524165
  524856
  530845
  534250
  534293
  542188
  546944
  554386
  557503
  560204
  563149
  563217
  563228
  563449
  565149
  566664
  579113
  586681
  587416
  590872
  595769
  600237
  603971
  606164
  607618
  608756
  609210
  612423
  621965
  637123
  652572
  681215
  687461
  688073
  700670
  713639
  716282
  728336
  752163
  789724
  792609
  792610
  792612
  792617
  792632
  801906
  802763
  804771
  807533
  808467
  810902
  814923
  814951
  815278
  815885
  816569
  816949
  821053
  823222
]
23.66 ms
(14.97%)
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
  439534
  450998
  524165
  452084
  508430
  512222
  554386
  579113
  542188
  681215
  652572
  621965
  590872
  637123
  586681
  603971
  608756
  464327
  471522
  609210
  416959
  430630
  484126
  385262
  382862
  314128
  72431
  405525
  405977
  405850
  407494
  408797
  426540
  442745
  406990
  418963
  410843
  413890
  415566
  419136
  421017
  425961
  428474
  430829
  418959
  429196
  430240
  443003
  443472
  814923
  814951
  816949
  823222
  815885
  816569
  815278
  821053
  469434
  476252
  448667
  452247
  453450
  459907
  460642
  468641
  469475
  487509
  513059
  517650
  524856
  530845
  534250
  494752
  517601
  520151
  534293
  512217
  518312
  460590
  461903
  472506
  480786
  546944
  566664
  557503
  563217
  563228
  563449
  565149
  688073
  687461
  713639
  716282
  560204
  563149
  606164
  587416
  595769
  600237
  789724
  792632
  801906
  804771
  792610
  792612
  807533
  808467
  810902
  728336
  752163
  607618
  612423
  700670
  792609
  792617
  802763
  400191
  407292
  416817
  427362
]
2.27 ms
(1.44%)
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
  72431
  314128
  382862
  385262
  400191
  405525
  405850
  405977
  406990
  407292
  407494
  408797
  410843
  413890
  415566
  416817
  416959
  418959
  418963
  419136
  421017
  425961
  426540
  427362
  428474
  429196
  430240
  430630
  430829
  439534
  442745
  443003
  443472
  448667
  450998
  452084
  452247
  453450
  459907
  460590
  460642
  461903
  464327
  468641
  469434
  469475
  471522
  472506
  476252
  480786
  484126
  487509
  494752
  508430
  512217
  512222
  513059
  517601
  517650
  518312
  520151
  524165
  524856
  530845
  534250
  534293
  542188
  546944
  554386
  557503
  560204
  563149
  563217
  563228
  563449
  565149
  566664
  579113
  586681
  587416
  590872
  595769
  600237
  603971
  606164
  607618
  608756
  609210
  612423
  621965
  637123
  652572
  681215
  687461
  688073
  700670
  713639
  716282
  728336
  752163
  789724
  792609
  792610
  792612
  792617
  792632
  801906
  802763
  804771
  807533
  808467
  810902
  814923
  814951
  815278
  815885
  816569
  816949
  821053
  823222
]
2.25 ms
(1.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "facesitting young"
]
2.16 ms
(1.37%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "фейсситтинг young"
]
1.53 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "фейсситтинг young"
]

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.