Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.10 ms
(83.21%)
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
  382818
  390790
  398119
  402969
  411552
  417068
  420824
  422427
  422495
  423155
  424247
  425287
  427129
  427985
  434470
  434531
  438006
  443443
  450118
  451506
  455244
  455463
  455628
  455781
  456055
  456512
  456589
  457093
  460109
  461732
  461809
  462555
  462571
  463347
  463807
  475571
  477188
  479361
  480278
  481198
  485142
  489715
  490710
  493024
  493286
  498723
  505359
  505360
  506649
  516215
  517316
  522124
  525599
  537240
  542509
  544275
  546806
  553242
  556504
  560243
  561809
  561912
  563555
  564125
  565086
  565328
  568681
  578221
  582121
  584825
  586188
  588060
  588173
  588508
  590577
  594079
  595111
  601945
  615650
  626074
  626489
  628480
  647140
  666404
  674340
  679166
  680572
  692074
  692653
  704341
  709635
  712869
  720530
  722040
  731521
  732744
  739627
  758512
  761436
  761789
  763079
  766882
  771734
  779037
  779262
  781479
  783385
  786990
  787130
  789588
  789843
  790256
  791109
  793593
  794106
  794668
  796011
  805000
  805141
  805152
]
18.00 ms
(9.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
  758512
  450118
  489715
  588508
  463807
  709635
  582121
  761436
  779262
  783385
  398119
  402969
  456589
  457093
  771734
  789588
  455244
  561809
  786990
  462571
  556504
  590577
  595111
  790256
  794106
  781479
  794668
  763079
  731521
  704341
  789843
  479361
  626074
  692653
  422427
  455463
  434531
  456512
  382818
  390790
  588173
  791109
  578221
  568681
  553242
  588060
  626489
  805000
  761789
  805152
  739627
  427129
  417068
  434470
  420824
  505359
  560243
  525599
  542509
  647140
  425287
  517316
  720530
  732744
  793593
  584825
  485142
  480278
  544275
  565328
  722040
  680572
  712869
  586188
  615650
  628480
  796011
  805141
  787130
  601945
  451506
  461809
  481198
  493286
  455628
  477188
  411552
  456055
  475571
  462555
  490710
  564125
  422495
  443443
  461732
  424247
  438006
  455781
  522124
  493024
  498723
  506649
  423155
  766882
  516215
  460109
  565086
  674340
  692074
  779037
  594079
  463347
  427985
  505360
  537240
  546806
  561912
  563555
  679166
  666404
]
4.56 ms
(2.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "минет оральн секс cum"
]
2.33 ms
(1.28%)
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
  382818
  390790
  398119
  402969
  411552
  417068
  420824
  422427
  422495
  423155
  424247
  425287
  427129
  427985
  434470
  434531
  438006
  443443
  450118
  451506
  455244
  455463
  455628
  455781
  456055
  456512
  456589
  457093
  460109
  461732
  461809
  462555
  462571
  463347
  463807
  475571
  477188
  479361
  480278
  481198
  485142
  489715
  490710
  493024
  493286
  498723
  505359
  505360
  506649
  516215
  517316
  522124
  525599
  537240
  542509
  544275
  546806
  553242
  556504
  560243
  561809
  561912
  563555
  564125
  565086
  565328
  568681
  578221
  582121
  584825
  586188
  588060
  588173
  588508
  590577
  594079
  595111
  601945
  615650
  626074
  626489
  628480
  647140
  666404
  674340
  679166
  680572
  692074
  692653
  704341
  709635
  712869
  720530
  722040
  731521
  732744
  739627
  758512
  761436
  761789
  763079
  766882
  771734
  779037
  779262
  781479
  783385
  786990
  787130
  789588
  789843
  790256
  791109
  793593
  794106
  794668
  796011
  805000
  805141
  805152
]
2.06 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blowjob with cum"
]
2.02 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "минет оральн секс cum"
]
1.72 ms
(0.94%)
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.