Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.86 ms
(80.67%)
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
  73280
  391530
  394031
  399848
  405406
  407600
  409220
  410799
  425249
  429104
  437274
  438055
  446103
  462156
  464553
  464572
  477013
  477194
  479215
  480089
  482493
  486504
  496688
  499379
  511466
  513332
  515310
  522347
  527726
  530013
  539243
  542752
  546383
  548588
  552804
  554355
  555947
  556329
  556768
  556869
  565352
  574297
  579434
  579488
  581494
  582597
  587065
  593739
  596165
  600047
  605046
  607074
  609584
  610601
  613153
  618795
  619105
  619336
  624869
  625963
  626713
  627687
  631876
  633954
  648018
  670109
  674478
  677564
  682515
  682519
  692616
  697155
  699551
  701531
  707082
  709148
  712122
  724706
  726348
  726686
  731129
  732130
  733545
  735198
  737261
  737481
  739622
  743063
  744088
  744624
  747044
  747797
  748375
  750724
  753442
  755723
  756314
  758118
  758629
  759543
  762150
  762899
  764954
  765848
  769642
  775218
  779757
  781785
  782979
  789605
  790892
  792569
  794921
  800365
  806353
  810176
  811840
  814497
  821902
  826280
]
17.46 ms
(11.47%)
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
  712122
  633954
  794921
  782979
  522347
  555947
  605046
  781785
  739622
  750724
  756314
  747044
  731129
  699551
  811840
  399848
  391530
  438055
  425249
  758118
  530013
  429104
  792569
  697155
  806353
  486504
  624869
  744624
  480089
  511466
  409220
  539243
  513332
  437274
  587065
  726348
  748375
  765848
  527726
  73280
  394031
  405406
  482493
  464572
  462156
  499379
  515310
  496688
  464553
  477013
  609584
  790892
  762899
  724706
  726686
  733545
  743063
  769642
  407600
  410799
  477194
  446103
  479215
  826280
  821902
  554355
  565352
  692616
  701531
  670109
  674478
  682519
  707082
  709148
  556768
  556869
  596165
  600047
  607074
  610601
  593739
  625963
  627687
  631876
  775218
  789605
  800365
  737261
  755723
  810176
  732130
  758629
  759543
  764954
  737481
  747797
  753442
  762150
  619336
  779757
  814497
  574297
  579434
  579488
  542752
  546383
  548588
  556329
  581494
  677564
  682515
  648018
  552804
  582597
  618795
  619105
  626713
  744088
  735198
  613153
]
3.60 ms
(2.36%)
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
  73280
  391530
  394031
  399848
  405406
  407600
  409220
  410799
  425249
  429104
  437274
  438055
  446103
  462156
  464553
  464572
  477013
  477194
  479215
  480089
  482493
  486504
  496688
  499379
  511466
  513332
  515310
  522347
  527726
  530013
  539243
  542752
  546383
  548588
  552804
  554355
  555947
  556329
  556768
  556869
  565352
  574297
  579434
  579488
  581494
  582597
  587065
  593739
  596165
  600047
  605046
  607074
  609584
  610601
  613153
  618795
  619105
  619336
  624869
  625963
  626713
  627687
  631876
  633954
  648018
  670109
  674478
  677564
  682515
  682519
  692616
  697155
  699551
  701531
  707082
  709148
  712122
  724706
  726348
  726686
  731129
  732130
  733545
  735198
  737261
  737481
  739622
  743063
  744088
  744624
  747044
  747797
  748375
  750724
  753442
  755723
  756314
  758118
  758629
  759543
  762150
  762899
  764954
  765848
  769642
  775218
  779757
  781785
  782979
  789605
  790892
  792569
  794921
  800365
  806353
  810176
  811840
  814497
  821902
  826280
]
2.59 ms
(1.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big cock suck"
]
2.13 ms
(1.40%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие cock suck"
]
1.92 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие cock suck"
]
1.74 ms
(1.14%)
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.