Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
150.69 ms
(87.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
  12326
  193890
  393972
  395392
  408730
  411817
  457177
  470837
  531964
  533657
  544482
  554508
  557311
  559917
  565815
  566070
  586711
  591895
  600881
  603288
  608355
  609653
  613383
  613792
  618473
  620245
  625597
  626730
  630597
  654353
  664267
  665200
  666659
  667207
  669225
  669435
  669890
  671660
  674752
  688016
  693388
  696977
  700536
  707981
  708469
  709797
  717188
  718143
  721039
  721091
  721276
  721388
  721438
  722116
  722181
  723980
  724090
  726016
  729664
  732144
  739188
  740272
  741620
  747057
  747912
  748320
  748451
  752535
  753476
  754872
  755436
  755794
  757324
  757754
  758050
  759919
  769199
  773166
  775004
  776635
  777889
  779651
  781185
  781224
  782170
  782284
  782695
  786944
  787207
  791630
  794616
  794710
  795475
  797854
  800177
  800463
  801337
  804037
  804217
  806238
  807171
  809249
  810399
  810866
  810918
  811937
  812171
  813795
  815011
  817679
  820736
  821183
  821625
  821923
  822242
  822701
  826745
  826996
  827372
  827832
]
12.48 ms
(7.25%)
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
  722181
  600881
  757754
  193890
  813795
  821923
  654353
  669435
  718143
  688016
  591895
  782284
  810399
  810866
  804217
  807171
  781185
  669225
  671660
  693388
  696977
  723980
  800463
  782170
  809249
  815011
  817679
  826745
  826996
  827372
  820736
  821183
  821625
  822701
  827832
  544482
  557311
  559917
  708469
  721091
  665200
  666659
  674752
  667207
  709797
  717188
  722116
  586711
  613383
  608355
  776635
  787207
  791630
  781224
  794616
  800177
  806238
  726016
  739188
  752535
  769199
  794710
  724090
  748320
  755436
  740272
  741620
  753476
  773166
  732144
  754872
  747057
  748451
  757324
  758050
  603288
  721276
  721388
  777889
  795475
  801337
  804037
  812171
  411817
  393972
  620245
  797854
  12326
  822242
  531964
  707981
  779651
  721039
  408730
  554508
  613792
  782695
  729664
  669890
  759919
  395392
  747912
  664267
  470837
  533657
  565815
  609653
  775004
  457177
  566070
  700536
  721438
  626730
  618473
  625597
  630597
  786944
  755794
  810918
  811937
]
2.66 ms
(1.54%)
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
  12326
  193890
  393972
  395392
  408730
  411817
  457177
  470837
  531964
  533657
  544482
  554508
  557311
  559917
  565815
  566070
  586711
  591895
  600881
  603288
  608355
  609653
  613383
  613792
  618473
  620245
  625597
  626730
  630597
  654353
  664267
  665200
  666659
  667207
  669225
  669435
  669890
  671660
  674752
  688016
  693388
  696977
  700536
  707981
  708469
  709797
  717188
  718143
  721039
  721091
  721276
  721388
  721438
  722116
  722181
  723980
  724090
  726016
  729664
  732144
  739188
  740272
  741620
  747057
  747912
  748320
  748451
  752535
  753476
  754872
  755436
  755794
  757324
  757754
  758050
  759919
  769199
  773166
  775004
  776635
  777889
  779651
  781185
  781224
  782170
  782284
  782695
  786944
  787207
  791630
  794616
  794710
  795475
  797854
  800177
  800463
  801337
  804037
  804217
  806238
  807171
  809249
  810399
  810866
  810918
  811937
  812171
  813795
  815011
  817679
  820736
  821183
  821625
  821923
  822242
  822701
  826745
  826996
  827372
  827832
]
1.94 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "horny blowjob"
]
1.64 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "horny минет оральн секс"
]
1.36 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "horny минет оральн секс"
]

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.