Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.85 ms
(84.19%)
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
  118201
  131726
  381226
  385880
  386732
  405761
  407503
  414078
  423586
  425422
  433814
  438513
  444265
  445984
  452738
  454038
  458973
  468511
  469411
  472535
  480424
  481828
  485020
  487216
  487871
  493084
  495165
  495233
  499911
  505989
  506584
  507481
  508172
  509512
  511002
  511164
  511546
  513450
  514227
  514938
  517664
  518415
  521799
  522729
  522739
  526816
  528541
  529178
  532040
  533397
  535515
  535962
  536392
  537173
  538472
  538794
  539589
  540760
  542740
  544054
  550510
  550806
  550913
  554954
  555191
  555232
  555298
  555447
  555467
  557098
  559399
  563600
  565028
  576421
  576437
  581964
  581974
  584389
  584843
  584871
  585888
  586157
  586488
  588603
  588646
  590502
  591874
  592562
  594088
  594420
  595612
  596637
  596989
  599648
  600812
  600889
  601777
  602379
  603321
  603993
  604444
  605651
  605809
  610012
  615908
  616062
  616510
  618465
  619040
  622503
  623370
  623646
  625753
  626551
  626872
  628692
  628823
  629498
  629663
  635694
]
15.05 ms
(9.26%)
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
  586488
  599648
  600812
  616062
  623370
  588646
  590502
  604444
  605809
  610012
  626872
  628823
  629663
  635694
  586157
  588603
  594088
  601777
  603993
  619040
  622503
  628692
  585888
  591874
  592562
  594420
  595612
  596637
  596989
  600889
  603321
  605651
  616510
  618465
  623646
  626551
  629498
  602379
  615908
  625753
  454038
  495233
  509512
  385880
  386732
  118201
  131726
  381226
  405761
  407503
  444265
  414078
  425422
  423586
  438513
  433814
  468511
  469411
  445984
  452738
  481828
  485020
  458973
  472535
  487871
  499911
  522739
  533397
  506584
  511002
  517664
  521799
  522729
  526816
  528541
  529178
  538472
  538794
  540760
  507481
  511164
  514227
  514938
  532040
  535515
  535962
  495165
  505989
  508172
  511546
  513450
  518415
  536392
  537173
  539589
  480424
  487216
  493084
  542740
  544054
  550510
  550806
  555447
  563600
  576421
  584843
  584871
  550913
  555232
  555298
  555467
  557098
  559399
  565028
  576437
  581964
  581974
  584389
  554954
  555191
]
3.60 ms
(2.21%)
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
  118201
  131726
  381226
  385880
  386732
  405761
  407503
  414078
  423586
  425422
  433814
  438513
  444265
  445984
  452738
  454038
  458973
  468511
  469411
  472535
  480424
  481828
  485020
  487216
  487871
  493084
  495165
  495233
  499911
  505989
  506584
  507481
  508172
  509512
  511002
  511164
  511546
  513450
  514227
  514938
  517664
  518415
  521799
  522729
  522739
  526816
  528541
  529178
  532040
  533397
  535515
  535962
  536392
  537173
  538472
  538794
  539589
  540760
  542740
  544054
  550510
  550806
  550913
  554954
  555191
  555232
  555298
  555447
  555467
  557098
  559399
  563600
  565028
  576421
  576437
  581964
  581974
  584389
  584843
  584871
  585888
  586157
  586488
  588603
  588646
  590502
  591874
  592562
  594088
  594420
  595612
  596637
  596989
  599648
  600812
  600889
  601777
  602379
  603321
  603993
  604444
  605651
  605809
  610012
  615908
  616062
  616510
  618465
  619040
  622503
  623370
  623646
  625753
  626551
  626872
  628692
  628823
  629498
  629663
  635694
]
2.06 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "киску"
]
1.87 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вагин"
]
1.67 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.45 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.