Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
161.15 ms
(84.62%)
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
  420472
  443971
  451175
  470118
  474776
  509163
  521798
  532785
  541195
  549584
  549799
  549870
  550604
  551246
  551275
  551477
  552120
  552160
  552267
  552467
  553032
  554742
  556051
  558126
  558976
  560387
  560462
  560653
  561652
  561821
  562078
  565181
  565476
  567304
  567337
  567338
  567774
  568315
  569260
  570708
  571421
  572042
  574184
  574731
  575162
  575479
  575774
  575806
  576393
  576395
  579475
  580298
  586491
  586770
  587858
  590542
  590604
  591312
  591839
  594090
  594604
  595450
  595458
  596423
  596526
  597013
  597227
  597490
  597494
  597550
  597566
  597572
  597573
  597819
  597950
  598057
  598092
  598524
  598680
  598752
  600111
  600143
  600489
  602506
  602607
  602647
  602747
  603103
  604247
  609205
  612799
  622987
  623206
  623716
  624084
  624925
  633732
  634501
  635106
  636273
  636274
  636869
  646838
  652610
  654322
  658082
  659283
  667985
  696212
  714449
  716032
  716414
  722821
  722871
  732087
  742143
  747517
  783468
  789781
  804913
]
20.00 ms
(10.50%)
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
  623716
  598752
  470118
  474776
  600143
  634501
  560387
  576395
  562078
  553032
  574731
  659283
  549870
  565476
  586491
  571421
  594604
  789781
  747517
  716414
  602747
  624925
  451175
  549799
  420472
  654322
  541195
  732087
  804913
  560653
  597950
  580298
  597573
  633732
  595450
  597819
  596526
  623206
  561821
  575479
  572042
  556051
  575162
  722821
  551246
  597566
  602607
  636274
  636273
  742143
  714449
  722871
  550604
  551275
  574184
  575806
  551477
  552160
  552467
  558976
  560462
  567304
  567337
  598680
  597227
  509163
  595458
  604247
  609205
  612799
  521798
  568315
  579475
  646838
  667985
  602506
  658082
  652610
  591839
  598524
  635106
  570708
  575774
  594090
  590604
  600111
  597494
  532785
  552267
  558126
  552120
  567774
  576393
  716032
  598057
  783468
  549584
  569260
  561652
  696212
  586770
  591312
  602647
  590542
  598092
  443971
  624084
  597013
  600489
  597490
  567338
  603103
  597572
  636869
  597550
  587858
  622987
  565181
  554742
  596423
]
2.43 ms
(1.28%)
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
  420472
  443971
  451175
  470118
  474776
  509163
  521798
  532785
  541195
  549584
  549799
  549870
  550604
  551246
  551275
  551477
  552120
  552160
  552267
  552467
  553032
  554742
  556051
  558126
  558976
  560387
  560462
  560653
  561652
  561821
  562078
  565181
  565476
  567304
  567337
  567338
  567774
  568315
  569260
  570708
  571421
  572042
  574184
  574731
  575162
  575479
  575774
  575806
  576393
  576395
  579475
  580298
  586491
  586770
  587858
  590542
  590604
  591312
  591839
  594090
  594604
  595450
  595458
  596423
  596526
  597013
  597227
  597490
  597494
  597550
  597566
  597572
  597573
  597819
  597950
  598057
  598092
  598524
  598680
  598752
  600111
  600143
  600489
  602506
  602607
  602647
  602747
  603103
  604247
  609205
  612799
  622987
  623206
  623716
  624084
  624925
  633732
  634501
  635106
  636273
  636274
  636869
  646838
  652610
  654322
  658082
  659283
  667985
  696212
  714449
  716032
  716414
  722821
  722871
  732087
  742143
  747517
  783468
  789781
  804913
]
1.91 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian anal butt"
]
1.80 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск анал butt"
]
1.78 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.37 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск анал butt"
]

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.