Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
117.44 ms
(82.84%)
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
  40927
  210146
  272132
  385657
  397191
  415309
  453126
  454930
  457668
  458925
  464941
  465434
  469418
  474094
  474969
  479368
  480301
  480305
  483139
  505963
  508740
  511074
  516468
  518545
  529571
  530412
  532271
  532632
  535378
  535381
  535409
  539350
  541107
  543656
  544534
  547415
  547443
  551899
  554766
  555099
  555206
  557606
  559200
  564262
  566918
  569089
  570883
  573202
  575028
  576574
  580984
  581369
  584355
  588401
  589739
  590134
  599809
  602600
  604881
  605173
  605320
  607017
  614360
  619638
  620234
  623568
  624466
  626400
  629205
  640879
  643026
  665962
  694062
  698246
  699590
  712786
  716160
  716490
  719924
  726625
  728205
  728328
  732848
  732901
  732913
  734420
  741437
  744414
  744986
  747500
  748483
  752966
  753246
  753702
  758425
  784298
  788985
  796017
  798939
  802316
  807994
  810361
  811010
  811649
  812236
  813714
  817432
  817639
  817853
  818995
  819020
  819053
  819096
  819536
  820364
  825181
  826434
  826608
  828037
  828258
]
12.89 ms
(9.09%)
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
  741437
  728328
  732848
  744986
  758425
  726625
  620234
  798939
  807994
  811010
  454930
  474969
  817639
  813714
  479368
  584355
  551899
  573202
  699590
  589739
  605320
  802316
  748483
  796017
  812236
  210146
  817432
  817853
  818995
  819053
  825181
  826608
  819020
  819096
  819536
  826434
  820364
  828037
  828258
  530412
  535409
  532632
  535378
  535381
  543656
  570883
  547415
  581369
  694062
  698246
  665962
  716160
  716490
  576574
  590134
  624466
  599809
  602600
  588401
  604881
  614360
  643026
  811649
  734420
  753246
  744414
  752966
  753702
  732901
  747500
  629205
  719924
  788985
  810361
  40927
  483139
  547443
  458925
  272132
  539350
  544534
  554766
  640879
  605173
  619638
  784298
  728205
  623568
  712786
  385657
  516468
  575028
  557606
  564262
  607017
  626400
  732913
  397191
  415309
  465434
  511074
  508740
  464941
  518545
  480301
  480305
  453126
  469418
  569089
  580984
  555206
  529571
  541107
  566918
  457668
  505963
  532271
  474094
  555099
  559200
]
4.29 ms
(3.02%)
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
  40927
  210146
  272132
  385657
  397191
  415309
  453126
  454930
  457668
  458925
  464941
  465434
  469418
  474094
  474969
  479368
  480301
  480305
  483139
  505963
  508740
  511074
  516468
  518545
  529571
  530412
  532271
  532632
  535378
  535381
  535409
  539350
  541107
  543656
  544534
  547415
  547443
  551899
  554766
  555099
  555206
  557606
  559200
  564262
  566918
  569089
  570883
  573202
  575028
  576574
  580984
  581369
  584355
  588401
  589739
  590134
  599809
  602600
  604881
  605173
  605320
  607017
  614360
  619638
  620234
  623568
  624466
  626400
  629205
  640879
  643026
  665962
  694062
  698246
  699590
  712786
  716160
  716490
  719924
  726625
  728205
  728328
  732848
  732901
  732913
  734420
  741437
  744414
  744986
  747500
  748483
  752966
  753246
  753702
  758425
  784298
  788985
  796017
  798939
  802316
  807994
  810361
  811010
  811649
  812236
  813714
  817432
  817639
  817853
  818995
  819020
  819053
  819096
  819536
  820364
  825181
  826434
  826608
  828037
  828258
]
2.15 ms
(1.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature public suck"
]
1.67 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature на suck улиц"
]
1.67 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature на suck улиц"
]

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.