Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.41 ms
(87.41%)
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
  14853
  24076
  24243
  96503
  187996
  191093
  247896
  381927
  384279
  384429
  386685
  387425
  397191
  409667
  412717
  414027
  418943
  422119
  428099
  431221
  451883
  454074
  454199
  454404
  460680
  460724
  473885
  485041
  522059
  532692
  535111
  538440
  551022
  556019
  557435
  567381
  578226
  578431
  578494
  580705
  585410
  588177
  589649
  591619
  592925
  600749
  605167
  609806
  618493
  619480
  622370
  624463
  631665
  634478
  634832
  638980
  644977
  646445
  649888
  664848
  666830
  671834
  684065
  690930
  693388
  693415
  701212
  701222
  714148
  717092
  717161
  719913
  720975
  721695
  723444
  724032
  726800
  729019
  732009
  732106
  733438
  736461
  737581
  738168
  740504
  744483
  750841
  760138
  761245
  763030
  765152
  767140
  768405
  770119
  774408
  775355
  776630
  780621
  780680
  781815
  781854
  781931
  789204
  793438
  796251
  800581
  807905
  808038
  808642
  809288
  809327
  815224
  815398
  816769
  817962
  818454
  821447
  823483
  823693
]
10.82 ms
(6.78%)
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
  732009
  412717
  422119
  556019
  454404
  567381
  386685
  451883
  387425
  701212
  729019
  740504
  532692
  737581
  631665
  384279
  96503
  428099
  774408
  485041
  522059
  693388
  717161
  693415
  701222
  720975
  578226
  589649
  591619
  634478
  585410
  780621
  765152
  736461
  744483
  726800
  733438
  807905
  809327
  14853
  384429
  187996
  818454
  535111
  557435
  684065
  719913
  763030
  772023
  738168
  767140
  717092
  776630
  454074
  721695
  619480
  723444
  760138
  414027
  578431
  816769
  817962
  823693
  815398
  460724
  551022
  622370
  624463
  781931
  808642
  808038
  750841
  789204
  768405
  770119
  732106
  761245
  609806
  714148
  796251
  809288
  24243
  418943
  454199
  460680
  473885
  397191
  409667
  191093
  578494
  780680
  724032
  247896
  24076
  431221
  618493
  815224
  690930
  580705
  381927
  644977
  821447
  823483
  538440
  664848
  649888
  671834
  646445
  666830
  600749
  605167
  592925
  634832
  638980
  588177
  775355
  781815
  781854
  793438
  800581
]
2.65 ms
(1.66%)
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
  14853
  24076
  24243
  96503
  187996
  191093
  247896
  381927
  384279
  384429
  386685
  387425
  397191
  409667
  412717
  414027
  418943
  422119
  428099
  431221
  451883
  454074
  454199
  454404
  460680
  460724
  473885
  485041
  522059
  532692
  535111
  538440
  551022
  556019
  557435
  567381
  578226
  578431
  578494
  580705
  585410
  588177
  589649
  591619
  592925
  600749
  605167
  609806
  618493
  619480
  622370
  624463
  631665
  634478
  634832
  638980
  644977
  646445
  649888
  664848
  666830
  671834
  684065
  690930
  693388
  693415
  701212
  701222
  714148
  717092
  717161
  719913
  720975
  721695
  723444
  724032
  726800
  729019
  732009
  732106
  733438
  736461
  737581
  738168
  740504
  744483
  750841
  760138
  761245
  763030
  765152
  767140
  768405
  770119
  774408
  775355
  776630
  780621
  780680
  781815
  781854
  781931
  789204
  793438
  796251
  800581
  807905
  808038
  808642
  809288
  809327
  815224
  815398
  816769
  817962
  818454
  821447
  823483
  823693
]
2.04 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "natural boobs blowjob"
]
1.64 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "натуральная натуральные boobs минет оральн секс"
]
1.50 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "натуральная натуральные boobs минет оральн секс"
]
1.43 ms
(0.90%)
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.