Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.60 ms
(80.61%)
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
  101056
  383418
  388177
  396100
  396961
  397299
  397918
  398268
  400465
  403392
  403770
  404383
  405520
  407761
  407804
  407878
  412930
  415580
  417011
  420174
  420543
  421435
  423313
  424839
  428057
  428073
  428403
  440917
  442131
  442557
  445302
  446697
  447005
  448355
  448868
  450951
  453580
  453794
  454043
  454573
  454642
  454956
  456171
  459711
  460617
  460626
  460996
  461017
  461106
  462476
  465923
  467662
  471416
  475313
  476541
  477448
  481435
  481636
  482163
  482951
  484279
  486249
  487340
  488087
  489296
  490438
  491014
  491767
  494862
  496495
  500706
  501968
  502599
  504668
  504775
  505652
  514359
  514459
  519854
  520743
  528146
  543400
  544504
  544509
  545726
  546045
  546632
  547976
  554365
  554903
  555089
  555569
  559026
  560045
  560389
  561590
  561639
  561710
  561991
  563038
  563234
  564963
  565136
  565402
  567315
  568097
  569970
  573789
  574489
  575751
  576298
  576299
  577428
  578363
  581475
  586741
  587865
  589682
  590352
  591010
]
19.71 ms
(12.55%)
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
  490438
  514459
  520743
  528146
  383418
  101056
  388177
  396100
  397299
  396961
  398268
  397918
  400465
  404383
  405520
  403392
  403770
  407804
  421435
  407761
  407878
  442131
  412930
  415580
  417011
  420543
  428073
  440917
  420174
  423313
  424839
  428057
  442557
  428403
  445302
  446697
  447005
  448355
  450951
  453794
  454573
  454642
  454956
  471416
  489296
  453580
  456171
  459711
  460617
  462476
  465923
  475313
  481636
  482951
  484279
  488087
  491014
  491767
  448868
  454043
  460626
  460996
  461106
  467662
  476541
  482163
  486249
  494862
  496495
  501968
  502599
  500706
  504668
  504775
  514359
  505652
  519854
  461017
  477448
  481435
  487340
  543400
  544509
  559026
  560045
  560389
  561590
  576299
  578363
  544504
  545726
  547976
  555089
  563038
  565136
  577428
  546045
  546632
  554365
  554903
  563234
  567315
  574489
  555569
  561639
  561710
  561991
  564963
  565402
  568097
  569970
  573789
  575751
  576298
  581475
  586741
  591010
  587865
  590352
  589682
]
2.69 ms
(1.71%)
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
  101056
  383418
  388177
  396100
  396961
  397299
  397918
  398268
  400465
  403392
  403770
  404383
  405520
  407761
  407804
  407878
  412930
  415580
  417011
  420174
  420543
  421435
  423313
  424839
  428057
  428073
  428403
  440917
  442131
  442557
  445302
  446697
  447005
  448355
  448868
  450951
  453580
  453794
  454043
  454573
  454642
  454956
  456171
  459711
  460617
  460626
  460996
  461017
  461106
  462476
  465923
  467662
  471416
  475313
  476541
  477448
  481435
  481636
  482163
  482951
  484279
  486249
  487340
  488087
  489296
  490438
  491014
  491767
  494862
  496495
  500706
  501968
  502599
  504668
  504775
  505652
  514359
  514459
  519854
  520743
  528146
  543400
  544504
  544509
  545726
  546045
  546632
  547976
  554365
  554903
  555089
  555569
  559026
  560045
  560389
  561590
  561639
  561710
  561991
  563038
  563234
  564963
  565136
  565402
  567315
  568097
  569970
  573789
  574489
  575751
  576298
  576299
  577428
  578363
  581475
  586741
  587865
  589682
  590352
  591010
]
2.36 ms
(1.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fucked boy"
]
2.06 ms
(1.31%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "fucked парен"
]
1.77 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "fucked парен"
]

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.