Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.94 ms
(86.13%)
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
  54149
  382196
  382839
  409317
  411998
  412018
  412492
  414217
  416855
  420119
  421350
  429936
  434532
  448730
  449954
  451707
  454435
  454824
  457263
  463913
  464310
  464354
  468026
  474599
  474688
  479858
  483131
  483374
  485479
  485720
  506141
  510178
  512102
  513760
  516487
  523146
  528439
  530928
  536702
  536731
  539456
  544505
  550396
  551574
  552075
  557237
  558061
  558086
  559348
  563466
  569187
  571014
  574644
  583827
  584745
  591470
  596301
  600614
  604031
  605310
  618964
  619393
  622137
  629326
  630068
  631132
  634559
  636836
  665038
  666800
  667974
  668897
  669130
  671392
  673462
  676151
  692502
  696201
  696937
  701152
  702749
  705446
  705467
  714145
  714191
  717683
  718241
  718965
  718997
  719677
  719876
  721132
  721675
  723098
  726620
  726649
  726661
  726864
  726998
  731832
  731846
  736487
  736623
  740454
  741981
  745634
  747420
  753247
  759540
  765335
  774009
  781816
  782778
  785298
  791918
  792817
  799622
  802831
  804178
  808084
]
16.56 ms
(8.65%)
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
  528439
  512102
  544505
  551574
  571014
  605310
  774009
  726864
  411998
  474599
  629326
  420119
  485720
  449954
  558061
  464310
  464354
  457263
  454435
  451707
  485479
  510178
  429936
  483131
  536702
  536731
  557237
  583827
  574644
  559348
  665038
  717683
  676151
  705467
  668897
  714145
  714191
  721675
  596301
  630068
  781816
  726620
  736623
  726649
  726661
  745634
  726998
  696937
  54149
  539456
  718965
  667974
  604031
  634559
  799622
  747420
  618964
  723098
  412018
  804178
  382839
  434532
  409317
  414217
  416855
  550396
  792817
  412492
  454824
  474688
  513760
  523146
  448730
  584745
  468026
  479858
  483374
  558086
  516487
  463913
  530928
  569187
  692502
  701152
  718241
  718997
  666800
  669130
  719677
  719876
  552075
  563466
  591470
  619393
  622137
  636836
  741981
  736487
  753247
  740454
  759540
  631132
  702749
  705446
  721132
  382196
  506141
  421350
  671392
  673462
  696201
  600614
  782778
  791918
  765335
  785298
  802831
  808084
  731832
  731846
]
2.55 ms
(1.33%)
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
  54149
  382196
  382839
  409317
  411998
  412018
  412492
  414217
  416855
  420119
  421350
  429936
  434532
  448730
  449954
  451707
  454435
  454824
  457263
  463913
  464310
  464354
  468026
  474599
  474688
  479858
  483131
  483374
  485479
  485720
  506141
  510178
  512102
  513760
  516487
  523146
  528439
  530928
  536702
  536731
  539456
  544505
  550396
  551574
  552075
  557237
  558061
  558086
  559348
  563466
  569187
  571014
  574644
  583827
  584745
  591470
  596301
  600614
  604031
  605310
  618964
  619393
  622137
  629326
  630068
  631132
  634559
  636836
  665038
  666800
  667974
  668897
  669130
  671392
  673462
  676151
  692502
  696201
  696937
  701152
  702749
  705446
  705467
  714145
  714191
  717683
  718241
  718965
  718997
  719677
  719876
  721132
  721675
  723098
  726620
  726649
  726661
  726864
  726998
  731832
  731846
  736487
  736623
  740454
  741981
  745634
  747420
  753247
  759540
  765335
  774009
  781816
  782778
  785298
  791918
  792817
  799622
  802831
  804178
  808084
]
2.25 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.99 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "natural tits casting"
]
1.71 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "натуральная натуральные сиськ без силикон кастинг"
]
1.50 ms
(0.78%)
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.