Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.74 ms
(82.99%)
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
  396388
  511321
  534192
  562392
  563838
  617104
  618797
  626440
  639919
  672693
  675447
  686091
  691763
  700076
  701215
  702358
  704165
  709412
  712486
  712576
  713410
  716645
  717982
  718609
  725545
  730033
  731407
  733736
  734732
  734753
  735812
  736167
  736288
  736497
  736755
  738875
  739785
  747813
  748058
  748983
  749536
  749887
  750671
  752816
  753179
  756366
  757902
  757923
  758914
  766187
  767243
  767411
  767929
  768789
  769046
  770075
  770616
  773170
  773316
  777483
  777630
  777636
  777690
  777962
  778162
  778708
  778871
  778948
  779407
  779582
  779944
  781538
  782164
  787045
  789116
  789135
  790057
  790321
  791254
  791767
  792114
  792449
  792496
  793576
  794865
  794932
  796791
  798921
  799251
  799541
  799552
  800279
  800280
  802010
  803567
  803986
  804834
  806858
  812456
  813323
  813965
  813981
  813983
  816636
  816770
  817839
  817988
  818192
  821003
  824249
  824284
  824714
  825297
  825369
  825423
  826335
  826647
  827649
]
16.57 ms
(10.36%)
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
  777690
  778948
  792496
  803567
  736167
  748058
  750671
  770616
  773537
  791767
  768789
  769046
  734753
  735812
  767243
  787045
  793576
  826335
  824714
  511321
  562392
  712576
  713410
  672693
  702358
  617104
  778162
  800280
  777483
  794865
  725545
  753179
  770075
  749536
  733736
  736755
  739785
  752816
  757902
  756366
  626440
  700076
  778708
  792449
  825423
  826647
  816636
  821003
  825369
  816770
  824249
  825928
  813965
  813983
  817988
  824284
  827649
  534192
  563838
  675447
  701215
  718609
  691763
  704165
  779407
  790321
  796791
  789116
  790057
  791254
  794932
  799251
  800279
  804834
  812456
  813323
  758914
  767411
  767929
  773170
  781538
  782164
  789135
  803986
  806858
  736288
  757923
  734732
  736497
  738875
  747813
  766187
  748983
  749887
  773316
  777636
  777962
  779944
  798921
  799541
  799552
  802010
  618797
  396388
  818192
  716645
  792114
  731407
  813981
  825297
  817839
  717982
  712486
  686091
  709412
  639919
  778871
  779582
  777630
  730033
]
3.27 ms
(2.05%)
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
  396388
  511321
  534192
  562392
  563838
  617104
  618797
  626440
  639919
  672693
  675447
  686091
  691763
  700076
  701215
  702358
  704165
  709412
  712486
  712576
  713410
  716645
  717982
  718609
  725545
  730033
  731407
  733736
  734732
  734753
  735812
  736167
  736288
  736497
  736755
  738875
  739785
  747813
  748058
  748983
  749536
  749887
  750671
  752816
  753179
  756366
  757902
  757923
  758914
  766187
  767243
  767411
  767929
  768789
  769046
  770075
  770616
  773170
  773316
  777483
  777630
  777636
  777690
  777962
  778162
  778708
  778871
  778948
  779407
  779582
  779944
  781538
  782164
  787045
  789116
  789135
  790057
  790321
  791254
  791767
  792114
  792449
  792496
  793576
  794865
  794932
  796791
  798921
  799251
  799541
  799552
  800279
  800280
  802010
  803567
  803986
  804834
  806858
  812456
  813323
  813965
  813981
  813983
  816636
  816770
  817839
  817988
  818192
  821003
  824249
  824284
  824714
  825297
  825369
  825423
  826335
  826647
  827649
]
1.97 ms
(1.23%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.91 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex with stepsister"
]
1.84 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс stepsister"
]
1.65 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс stepsister"
]

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.