Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.20 ms
(82.42%)
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
  67006
  76645
  148582
  182340
  188561
  203927
  249873
  269287
  287436
  309480
  366011
  382176
  382290
  382347
  382485
  384126
  385285
  386765
  387334
  390012
  391684
  391701
  391956
  393585
  393756
  394198
  397019
  398263
  407151
  407173
  413707
  415753
  416795
  418697
  421637
  421776
  422186
  424182
  425775
  426672
  426809
  439749
  441561
  441563
  445571
  450776
  455633
  458346
  461697
  466336
  466808
  467956
  471460
  471571
  473388
  476049
  477407
  478324
  479567
  481432
  484549
  485281
  486409
  491493
  496039
  496293
  497216
  499018
  500776
  502031
  503032
  507427
  509794
  517764
  517807
  519274
  520305
  520428
  524103
  526645
  528026
  528505
  533968
  537281
  538672
  540132
  542331
  551419
  552009
  564621
  569321
  573426
  573475
  574642
  575212
  578815
  579821
  582334
  584453
  584564
  585618
  589611
  592371
  596622
  597135
  605918
  609897
  617214
  622876
  624501
  645596
  645605
  649056
  655320
  671518
  675396
  685613
  688403
  761749
  811435
]
22.10 ms
(12.29%)
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
  67006
  188561
  384126
  528505
  649056
  578815
  416795
  471460
  455633
  509794
  520305
  507427
  551419
  585618
  589611
  441563
  502031
  517764
  573475
  575212
  391684
  287436
  390012
  421637
  426672
  382290
  466336
  421776
  481432
  685613
  573426
  624501
  450776
  478324
  445571
  499018
  524103
  538672
  622876
  461697
  519274
  617214
  439749
  391701
  484549
  500776
  569321
  385285
  382485
  497216
  203927
  471571
  496039
  542331
  675396
  645596
  148582
  655320
  473388
  393585
  609897
  671518
  426809
  394198
  596622
  466808
  486409
  584564
  386765
  413707
  415753
  441561
  503032
  574642
  579821
  761749
  467956
  476049
  526645
  485281
  533968
  425775
  391956
  76645
  645605
  269287
  582334
  407173
  520428
  491493
  605918
  422186
  517807
  393756
  418697
  552009
  584453
  309480
  382176
  387334
  397019
  537281
  540132
  564621
  811435
  182340
  424182
  479567
  249873
  688403
  592371
  597135
  366011
  458346
  528026
  496293
  382347
  398263
  407151
  477407
]
2.91 ms
(1.62%)
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
  67006
  76645
  148582
  182340
  188561
  203927
  249873
  269287
  287436
  309480
  366011
  382176
  382290
  382347
  382485
  384126
  385285
  386765
  387334
  390012
  391684
  391701
  391956
  393585
  393756
  394198
  397019
  398263
  407151
  407173
  413707
  415753
  416795
  418697
  421637
  421776
  422186
  424182
  425775
  426672
  426809
  439749
  441561
  441563
  445571
  450776
  455633
  458346
  461697
  466336
  466808
  467956
  471460
  471571
  473388
  476049
  477407
  478324
  479567
  481432
  484549
  485281
  486409
  491493
  496039
  496293
  497216
  499018
  500776
  502031
  503032
  507427
  509794
  517764
  517807
  519274
  520305
  520428
  524103
  526645
  528026
  528505
  533968
  537281
  538672
  540132
  542331
  551419
  552009
  564621
  569321
  573426
  573475
  574642
  575212
  578815
  579821
  582334
  584453
  584564
  585618
  589611
  592371
  596622
  597135
  605918
  609897
  617214
  622876
  624501
  645596
  645605
  649056
  655320
  671518
  675396
  685613
  688403
  761749
  811435
]
2.02 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð▒ÐÇÐÄð¢ðÁÐéð║Ðâ ÐÇð░ð║ð¥ð╝ ð▓ ð║ð©Ðüð║ÐÔǪ"
]
1.63 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "черноволосая рак в вагин"
]
1.43 ms
(0.79%)
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.