Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
117.85 ms
(78.92%)
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
  446101
  446167
  450293
  473505
  478973
  483543
  483547
  483548
  522874
  527198
  532772
  535026
  538473
  541856
  544381
  545604
  545610
  550774
  554286
  556014
  562373
  565254
  565259
  565267
  568537
  568579
  571228
  572023
  573479
  573926
  575778
  576399
  579359
  580714
  581301
  583989
  591077
  596323
  597028
  597263
  598590
  598828
  599852
  599861
  599862
  599902
  599914
  599955
  599964
  599977
  599990
  600026
  600185
  600206
  600215
  600321
  600330
  600334
  600352
  600410
  601517
  601579
  601600
  601635
  602650
  603462
  603816
  606494
  606508
  615716
  617410
  622402
  623205
  624179
  627804
  627809
  627813
  628365
  628376
  628379
  628387
  628388
  628406
  628415
  630297
  630540
  631193
  631209
  631965
  631972
  632001
  632580
  632614
  632654
  632979
  633114
  633444
  633795
  634118
  634777
  634778
  637422
  640779
  640783
  641667
  641678
  642775
  646007
  646838
  649556
  674927
  677294
  679016
  679810
  680181
  680189
  701310
  702168
  702677
  720056
]
22.34 ms
(14.96%)
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
  600330
  601579
  602650
  624179
  628365
  628376
  632654
  596323
  597263
  598590
  599852
  600215
  600352
  601635
  627804
  628379
  628388
  598828
  599902
  599990
  600334
  601517
  640779
  640783
  641667
  603462
  627813
  631193
  633444
  642775
  446167
  572023
  556014
  599977
  538473
  473505
  532772
  541856
  544381
  545610
  565254
  680189
  720056
  550774
  554286
  600185
  631972
  632580
  641678
  628415
  632614
  617410
  478973
  450293
  483548
  483547
  535026
  583989
  446101
  603816
  581301
  562373
  573479
  575778
  576399
  579359
  568537
  568579
  571228
  573926
  646007
  674927
  677294
  679016
  679810
  680181
  649556
  646838
  599861
  606508
  627809
  630297
  630540
  631965
  633795
  597028
  599964
  600026
  600206
  600321
  601600
  591077
  599914
  600410
  623205
  628387
  628406
  632979
  606494
  622402
  632001
  634778
  633114
  634118
  580714
  637422
  599955
  599862
  615716
  631209
  634777
  701310
  483543
  522874
  527198
  545604
  565267
  565259
  702168
  702677
]
2.66 ms
(1.78%)
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
  446101
  446167
  450293
  473505
  478973
  483543
  483547
  483548
  522874
  527198
  532772
  535026
  538473
  541856
  544381
  545604
  545610
  550774
  554286
  556014
  562373
  565254
  565259
  565267
  568537
  568579
  571228
  572023
  573479
  573926
  575778
  576399
  579359
  580714
  581301
  583989
  591077
  596323
  597028
  597263
  598590
  598828
  599852
  599861
  599862
  599902
  599914
  599955
  599964
  599977
  599990
  600026
  600185
  600206
  600215
  600321
  600330
  600334
  600352
  600410
  601517
  601579
  601600
  601635
  602650
  603462
  603816
  606494
  606508
  615716
  617410
  622402
  623205
  624179
  627804
  627809
  627813
  628365
  628376
  628379
  628387
  628388
  628406
  628415
  630297
  630540
  631193
  631209
  631965
  631972
  632001
  632580
  632614
  632654
  632979
  633114
  633444
  633795
  634118
  634777
  634778
  637422
  640779
  640783
  641667
  641678
  642775
  646007
  646838
  649556
  674927
  677294
  679016
  679810
  680181
  680189
  701310
  702168
  702677
  720056
]
1.87 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "casting big butt"
]
1.63 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "кастинг большие butt"
]
1.51 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "кастинг большие butt"
]
1.47 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.