Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
166.47 ms
(83.34%)
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
  33459
  405050
  414337
  425206
  445737
  447500
  451256
  467608
  506328
  522858
  523856
  525657
  527428
  530010
  530381
  530624
  531109
  531116
  531225
  531232
  531420
  532679
  532789
  532792
  533697
  534627
  536339
  537885
  537908
  540404
  540573
  542566
  542590
  543615
  543918
  544797
  544803
  544823
  545424
  545851
  550196
  550307
  554462
  565247
  565253
  565255
  567304
  568177
  576690
  577331
  582549
  583640
  583675
  590411
  591680
  596462
  597266
  598057
  599902
  599945
  600194
  600334
  600365
  601576
  604369
  604517
  605338
  606501
  606578
  614401
  617412
  624179
  628086
  629899
  631195
  632611
  632623
  632673
  632694
  633816
  634145
  635275
  636311
  636321
  636598
  637022
  637031
  637074
  637143
  637416
  639793
  639802
  640767
  641130
  641141
  642038
  647969
  648499
  648815
  650762
  651188
  653447
  674978
  675000
  676016
  676107
  678028
  678067
  678161
  679728
  680126
  680186
  681637
  697001
  716882
  720938
  731665
  748244
  748389
  778359
]
23.35 ms
(11.69%)
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
  748244
  617412
  629899
  632611
  632623
  641130
  697001
  720938
  405050
  506328
  576690
  545851
  590411
  636598
  467608
  681637
  591680
  604517
  531420
  543918
  675000
  635275
  540573
  532789
  577331
  676016
  680186
  451256
  33459
  425206
  522858
  525657
  530010
  530381
  530624
  531225
  531232
  534627
  537885
  537908
  532792
  536339
  531109
  531116
  532679
  527428
  533697
  540404
  544823
  554462
  568177
  542590
  583675
  542566
  543615
  544803
  565255
  582549
  647969
  674978
  678067
  678161
  679728
  648499
  650762
  653447
  678028
  716882
  648815
  651188
  676107
  680126
  544797
  545424
  550196
  550307
  565247
  565253
  567304
  583640
  599945
  601576
  631195
  632673
  634145
  636311
  596462
  597266
  598057
  606501
  624179
  636321
  637143
  637416
  639793
  639802
  600365
  628086
  637031
  599902
  600194
  600334
  604369
  640767
  641141
  731665
  748389
  605338
  606578
  614401
  632694
  633816
  637022
  642038
  778359
  414337
  447500
  523856
  637074
  445737
]
3.34 ms
(1.67%)
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
  33459
  405050
  414337
  425206
  445737
  447500
  451256
  467608
  506328
  522858
  523856
  525657
  527428
  530010
  530381
  530624
  531109
  531116
  531225
  531232
  531420
  532679
  532789
  532792
  533697
  534627
  536339
  537885
  537908
  540404
  540573
  542566
  542590
  543615
  543918
  544797
  544803
  544823
  545424
  545851
  550196
  550307
  554462
  565247
  565253
  565255
  567304
  568177
  576690
  577331
  582549
  583640
  583675
  590411
  591680
  596462
  597266
  598057
  599902
  599945
  600194
  600334
  600365
  601576
  604369
  604517
  605338
  606501
  606578
  614401
  617412
  624179
  628086
  629899
  631195
  632611
  632623
  632673
  632694
  633816
  634145
  635275
  636311
  636321
  636598
  637022
  637031
  637074
  637143
  637416
  639793
  639802
  640767
  641130
  641141
  642038
  647969
  648499
  648815
  650762
  651188
  653447
  674978
  675000
  676016
  676107
  678028
  678067
  678161
  679728
  680126
  680186
  681637
  697001
  716882
  720938
  731665
  748244
  748389
  778359
]
2.13 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "чулк нижн бел gangbang"
]
1.63 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "stockings gangbang"
]
1.43 ms
(0.71%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "чулк нижн бел gangbang"
]
1.41 ms
(0.70%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.