Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.66 ms
(59.93%)
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
  12405
  13570
  25069
  34580
  43029
  97769
  145612
  159036
  159865
  166247
  189380
  197451
  307398
  311697
  330564
  342024
  342317
  382143
  382296
  382555
  383222
  383415
  383563
  384086
  384978
  385751
  385945
  387030
  388226
  388771
  389213
  392565
  392843
  396375
  396790
  396932
  397391
  399541
  400591
  402087
  402936
  403279
  404426
  408842
  411534
  430564
  441241
  456424
  458116
  460845
  461448
  464504
  468169
  470174
  477402
  478770
  480326
  483998
  485863
  490941
  506293
  510589
  511241
  511345
  520881
  521217
  524524
  542429
  549389
  560569
  560925
  561973
  573375
  581081
  585227
  587264
  589366
  596203
  602051
  604375
  611115
  613161
  616186
  623633
  624469
  637303
  638194
  642317
  643698
  655531
  656449
  665489
  669858
  688938
  689784
  711991
  712962
  717063
  723154
  735884
  736539
  739931
  746299
  752276
  754049
  756339
  758093
  759677
  767081
  767231
  781481
  781690
  789366
  794888
  802571
  802612
  804510
  810170
  811691
  812877
]
119.47 ms
(33.67%)
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
  12405
  13570
  25069
  34580
  43029
  97769
  145612
  159036
  159865
  166247
  189380
  197451
  307398
  311697
  330564
  342024
  342317
  382143
  382296
  382555
  383222
  383415
  383563
  384086
  384978
  385751
  385945
  387030
  388226
  388771
  389213
  392565
  392843
  396375
  396790
  396932
  397391
  399541
  400591
  402087
  402936
  403279
  404426
  408842
  411534
  430564
  441241
  456424
  458116
  460845
  461448
  464504
  468169
  470174
  477402
  478770
  480326
  483998
  485863
  490941
  506293
  510589
  511241
  511345
  520881
  521217
  524524
  542429
  549389
  560569
  560925
  561973
  573375
  581081
  585227
  587264
  589366
  596203
  602051
  604375
  611115
  613161
  616186
  623633
  624469
  637303
  638194
  642317
  643698
  655531
  656449
  665489
  669858
  688938
  689784
  711991
  712962
  717063
  723154
  735884
  736539
  739931
  746299
  752276
  754049
  756339
  758093
  759677
  767081
  767231
  781481
  781690
  789366
  794888
  802571
  802612
  804510
  810170
  811691
  812877
]
15.52 ms
(4.37%)
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
  756339
  643698
  166247
  385945
  464504
  384086
  402936
  461448
  490941
  560925
  573375
  560569
  561973
  587264
  604375
  480326
  511345
  510589
  520881
  524524
  342024
  382555
  34580
  388771
  387030
  396375
  399541
  404426
  411534
  430564
  408842
  478770
  542429
  549389
  581081
  711991
  655531
  688938
  623633
  789366
  802612
  810170
  781481
  794888
  754049
  759677
  746299
  736539
  739931
  767081
  638194
  43029
  383222
  384978
  392565
  97769
  477402
  403279
  307398
  460845
  470174
  385751
  383415
  383563
  197451
  145612
  159036
  189380
  392843
  311697
  330564
  382143
  382296
  25069
  12405
  13570
  389213
  388226
  396790
  397391
  396932
  400591
  402087
  441241
  458116
  468169
  483998
  456424
  511241
  521217
  506293
  485863
  712962
  656449
  669858
  689784
  665489
  596203
  616186
  613161
  637303
  602051
  624469
  585227
  589366
  642317
  811691
  812877
  802571
  781690
  804510
  752276
  735884
  758093
  767231
  611115
  717063
  723154
  159865
  342317
]
2.08 ms
(0.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "полы"
]
1.98 ms
(0.56%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пол"
]
1.48 ms
(0.42%)
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.