Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.52 ms
(84.48%)
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
  15364
  340567
  371061
  399079
  403765
  415752
  417871
  432405
  435888
  456233
  456247
  459089
  465672
  493823
  496081
  510736
  511006
  523362
  524787
  525384
  530038
  530315
  532451
  532638
  534045
  536013
  541855
  557416
  574664
  575035
  577338
  586903
  588379
  589243
  599364
  607560
  610170
  624207
  626796
  628342
  634190
  635357
  641598
  669305
  678349
  680740
  682926
  683880
  688181
  691157
  692345
  704958
  705258
  707490
  711947
  712272
  713021
  714562
  720952
  721714
  724339
  724954
  728046
  728368
  731492
  733233
  736191
  736305
  736887
  736972
  737643
  738088
  738105
  741496
  744378
  744751
  745472
  746513
  747572
  747885
  749611
  749614
  750187
  751405
  752223
  752405
  752584
  756623
  757257
  760402
  760554
  761049
  766821
  767475
  772953
  773322
  776289
  778388
  782150
  784333
  785443
  789346
  791426
  794142
  796845
  796925
  798796
  799140
  800860
  803854
  806242
  806611
  806826
  806828
  808269
  811234
  811706
  827452
  828478
]
13.82 ms
(9.01%)
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
  669305
  683880
  778388
  782150
  773322
  736972
  707490
  796845
  806242
  806826
  541855
  626796
  525384
  493823
  634190
  624207
  496081
  712272
  720952
  721714
  682926
  635357
  628342
  789346
  733233
  736305
  737643
  794142
  738105
  752223
  757257
  728046
  738088
  738923
  744378
  745472
  747572
  724339
  731492
  741496
  749614
  767475
  704958
  791426
  796925
  806828
  588379
  714562
  557416
  641598
  747885
  459089
  532638
  724954
  403765
  827452
  756623
  523362
  574664
  530315
  456233
  688181
  680740
  799140
  803854
  736887
  750187
  749611
  751405
  806611
  811234
  511006
  772953
  610170
  785443
  798796
  586903
  691157
  761049
  607560
  589243
  760402
  728368
  456247
  575035
  711947
  705258
  432405
  399079
  417871
  340567
  532451
  766821
  752405
  371061
  524787
  800860
  736191
  746513
  534045
  752584
  776289
  808269
  811706
  828478
  15364
  435888
  415752
  536013
  744751
  760554
  713021
  577338
  599364
  784333
  465672
  530038
  510736
  678349
  692345
]
2.59 ms
(1.69%)
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
  15364
  340567
  371061
  399079
  403765
  415752
  417871
  432405
  435888
  456233
  456247
  459089
  465672
  493823
  496081
  510736
  511006
  523362
  524787
  525384
  530038
  530315
  532451
  532638
  534045
  536013
  541855
  557416
  574664
  575035
  577338
  586903
  588379
  589243
  599364
  607560
  610170
  624207
  626796
  628342
  634190
  635357
  641598
  669305
  678349
  680740
  682926
  683880
  688181
  691157
  692345
  704958
  705258
  707490
  711947
  712272
  713021
  714562
  720952
  721714
  724339
  724954
  728046
  728368
  731492
  733233
  736191
  736305
  736887
  736972
  737643
  738088
  738105
  741496
  744378
  744751
  745472
  746513
  747572
  747885
  749611
  749614
  750187
  751405
  752223
  752405
  752584
  756623
  757257
  760402
  760554
  761049
  766821
  767475
  772953
  773322
  776289
  778388
  782150
  784333
  785443
  789346
  791426
  794142
  796845
  796925
  798796
  799140
  800860
  803854
  806242
  806611
  806826
  806828
  808269
  811234
  811706
  827452
  828478
]
2.18 ms
(1.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big ass girls"
]
1.93 ms
(1.26%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие жоп девушк"
]
1.61 ms
(1.05%)
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.