Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.46 ms
(84.42%)
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
  2808
  16831
  76122
  147280
  152529
  163116
  187996
  382085
  384543
  386807
  387597
  388714
  389745
  391056
  394490
  396794
  398179
  425565
  460611
  500186
  501384
  506771
  530585
  532774
  533173
  534887
  538167
  539555
  539573
  540426
  541023
  547042
  555491
  557636
  562539
  562633
  580953
  581585
  592880
  603848
  610549
  611093
  621823
  624046
  630957
  631420
  631636
  634481
  639125
  640302
  641268
  641391
  642155
  643434
  651094
  651665
  658512
  659158
  659199
  665200
  665373
  667660
  667766
  667983
  669216
  669751
  670388
  680919
  681776
  683622
  687118
  692214
  696354
  697625
  708149
  708983
  713127
  715194
  717475
  718570
  719043
  722132
  726325
  726818
  726820
  736613
  736740
  739265
  742612
  748393
  753753
  760486
  761886
  762700
  763395
  768058
  772141
  774311
  790328
  790336
  797761
  805291
  805426
  811871
  817745
  818143
  820708
  821778
  823955
  824726
  824751
  827905
  827914
  828039
  828399
  828760
  828852
]
14.41 ms
(8.91%)
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
  797761
  394490
  827843
  386807
  147280
  187996
  827905
  828039
  538167
  557636
  708149
  658512
  681776
  717475
  634481
  641268
  760486
  398179
  722132
  805426
  659199
  500186
  534887
  541023
  697625
  631636
  640302
  805291
  540426
  501384
  506771
  539573
  530585
  683622
  718570
  610549
  774311
  163116
  389745
  680919
  396794
  821778
  669216
  624046
  761886
  762700
  772141
  388714
  2808
  76122
  817745
  460611
  533173
  562539
  152529
  824210
  828760
  532774
  651665
  687118
  643434
  641391
  763395
  827914
  539555
  818143
  659158
  665373
  736613
  16831
  824751
  824726
  828399
  828852
  811871
  768058
  580953
  547042
  642155
  384543
  669751
  665200
  719043
  692214
  630957
  603848
  790336
  726325
  736740
  748393
  611093
  790328
  391056
  382085
  822687
  387597
  820708
  823955
  562633
  581585
  555491
  667983
  715194
  651094
  667660
  667766
  708983
  670388
  696354
  592880
  621823
  639125
  726818
  726820
  739265
  742612
  753753
  631420
  713127
  425565
]
3.53 ms
(2.19%)
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
  2808
  16831
  76122
  147280
  152529
  163116
  187996
  382085
  384543
  386807
  387597
  388714
  389745
  391056
  394490
  396794
  398179
  425565
  460611
  500186
  501384
  506771
  530585
  532774
  533173
  534887
  538167
  539555
  539573
  540426
  541023
  547042
  555491
  557636
  562539
  562633
  580953
  581585
  592880
  603848
  610549
  611093
  621823
  624046
  630957
  631420
  631636
  634481
  639125
  640302
  641268
  641391
  642155
  643434
  651094
  651665
  658512
  659158
  659199
  665200
  665373
  667660
  667766
  667983
  669216
  669751
  670388
  680919
  681776
  683622
  687118
  692214
  696354
  697625
  708149
  708983
  713127
  715194
  717475
  718570
  719043
  722132
  726325
  726818
  726820
  736613
  736740
  739265
  742612
  748393
  753753
  760486
  761886
  762700
  763395
  768058
  772141
  774311
  790328
  790336
  797761
  805291
  805426
  811871
  817745
  818143
  820708
  821778
  823955
  824726
  824751
  827905
  827914
  828039
  828399
  828760
  828852
]
1.95 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "riding big tits"
]
1.86 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "riding большие сиськ"
]
1.65 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "riding большие сиськ"
]

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.