Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.58 ms
(59.99%)
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
  398626
  414092
  414130
  417767
  429027
  434022
  435880
  436071
  437723
  438763
  439365
  439376
  441302
  445580
  445977
  447339
  448569
  448585
  455642
  459824
  460029
  461249
  465846
  467792
  471331
  475760
  493717
  495480
  513074
  513448
  516495
  527507
  528988
  538510
  541733
  541736
  544140
  544880
  544930
  545415
  552112
  552235
  553166
  553502
  553899
  554061
  554199
  554725
  555800
  556198
  556343
  556899
  559828
  560508
  563354
  563355
  563374
  566735
  567272
  567820
  568260
  571316
  571510
  575941
  576017
  576124
  576320
  576462
  577920
  579607
  579672
  580801
  581984
  582303
  584312
  585090
  585660
  586152
  587100
  588125
  588247
  588506
  588615
  588721
  588811
  589346
  589365
  591036
  593146
  594267
  595161
  595611
  596478
  597825
  600887
  602256
  602608
  605850
  606227
  611183
  611485
  648594
  660359
  660382
  662833
  673838
  676521
  676769
  677907
  679051
  713319
  729930
  731660
  742307
  750216
  750514
  751751
  751880
  764728
  800799
]
119.43 ms
(34.03%)
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
  398626
  414092
  414130
  417767
  429027
  434022
  435880
  436071
  437723
  438763
  439365
  439376
  441302
  445580
  445977
  447339
  448569
  448585
  455642
  459824
  460029
  461249
  465846
  467792
  471331
  475760
  493717
  495480
  513074
  513448
  516495
  527507
  528988
  538510
  541733
  541736
  544140
  544880
  544930
  545415
  552112
  552235
  553166
  553502
  553899
  554061
  554199
  554725
  555800
  556198
  556343
  556899
  559828
  560508
  563354
  563355
  563374
  566735
  567272
  567820
  568260
  571316
  571510
  575941
  576017
  576124
  576320
  576462
  577920
  579607
  579672
  580801
  581984
  582303
  584312
  585090
  585660
  586152
  587100
  588125
  588247
  588506
  588615
  588721
  588811
  589346
  589365
  591036
  593146
  594267
  595161
  595611
  596478
  597825
  600887
  602256
  602608
  605850
  606227
  611183
  611485
  648594
  660359
  660382
  662833
  673838
  676521
  676769
  677907
  679051
  713319
  729930
  731660
  742307
  750216
  750514
  751751
  751880
  764728
  800799
]
13.50 ms
(3.85%)
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
  602256
  438763
  447339
  435880
  471331
  417767
  439365
  475760
  445580
  516495
  513448
  414130
  445977
  513074
  581984
  563355
  571510
  660359
  660382
  559828
  586152
  595611
  596478
  602608
  800799
  560508
  567820
  567272
  429027
  441302
  434022
  585090
  493717
  448569
  465846
  527507
  461249
  544140
  552112
  553899
  556198
  576320
  576462
  579607
  579672
  553166
  554725
  556343
  556899
  563354
  576124
  582303
  541733
  552235
  553502
  554061
  563374
  568260
  571316
  580801
  584312
  677907
  679051
  713319
  673838
  676521
  676769
  648594
  662833
  544880
  544930
  545415
  554199
  555800
  566735
  575941
  576017
  577920
  589365
  600887
  605850
  587100
  588247
  588506
  588615
  589346
  595161
  585660
  588125
  588811
  593146
  594267
  597825
  611485
  588721
  591036
  606227
  611183
  731660
  764728
  750514
  742307
  750216
  751751
  751880
  729930
  398626
  436071
  448585
  455642
  437723
  459824
  467792
  414092
  439376
  460029
  495480
  538510
  528988
  541736
]
2.34 ms
(0.67%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny ass solo"
]
1.78 ms
(0.51%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые жоп соло"
]
1.74 ms
(0.50%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(0.47%)
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.