Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
225.66 ms
(87.05%)
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
  397793
  420125
  421566
  428147
  432131
  433672
  439650
  442830
  444588
  447132
  447454
  447630
  447896
  451304
  452535
  457515
  465061
  465162
  465619
  467185
  468173
  468827
  469193
  470229
  470304
  470443
  470952
  474059
  478829
  478923
  482270
  482360
  483309
  483382
  485916
  486004
  488696
  489603
  490448
  490492
  490927
  491659
  491997
  492110
  492719
  495144
  496528
  501804
  502882
  503405
  503488
  506830
  506834
  508848
  509393
  509557
  510353
  511600
  512397
  512830
  514820
  515213
  515729
  516003
  516439
  516761
  516820
  517723
  519546
  521227
  521581
  522086
  522332
  522871
  523317
  525180
  525396
  525978
  527065
  528342
  528356
  528662
  528876
  529543
  530532
  531472
  533186
  534376
  536214
  537122
  537732
  538608
  540071
  543456
  544825
  545544
  547815
  548034
  550076
  551059
  552272
  554461
  567109
  576658
  586469
  602521
  603243
  607374
  618672
  622975
  637746
  647875
  648254
  650992
  656577
  662801
  678942
  688010
  748212
  799936
]
22.07 ms
(8.51%)
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
  515213
  528876
  537122
  537732
  495144
  516439
  516761
  521227
  528342
  530532
  531472
  496528
  515729
  522332
  525180
  525396
  529543
  533186
  538608
  467185
  482360
  548034
  543456
  576658
  551059
  554461
  662801
  678942
  688010
  647875
  656577
  545544
  547815
  550076
  637746
  602521
  618672
  586469
  603243
  748212
  457515
  465061
  468173
  468827
  474059
  478829
  433672
  439650
  470229
  470304
  478923
  447630
  397793
  428147
  447454
  451304
  470443
  470952
  465162
  510353
  528356
  483309
  483382
  490492
  501804
  502882
  503488
  506830
  509393
  509557
  511600
  522086
  528662
  485916
  486004
  491659
  491997
  512830
  516003
  517723
  519546
  525978
  488696
  489603
  490448
  490927
  492110
  492719
  506834
  508848
  512397
  536214
  527065
  540071
  552272
  650992
  469193
  607374
  420125
  442830
  447896
  465619
  447132
  503405
  514820
  544825
  648254
  567109
  622975
  799936
  432131
  482270
  452535
  444588
  421566
  516820
  521581
  522871
  523317
  534376
]
3.50 ms
(1.35%)
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
  397793
  420125
  421566
  428147
  432131
  433672
  439650
  442830
  444588
  447132
  447454
  447630
  447896
  451304
  452535
  457515
  465061
  465162
  465619
  467185
  468173
  468827
  469193
  470229
  470304
  470443
  470952
  474059
  478829
  478923
  482270
  482360
  483309
  483382
  485916
  486004
  488696
  489603
  490448
  490492
  490927
  491659
  491997
  492110
  492719
  495144
  496528
  501804
  502882
  503405
  503488
  506830
  506834
  508848
  509393
  509557
  510353
  511600
  512397
  512830
  514820
  515213
  515729
  516003
  516439
  516761
  516820
  517723
  519546
  521227
  521581
  522086
  522332
  522871
  523317
  525180
  525396
  525978
  527065
  528342
  528356
  528662
  528876
  529543
  530532
  531472
  533186
  534376
  536214
  537122
  537732
  538608
  540071
  543456
  544825
  545544
  547815
  548034
  550076
  551059
  552272
  554461
  567109
  576658
  586469
  602521
  603243
  607374
  618672
  622975
  637746
  647875
  648254
  650992
  656577
  662801
  678942
  688010
  748212
  799936
]
2.23 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "доминирован лиза pussy"
]
2.19 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.98 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "slave lick pussy"
]
1.59 ms
(0.61%)
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.