Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
218.48 ms
(87.86%)
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
  185038
  379578
  381758
  383051
  383486
  385096
  385105
  386518
  389147
  390185
  399008
  404722
  406578
  406993
  407549
  413465
  416144
  418933
  436628
  436859
  445233
  446860
  447529
  447882
  448061
  454323
  454714
  457767
  463882
  467273
  469820
  469825
  478760
  481873
  487514
  489110
  489225
  489318
  501805
  503215
  507171
  507175
  510043
  515779
  516406
  518032
  518328
  518347
  527029
  527660
  543043
  545814
  551329
  551334
  551422
  554777
  557266
  558617
  563796
  565940
  565943
  572010
  591115
  600581
  600602
  603516
  603583
  619604
  620317
  624285
  625452
  634756
  643436
  653247
  653253
  654331
  663391
  670270
  677030
  677041
  697178
  720458
  722098
  722810
  722896
  728067
  732379
  735530
  737921
  738907
  738925
  738927
  740007
  740235
  743810
  747376
  749551
  773182
  776724
  781022
  782003
  789745
  794425
  797499
  800005
  800066
  800069
  808241
  813949
  815958
  816047
  816517
  818324
  818390
  818725
  821572
  822737
  824724
  825204
  827828
]
19.66 ms
(7.91%)
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
  591115
  808241
  489318
  507175
  816047
  399008
  743810
  510043
  448061
  390185
  406993
  543043
  722810
  654331
  740007
  738925
  740235
  749551
  738907
  722896
  794425
  416144
  815958
  469820
  557266
  653253
  600602
  634756
  789745
  565940
  818725
  818324
  825204
  677030
  643436
  738927
  379578
  454714
  527029
  619604
  404722
  383486
  185038
  813949
  489225
  677041
  551334
  624285
  797499
  732379
  728067
  781022
  800069
  385096
  389147
  507171
  469825
  670270
  413465
  463882
  545814
  600581
  406578
  407549
  385105
  824724
  816517
  446860
  776724
  800066
  381758
  487514
  436628
  697178
  800005
  737921
  782003
  386518
  383051
  822737
  818390
  821572
  827828
  551329
  565943
  720458
  663391
  722098
  603516
  620317
  747376
  735530
  773182
  436859
  457767
  447882
  515779
  516406
  518347
  481873
  554777
  558617
  563796
  551422
  572010
  653247
  603583
  625452
  478760
  445233
  447529
  503215
  489110
  518032
  501805
  418933
  454323
  518328
  467273
  527660
]
3.49 ms
(1.40%)
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
  185038
  379578
  381758
  383051
  383486
  385096
  385105
  386518
  389147
  390185
  399008
  404722
  406578
  406993
  407549
  413465
  416144
  418933
  436628
  436859
  445233
  446860
  447529
  447882
  448061
  454323
  454714
  457767
  463882
  467273
  469820
  469825
  478760
  481873
  487514
  489110
  489225
  489318
  501805
  503215
  507171
  507175
  510043
  515779
  516406
  518032
  518328
  518347
  527029
  527660
  543043
  545814
  551329
  551334
  551422
  554777
  557266
  558617
  563796
  565940
  565943
  572010
  591115
  600581
  600602
  603516
  603583
  619604
  620317
  624285
  625452
  634756
  643436
  653247
  653253
  654331
  663391
  670270
  677030
  677041
  697178
  720458
  722098
  722810
  722896
  728067
  732379
  735530
  737921
  738907
  738925
  738927
  740007
  740235
  743810
  747376
  749551
  773182
  776724
  781022
  782003
  789745
  794425
  797499
  800005
  800066
  800069
  808241
  813949
  815958
  816047
  816517
  818324
  818390
  818725
  821572
  822737
  824724
  825204
  827828
]
2.02 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "massage tits"
]
1.79 ms
(0.72%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "массаж сиськ"
]
1.66 ms
(0.67%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(0.64%)
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.