Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.23 ms
(83.72%)
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
  73052
  352142
  375092
  391976
  397567
  398869
  401817
  402739
  405950
  411382
  416751
  417366
  418201
  418321
  419648
  420226
  428848
  429106
  432703
  436965
  440068
  442035
  444271
  445099
  446519
  446785
  446798
  449001
  449421
  453154
  456866
  458109
  461246
  461641
  464019
  464911
  465250
  466981
  468661
  469188
  469428
  470493
  471029
  473432
  478069
  478523
  478726
  479706
  479708
  484880
  485846
  486640
  489337
  495480
  496095
  496120
  497641
  499252
  499269
  499941
  503673
  510685
  512496
  514244
  515307
  515451
  517349
  518671
  520566
  522283
  523614
  530436
  545616
  547546
  550747
  555560
  556901
  560673
  568261
  571401
  576614
  579381
  582529
  583558
  584886
  589243
  590552
  590553
  599145
  612068
  618364
  618799
  624174
  663306
  692750
  697460
  703915
  704039
  712153
  740556
  742727
  776716
  777019
  777279
  782844
  785073
  785602
  787502
  788521
  796794
  797280
  800707
  800930
  803835
  806861
  806887
  808562
  809967
  810635
  817226
]
15.43 ms
(9.63%)
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
  612068
  703915
  442035
  436965
  449421
  560673
  582529
  663306
  568261
  808562
  479708
  471029
  456866
  583558
  391976
  712153
  499252
  589243
  599145
  470493
  417366
  787502
  806861
  518671
  545616
  411382
  800930
  796794
  446785
  419648
  405950
  496095
  579381
  704039
  517349
  478069
  499941
  464019
  555560
  576614
  469188
  461641
  478726
  515451
  571401
  497641
  418321
  418201
  484880
  499269
  522283
  479706
  458109
  464911
  556901
  785073
  788521
  800707
  810635
  428848
  469428
  523614
  512496
  397567
  461246
  446798
  777279
  740556
  785602
  520566
  515307
  692750
  624174
  618799
  590553
  590552
  468661
  503673
  73052
  817226
  465250
  446519
  510685
  485846
  782844
  803835
  432703
  478523
  495480
  809967
  401817
  398869
  584886
  416751
  402739
  466981
  352142
  486640
  514244
  806887
  440068
  473432
  489337
  453154
  530436
  777019
  797280
  697460
  776716
  449001
  445099
  429106
  444271
  375092
  420226
  550747
  742727
  547546
  618364
  496120
]
2.84 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
  73052
  352142
  375092
  391976
  397567
  398869
  401817
  402739
  405950
  411382
  416751
  417366
  418201
  418321
  419648
  420226
  428848
  429106
  432703
  436965
  440068
  442035
  444271
  445099
  446519
  446785
  446798
  449001
  449421
  453154
  456866
  458109
  461246
  461641
  464019
  464911
  465250
  466981
  468661
  469188
  469428
  470493
  471029
  473432
  478069
  478523
  478726
  479706
  479708
  484880
  485846
  486640
  489337
  495480
  496095
  496120
  497641
  499252
  499269
  499941
  503673
  510685
  512496
  514244
  515307
  515451
  517349
  518671
  520566
  522283
  523614
  530436
  545616
  547546
  550747
  555560
  556901
  560673
  568261
  571401
  576614
  579381
  582529
  583558
  584886
  589243
  590552
  590553
  599145
  612068
  618364
  618799
  624174
  663306
  692750
  697460
  703915
  704039
  712153
  740556
  742727
  776716
  777019
  777279
  782844
  785073
  785602
  787502
  788521
  796794
  797280
  800707
  800930
  803835
  806861
  806887
  808562
  809967
  810635
  817226
]
2.14 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс игрушк домашн любительск"
]
2.00 ms
(1.25%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.94 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "секс игрушка домашнее…"
]
1.75 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.