Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.16 ms
(83.50%)
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
  97288
  233934
  254390
  297917
  325595
  365954
  388253
  393641
  411590
  412237
  412880
  419056
  426028
  428068
  429146
  437249
  438657
  439829
  460959
  460962
  462374
  463729
  472728
  521736
  522954
  525917
  527252
  527776
  530234
  530259
  530263
  531385
  534459
  539333
  548412
  550691
  556382
  565998
  567240
  569935
  574169
  575250
  576934
  578559
  579575
  583359
  584123
  596559
  596820
  596980
  597870
  606372
  607503
  608449
  619420
  622166
  628588
  632280
  633253
  665115
  667099
  687452
  689771
  691291
  696125
  704281
  708183
  710153
  710777
  712420
  713816
  714104
  718961
  720435
  721266
  721464
  721756
  722154
  722543
  722652
  724840
  726082
  727410
  730572
  732461
  735587
  737976
  741083
  742974
  743086
  748010
  748147
  756349
  757804
  759026
  762627
  763296
  763331
  767385
  768089
  768757
  770577
  771868
  775799
  777979
  780277
  784103
  785708
  789655
  790918
  796403
  799402
  804929
  808760
  810373
  810528
  812132
  812145
  827016
]
15.48 ms
(9.57%)
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
  460959
  530234
  462374
  596820
  804929
  233934
  426028
  527252
  412237
  530263
  539333
  550691
  578559
  583359
  576934
  584123
  667099
  687452
  696125
  556382
  567240
  596980
  607503
  810528
  790918
  808760
  742974
  785708
  724840
  748010
  757804
  759026
  730572
  770577
  737976
  762627
  763331
  704281
  710153
  721756
  297917
  412880
  393641
  827016
  516926
  534459
  548412
  574169
  710777
  597870
  619420
  632280
  777979
  784103
  756349
  767385
  727410
  768757
  763296
  622166
  633253
  708183
  712420
  810373
  437249
  530259
  325595
  411590
  365954
  388253
  429146
  714104
  722543
  721266
  596559
  780277
  525917
  565998
  720435
  748147
  799402
  428068
  527776
  722652
  665115
  721464
  789655
  732461
  735587
  743086
  726082
  812132
  812145
  472728
  531385
  521736
  569935
  718961
  722154
  771868
  775799
  254390
  438657
  522954
  97288
  419056
  460962
  579575
  689771
  691291
  713816
  575250
  608449
  606372
  628588
  796403
  741083
  768089
  463729
  439829
]
2.95 ms
(1.82%)
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
  97288
  233934
  254390
  297917
  325595
  365954
  388253
  393641
  411590
  412237
  412880
  419056
  426028
  428068
  429146
  437249
  438657
  439829
  460959
  460962
  462374
  463729
  472728
  521736
  522954
  525917
  527252
  527776
  530234
  530259
  530263
  531385
  534459
  539333
  548412
  550691
  556382
  565998
  567240
  569935
  574169
  575250
  576934
  578559
  579575
  583359
  584123
  596559
  596820
  596980
  597870
  606372
  607503
  608449
  619420
  622166
  628588
  632280
  633253
  665115
  667099
  687452
  689771
  691291
  696125
  704281
  708183
  710153
  710777
  712420
  713816
  714104
  718961
  720435
  721266
  721464
  721756
  722154
  722543
  722652
  724840
  726082
  727410
  730572
  732461
  735587
  737976
  741083
  742974
  743086
  748010
  748147
  756349
  757804
  759026
  762627
  763296
  763331
  767385
  768089
  768757
  770577
  771868
  775799
  777979
  780277
  784103
  785708
  789655
  790918
  796403
  799402
  804929
  808760
  810373
  810528
  812132
  812145
  827016
]
2.38 ms
(1.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "небольшой член молодые"
]
2.28 ms
(1.41%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.94 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "маленький член молодые"
]
1.68 ms
(1.04%)
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.