Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.29 ms
(85.62%)
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
  7365
  45605
  95990
  148793
  161358
  382344
  382958
  386986
  387295
  389234
  396006
  396730
  398053
  402350
  405504
  406363
  411052
  413788
  418031
  425627
  428535
  446341
  463845
  464161
  472553
  472804
  485354
  486647
  488931
  498821
  501591
  515691
  515777
  520726
  539416
  552951
  555602
  560456
  563478
  583182
  587214
  589187
  589238
  589941
  591701
  601101
  604610
  610101
  611918
  614990
  618285
  620147
  620857
  620876
  622582
  623964
  634711
  635967
  648925
  650236
  651601
  664389
  669192
  669224
  669771
  673767
  681596
  683152
  693307
  695939
  697130
  698407
  710937
  715360
  715523
  715533
  715853
  717461
  718203
  721060
  721065
  722248
  722552
  724262
  724483
  725633
  728442
  732293
  732782
  735942
  737550
  737720
  739961
  741306
  742163
  744261
  744654
  754321
  772681
  773796
  774243
  775974
  782861
  786723
  788073
  789094
  793151
  801524
  804937
  805424
  806121
  806220
  807697
  812372
  813388
  813959
  817074
  820849
  823294
  824938
]
11.30 ms
(7.85%)
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
  773796
  386986
  717461
  664389
  695939
  754321
  464161
  552951
  721065
  635967
  589187
  801524
  446341
  722552
  789094
  782861
  804937
  741306
  744261
  382344
  396730
  824938
  786723
  95990
  742163
  823294
  820849
  715360
  669224
  623964
  737720
  806121
  806220
  486647
  563478
  715523
  683152
  681596
  620147
  591701
  772681
  744654
  735942
  485354
  601101
  161358
  817074
  697130
  724262
  148793
  651601
  555602
  610101
  788073
  813388
  396006
  669192
  669771
  648925
  698407
  715853
  614990
  620857
  587214
  725633
  732782
  728442
  732293
  737550
  604610
  620876
  715533
  611918
  501591
  498821
  693307
  807697
  618285
  405504
  463845
  488931
  622582
  774243
  472804
  398053
  805424
  650236
  634711
  812372
  739961
  718203
  775974
  45605
  515777
  402350
  589238
  389234
  520726
  472553
  793151
  425627
  406363
  413788
  418031
  539416
  724483
  428535
  411052
  721060
  382958
  722248
  710937
  589941
  387295
  673767
  7365
  813959
  515691
  583182
  560456
]
2.30 ms
(1.60%)
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
  7365
  45605
  95990
  148793
  161358
  382344
  382958
  386986
  387295
  389234
  396006
  396730
  398053
  402350
  405504
  406363
  411052
  413788
  418031
  425627
  428535
  446341
  463845
  464161
  472553
  472804
  485354
  486647
  488931
  498821
  501591
  515691
  515777
  520726
  539416
  552951
  555602
  560456
  563478
  583182
  587214
  589187
  589238
  589941
  591701
  601101
  604610
  610101
  611918
  614990
  618285
  620147
  620857
  620876
  622582
  623964
  634711
  635967
  648925
  650236
  651601
  664389
  669192
  669224
  669771
  673767
  681596
  683152
  693307
  695939
  697130
  698407
  710937
  715360
  715523
  715533
  715853
  717461
  718203
  721060
  721065
  722248
  722552
  724262
  724483
  725633
  728442
  732293
  732782
  735942
  737550
  737720
  739961
  741306
  742163
  744261
  744654
  754321
  772681
  773796
  774243
  775974
  782861
  786723
  788073
  789094
  793151
  801524
  804937
  805424
  806121
  806220
  807697
  812372
  813388
  813959
  817074
  820849
  823294
  824938
]
2.09 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big tits black"
]
1.94 ms
(1.35%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие сиськ black"
]
1.50 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие сиськ black"
]

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.