Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.88 ms
(79.77%)
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
  446182
  449545
  462848
  462878
  463086
  468342
  476337
  477166
  499721
  508147
  512946
  512987
  518024
  529269
  534590
  536632
  557007
  558067
  558918
  563969
  565721
  565976
  577568
  578704
  586178
  589672
  592644
  593985
  594531
  595340
  596941
  605594
  610322
  616849
  619891
  623961
  624839
  626452
  652690
  659411
  659974
  660452
  674021
  674907
  680443
  682989
  684695
  686845
  695878
  696116
  696124
  696984
  703584
  707177
  708263
  708964
  713208
  717366
  723551
  724287
  725714
  725788
  726455
  727644
  727736
  728468
  731013
  734047
  736363
  737274
  737450
  737759
  746171
  750831
  755498
  756245
  756294
  756704
  756990
  757808
  759891
  760994
  761031
  761600
  766786
  768659
  769013
  769299
  769465
  771171
  771355
  775173
  778379
  779678
  784649
  784981
  784983
  785204
  785945
  787007
  788133
  791160
  791731
  791844
  796570
  798183
  798489
  798635
  799814
  800679
  804062
  804552
  806855
  810059
  812842
  813065
  813630
  817716
  819104
  819731
]
21.00 ms
(13.75%)
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
  723551
  813630
  819104
  817716
  819731
  463086
  468342
  462878
  446182
  449545
  462848
  476337
  477166
  499721
  536632
  512946
  529269
  534590
  508147
  512987
  518024
  578704
  565721
  565976
  557007
  563969
  652690
  659411
  659974
  674907
  696116
  684695
  713208
  717366
  660452
  674021
  680443
  682989
  686845
  695878
  696124
  703584
  708263
  558067
  558918
  577568
  589672
  593985
  610322
  586178
  594531
  595340
  596941
  605594
  623961
  624839
  592644
  616849
  788133
  791731
  796570
  798489
  798635
  799814
  775173
  784983
  787007
  791160
  798183
  800679
  804552
  806855
  810059
  813065
  737450
  737759
  757808
  760994
  761600
  766786
  769299
  784981
  785204
  785945
  791844
  804062
  812842
  724287
  725714
  731013
  734047
  736363
  756245
  759891
  725788
  727736
  755498
  761031
  768659
  769465
  726455
  728468
  737274
  756704
  771171
  771355
  727644
  746171
  750831
  756294
  756990
  769013
  619891
  626452
  696984
  707177
  708964
  778379
  779678
  784649
]
3.20 ms
(2.10%)
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
  446182
  449545
  462848
  462878
  463086
  468342
  476337
  477166
  499721
  508147
  512946
  512987
  518024
  529269
  534590
  536632
  557007
  558067
  558918
  563969
  565721
  565976
  577568
  578704
  586178
  589672
  592644
  593985
  594531
  595340
  596941
  605594
  610322
  616849
  619891
  623961
  624839
  626452
  652690
  659411
  659974
  660452
  674021
  674907
  680443
  682989
  684695
  686845
  695878
  696116
  696124
  696984
  703584
  707177
  708263
  708964
  713208
  717366
  723551
  724287
  725714
  725788
  726455
  727644
  727736
  728468
  731013
  734047
  736363
  737274
  737450
  737759
  746171
  750831
  755498
  756245
  756294
  756704
  756990
  757808
  759891
  760994
  761031
  761600
  766786
  768659
  769013
  769299
  769465
  771171
  771355
  775173
  778379
  779678
  784649
  784981
  784983
  785204
  785945
  787007
  788133
  791160
  791731
  791844
  796570
  798183
  798489
  798635
  799814
  800679
  804062
  804552
  806855
  810059
  812842
  813065
  813630
  817716
  819104
  819731
]
1.83 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "creampie panties"
]
1.74 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "creampie трусик нижн бел"
]
1.50 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "creampie трусик нижн бел"
]

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.