Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.92 ms
(80.87%)
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
  382313
  385262
  391049
  393742
  395720
  404598
  406041
  406990
  407494
  408278
  413074
  416817
  418928
  418959
  418963
  421094
  424470
  425116
  425799
  425802
  425809
  425834
  425967
  428479
  430306
  431015
  431133
  432172
  432831
  433747
  435697
  439226
  442173
  442398
  442669
  450316
  450988
  451552
  451950
  452110
  453159
  453253
  454323
  460969
  462466
  463783
  464624
  467036
  467039
  469475
  470031
  470514
  470924
  471438
  471639
  472317
  472506
  472544
  474153
  474553
  476252
  479191
  480747
  481339
  481348
  482584
  487509
  487516
  490011
  491986
  496784
  512217
  512984
  513059
  514650
  518582
  520020
  520151
  520890
  521078
  527249
  527812
  530062
  530504
  534293
  534334
  536664
  538817
  550763
  558714
  560507
  576694
  576707
  581320
  581341
  587254
  587416
  590850
  595061
  596330
  608358
  612413
  620135
  640029
  647637
  670286
  683369
  684216
  688586
  700670
  714119
  739985
  743641
  748644
  769448
  789724
  792617
  807688
  807707
  822223
]
19.53 ms
(12.85%)
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
  739985
  442398
  534334
  425809
  453159
  467036
  425802
  769448
  385262
  393742
  407494
  418928
  428479
  442173
  406990
  413074
  418963
  425967
  442669
  430306
  418959
  822223
  482584
  472317
  474553
  476252
  452110
  454323
  481339
  487516
  490011
  467039
  469475
  471438
  474153
  487509
  513059
  521078
  530062
  512984
  514650
  520020
  520151
  520890
  530504
  534293
  538817
  512217
  527812
  464624
  472506
  472544
  560507
  576707
  576694
  683369
  684216
  647637
  670286
  714119
  550763
  558714
  581320
  581341
  596330
  620135
  587254
  587416
  640029
  590850
  595061
  789724
  807707
  612413
  700670
  792617
  807688
  416817
  432172
  439226
  453253
  462466
  479191
  480747
  382313
  406041
  463783
  424470
  450316
  450988
  431015
  431133
  451950
  470031
  470924
  425116
  435697
  451552
  460969
  470514
  481348
  496784
  527249
  536664
  491986
  518582
  608358
  743641
  688586
  471639
  408278
  748644
  391049
  395720
  404598
  421094
  425799
  425834
  432831
  433747
]
2.65 ms
(1.74%)
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
  382313
  385262
  391049
  393742
  395720
  404598
  406041
  406990
  407494
  408278
  413074
  416817
  418928
  418959
  418963
  421094
  424470
  425116
  425799
  425802
  425809
  425834
  425967
  428479
  430306
  431015
  431133
  432172
  432831
  433747
  435697
  439226
  442173
  442398
  442669
  450316
  450988
  451552
  451950
  452110
  453159
  453253
  454323
  460969
  462466
  463783
  464624
  467036
  467039
  469475
  470031
  470514
  470924
  471438
  471639
  472317
  472506
  472544
  474153
  474553
  476252
  479191
  480747
  481339
  481348
  482584
  487509
  487516
  490011
  491986
  496784
  512217
  512984
  513059
  514650
  518582
  520020
  520151
  520890
  521078
  527249
  527812
  530062
  530504
  534293
  534334
  536664
  538817
  550763
  558714
  560507
  576694
  576707
  581320
  581341
  587254
  587416
  590850
  595061
  596330
  608358
  612413
  620135
  640029
  647637
  670286
  683369
  684216
  688586
  700670
  714119
  739985
  743641
  748644
  769448
  789724
  792617
  807688
  807707
  822223
]
1.94 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy pussy facesitting"
]
1.75 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая pussy фейсситтинг"
]
1.41 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "волосатая pussy фейсситтинг"
]

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.