Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
247.67 ms
(90.81%)
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
  383238
  385812
  395252
  399912
  413163
  420016
  420116
  423326
  424011
  424349
  426561
  428932
  432316
  434128
  434382
  435559
  436621
  441169
  442618
  445076
  445978
  446777
  446815
  448598
  448602
  449584
  450275
  454707
  457327
  458296
  459851
  461083
  461823
  464490
  466462
  466662
  466692
  468310
  470311
  473065
  476068
  476836
  478633
  481231
  484966
  488914
  488916
  491106
  492842
  498308
  498500
  499356
  506861
  507340
  513203
  513628
  520715
  523687
  523710
  524469
  529396
  532542
  536388
  540816
  545761
  547694
  550113
  550664
  554669
  555111
  559973
  561494
  562426
  562506
  577420
  583658
  583673
  586832
  588596
  589554
  590337
  593113
  593227
  596843
  609551
  615899
  617956
  619895
  627667
  628623
  631620
  636229
  648295
  661317
  661320
  661572
  668694
  669668
  678787
  679697
  708667
  714348
  718771
  731159
  735447
  739556
  750739
  751581
  757910
  763729
  763740
  765870
  768603
  772296
  772433
  774575
  774706
  785841
  804254
  804352
]
15.38 ms
(5.64%)
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
  561494
  628623
  804254
  804352
  450275
  464490
  466462
  420016
  385812
  424011
  441169
  473065
  554669
  583658
  679697
  714348
  708667
  636229
  461823
  481231
  436621
  459851
  491106
  498500
  484966
  488916
  413163
  445076
  435559
  445978
  529396
  550113
  545761
  577420
  661320
  661317
  668694
  617956
  590337
  619895
  596843
  609551
  772296
  772433
  763740
  768603
  731159
  751581
  763729
  785841
  395252
  513628
  488914
  513203
  524469
  399912
  432316
  426561
  423326
  424349
  458296
  478633
  498308
  532542
  507340
  550664
  547694
  648295
  588596
  627667
  615899
  428932
  446777
  434382
  420116
  461083
  476836
  492842
  559973
  555111
  520715
  470311
  506861
  434128
  540816
  448598
  448602
  454707
  466692
  446815
  449584
  468310
  476068
  562506
  583673
  661572
  718771
  678787
  593227
  631620
  589554
  774706
  757910
  735447
  750739
  765870
  739556
  774575
  442618
  466662
  523687
  499356
  523710
  383238
  593113
  457327
  536388
  562426
  669668
  586832
]
2.63 ms
(0.96%)
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
  383238
  385812
  395252
  399912
  413163
  420016
  420116
  423326
  424011
  424349
  426561
  428932
  432316
  434128
  434382
  435559
  436621
  441169
  442618
  445076
  445978
  446777
  446815
  448598
  448602
  449584
  450275
  454707
  457327
  458296
  459851
  461083
  461823
  464490
  466462
  466662
  466692
  468310
  470311
  473065
  476068
  476836
  478633
  481231
  484966
  488914
  488916
  491106
  492842
  498308
  498500
  499356
  506861
  507340
  513203
  513628
  520715
  523687
  523710
  524469
  529396
  532542
  536388
  540816
  545761
  547694
  550113
  550664
  554669
  555111
  559973
  561494
  562426
  562506
  577420
  583658
  583673
  586832
  588596
  589554
  590337
  593113
  593227
  596843
  609551
  615899
  617956
  619895
  627667
  628623
  631620
  636229
  648295
  661317
  661320
  661572
  668694
  669668
  678787
  679697
  708667
  714348
  718771
  731159
  735447
  739556
  750739
  751581
  757910
  763729
  763740
  765870
  768603
  772296
  772433
  774575
  774706
  785841
  804254
  804352
]
1.82 ms
(0.67%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "голые девушк соло"
]
1.76 ms
(0.65%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "голые девушк соло"
]
1.75 ms
(0.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "naked girls solo"
]
1.71 ms
(0.63%)
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.