Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.82 ms
(84.21%)
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
  123416
  305824
  383495
  385112
  399717
  405426
  409226
  417773
  428605
  428917
  432325
  438536
  441809
  444400
  446097
  448982
  451029
  452648
  459180
  461569
  464360
  465924
  470778
  471352
  475411
  476916
  495303
  496650
  497017
  497074
  499098
  500927
  502106
  502738
  504894
  506816
  511732
  516245
  518017
  523032
  526749
  528522
  533534
  540905
  541050
  543392
  546564
  546724
  555831
  559484
  562220
  567383
  573755
  574404
  574792
  575161
  575488
  576113
  577537
  583303
  597128
  603560
  605631
  611289
  614665
  621980
  623817
  625122
  628520
  631901
  634495
  637232
  639598
  640152
  648575
  650602
  652281
  655097
  655714
  656370
  656834
  656868
  657051
  657329
  658661
  659714
  665999
  675405
  687471
  688100
  701296
  708903
  718499
  721125
  721887
  722276
  723164
  725579
  732323
  739898
  741277
  742022
  752908
  753734
  757866
  769776
  771288
  773454
  774413
  783140
  786719
  787056
  792075
  794005
  796012
  797162
  797565
  799749
  803575
  810017
]
16.74 ms
(10.08%)
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
  732323
  603560
  405426
  441809
  385112
  417773
  500927
  516245
  796012
  657329
  655097
  528522
  452648
  465924
  448982
  502106
  470778
  511732
  499098
  540905
  496650
  753734
  526749
  409226
  464360
  497017
  518017
  567383
  562220
  555831
  723164
  675405
  640152
  797162
  451029
  476916
  497074
  495303
  546724
  575161
  444400
  471352
  506816
  752908
  573755
  575488
  543392
  428917
  504894
  657051
  659714
  399717
  783140
  773454
  523032
  658661
  574792
  741277
  428605
  621980
  656868
  656834
  459180
  461569
  634495
  502738
  546564
  623817
  305824
  665999
  792075
  574404
  123416
  475411
  774413
  687471
  721125
  628520
  786719
  799749
  625122
  718499
  648575
  655714
  656370
  446097
  541050
  721887
  631901
  637232
  614665
  797565
  771288
  739898
  708903
  576113
  533534
  383495
  438536
  583303
  559484
  650602
  577537
  605631
  794005
  639598
  810017
  611289
  652281
  432325
  688100
  722276
  701296
  803575
  757866
  769776
  742022
  787056
  597128
  725579
]
2.71 ms
(1.63%)
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
  123416
  305824
  383495
  385112
  399717
  405426
  409226
  417773
  428605
  428917
  432325
  438536
  441809
  444400
  446097
  448982
  451029
  452648
  459180
  461569
  464360
  465924
  470778
  471352
  475411
  476916
  495303
  496650
  497017
  497074
  499098
  500927
  502106
  502738
  504894
  506816
  511732
  516245
  518017
  523032
  526749
  528522
  533534
  540905
  541050
  543392
  546564
  546724
  555831
  559484
  562220
  567383
  573755
  574404
  574792
  575161
  575488
  576113
  577537
  583303
  597128
  603560
  605631
  611289
  614665
  621980
  623817
  625122
  628520
  631901
  634495
  637232
  639598
  640152
  648575
  650602
  652281
  655097
  655714
  656370
  656834
  656868
  657051
  657329
  658661
  659714
  665999
  675405
  687471
  688100
  701296
  708903
  718499
  721125
  721887
  722276
  723164
  725579
  732323
  739898
  741277
  742022
  752908
  753734
  757866
  769776
  771288
  773454
  774413
  783140
  786719
  787056
  792075
  794005
  796012
  797162
  797565
  799749
  803575
  810017
]
1.96 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "с другом парня"
]
1.70 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "друг парен"
]
1.64 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.