Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.56 ms
(85.85%)
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
  402566
  466439
  480353
  487661
  490168
  495990
  500777
  508649
  519401
  522034
  526990
  530569
  533800
  535203
  535953
  540563
  540858
  545154
  546389
  547030
  547608
  548190
  555150
  555493
  556197
  560678
  563325
  565111
  566625
  567981
  569383
  576127
  576605
  579180
  584437
  585483
  588840
  589589
  590522
  592102
  592172
  592938
  592986
  593065
  600671
  601816
  602887
  604110
  609089
  614063
  615103
  615886
  617549
  619101
  622336
  622592
  623115
  629780
  629794
  629853
  637401
  639856
  640483
  644041
  644172
  648477
  649062
  650108
  665602
  666378
  666602
  668343
  669244
  669689
  670569
  674264
  681787
  684477
  690290
  704188
  708530
  709691
  712398
  719103
  734005
  734103
  734958
  736008
  738949
  739094
  741681
  741947
  744685
  745296
  746697
  746826
  747159
  749376
  749393
  751002
  751392
  752852
  753119
  755733
  759338
  765954
  772500
  772768
  773031
  773181
  774706
  777997
  778110
  784547
  784720
  785100
  793008
  812134
  818808
  820026
]
12.02 ms
(7.40%)
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
  547608
  547030
  556197
  560678
  629794
  588840
  785100
  784547
  765954
  784720
  812134
  759338
  738949
  739094
  746826
  753119
  777997
  530569
  690290
  708530
  650108
  669689
  669244
  670569
  674264
  704188
  569383
  614063
  615886
  640483
  623115
  639856
  602887
  592172
  593065
  601816
  644041
  567981
  747159
  576605
  772768
  490168
  565111
  487661
  535953
  526990
  649062
  585483
  617549
  619101
  644172
  749376
  755733
  773181
  734103
  741947
  751392
  773031
  751002
  745296
  734958
  736008
  744685
  749393
  719103
  522034
  563325
  622592
  480353
  774706
  566625
  519401
  589589
  604110
  741681
  546389
  508649
  533800
  535203
  579180
  545154
  576127
  668343
  681787
  648477
  666378
  665602
  709691
  548190
  555150
  590522
  615103
  629780
  592102
  734005
  629853
  540563
  555493
  584437
  712398
  666602
  622336
  609089
  793008
  778110
  540858
  820026
  772500
  752852
  746697
  500777
  495990
  466439
  592938
  592986
  637401
  600671
  818808
  684477
  402566
]
2.98 ms
(1.83%)
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
  402566
  466439
  480353
  487661
  490168
  495990
  500777
  508649
  519401
  522034
  526990
  530569
  533800
  535203
  535953
  540563
  540858
  545154
  546389
  547030
  547608
  548190
  555150
  555493
  556197
  560678
  563325
  565111
  566625
  567981
  569383
  576127
  576605
  579180
  584437
  585483
  588840
  589589
  590522
  592102
  592172
  592938
  592986
  593065
  600671
  601816
  602887
  604110
  609089
  614063
  615103
  615886
  617549
  619101
  622336
  622592
  623115
  629780
  629794
  629853
  637401
  639856
  640483
  644041
  644172
  648477
  649062
  650108
  665602
  666378
  666602
  668343
  669244
  669689
  670569
  674264
  681787
  684477
  690290
  704188
  708530
  709691
  712398
  719103
  734005
  734103
  734958
  736008
  738949
  739094
  741681
  741947
  744685
  745296
  746697
  746826
  747159
  749376
  749393
  751002
  751392
  752852
  753119
  755733
  759338
  765954
  772500
  772768
  773031
  773181
  774706
  777997
  778110
  784547
  784720
  785100
  793008
  812134
  818808
  820026
]
2.44 ms
(1.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "эротический реальный секс"
]
1.99 ms
(1.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.84 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "эротик любительск секс"
]
1.74 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.