Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
167.60 ms
(87.39%)
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
  182232
  187735
  322815
  386062
  388774
  391635
  393233
  396710
  401368
  409469
  415921
  422024
  424216
  424234
  441031
  441824
  442144
  448245
  461261
  463950
  468121
  485555
  497563
  509975
  514839
  520785
  521819
  534596
  541328
  547809
  555101
  558519
  558885
  559961
  564495
  588712
  591805
  592569
  602694
  604329
  604350
  604403
  604676
  616795
  626144
  637654
  641097
  660330
  662183
  665694
  666732
  680199
  681804
  688996
  695339
  699487
  700478
  702157
  711953
  714665
  718657
  720160
  720583
  721367
  722882
  725362
  726314
  726934
  727180
  729231
  729548
  735103
  735294
  736784
  738435
  740318
  741274
  744022
  747694
  750706
  752673
  754222
  756234
  757175
  758097
  761347
  763452
  766748
  766749
  767004
  767329
  769584
  770280
  771816
  772664
  777121
  777921
  786201
  789092
  790162
  795142
  796048
  796116
  796204
  798908
  799413
  801249
  803446
  803454
  803504
  804697
  805524
  806327
  814963
  815929
  817267
  817444
  824121
  825811
  827328
]
14.49 ms
(7.55%)
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
  801249
  726314
  750706
  752673
  757175
  798908
  805524
  766748
  726934
  756234
  767004
  747694
  767329
  771816
  761347
  602694
  711953
  803504
  441824
  541328
  720160
  718657
  641097
  604329
  591805
  604350
  799413
  729548
  754222
  729231
  770280
  409469
  396710
  187735
  468121
  514839
  534596
  666732
  558519
  626144
  604676
  588712
  796116
  736784
  393233
  424216
  442144
  448245
  509975
  386062
  388774
  555101
  665694
  688996
  695339
  699487
  700478
  714665
  722882
  662183
  681804
  720583
  558885
  604403
  616795
  637654
  804697
  789092
  790162
  796048
  796204
  786201
  795142
  735103
  738435
  744022
  769584
  725362
  763452
  766749
  741274
  758097
  772664
  721367
  777921
  803446
  424234
  660330
  680199
  463950
  182232
  735294
  391635
  322815
  461261
  547809
  559961
  564495
  702157
  592569
  777121
  806327
  740318
  727180
  803454
  441031
  520785
  521819
  485555
  497563
  401368
  415921
  422024
  817267
  817444
  815929
  825811
  827328
  824121
  814963
]
2.95 ms
(1.54%)
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
  182232
  187735
  322815
  386062
  388774
  391635
  393233
  396710
  401368
  409469
  415921
  422024
  424216
  424234
  441031
  441824
  442144
  448245
  461261
  463950
  468121
  485555
  497563
  509975
  514839
  520785
  521819
  534596
  541328
  547809
  555101
  558519
  558885
  559961
  564495
  588712
  591805
  592569
  602694
  604329
  604350
  604403
  604676
  616795
  626144
  637654
  641097
  660330
  662183
  665694
  666732
  680199
  681804
  688996
  695339
  699487
  700478
  702157
  711953
  714665
  718657
  720160
  720583
  721367
  722882
  725362
  726314
  726934
  727180
  729231
  729548
  735103
  735294
  736784
  738435
  740318
  741274
  744022
  747694
  750706
  752673
  754222
  756234
  757175
  758097
  761347
  763452
  766748
  766749
  767004
  767329
  769584
  770280
  771816
  772664
  777121
  777921
  786201
  789092
  790162
  795142
  796048
  796116
  796204
  798908
  799413
  801249
  803446
  803454
  803504
  804697
  805524
  806327
  814963
  815929
  817267
  817444
  824121
  825811
  827328
]
2.03 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "holes anal"
]
1.66 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "holes анал"
]
1.55 ms
(0.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "holes анал"
]

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.