Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.58 ms
(78.41%)
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
  389711
  390108
  417109
  418456
  419081
  419312
  419468
  420505
  423585
  423593
  425895
  428082
  432457
  433322
  433590
  433855
  434407
  436765
  438191
  438466
  440895
  441818
  445012
  452422
  452754
  454674
  456130
  458278
  459897
  459966
  461677
  463400
  467111
  467716
  477507
  480328
  480815
  492969
  498419
  501507
  506973
  507113
  507420
  509009
  509627
  514328
  517383
  521696
  525661
  528196
  538071
  546738
  550952
  557020
  560887
  563811
  577661
  579649
  580857
  582822
  585936
  587208
  592276
  594219
  594443
  595143
  595318
  595358
  595419
  595581
  596935
  598448
  601194
  602251
  605699
  607697
  612068
  614516
  618852
  621040
  621056
  628289
  631604
  632143
  653349
  663749
  668620
  736790
  741855
  751822
  752308
  752641
  752679
  753963
  755198
  758335
  760220
  760659
  762332
  765183
  765250
  766637
  768659
  769476
  773278
  776035
  783466
  783704
  784976
  789453
  791042
  795404
  796372
  797010
  800513
  803534
  808962
  812612
  812842
]
16.44 ms
(10.52%)
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
  765250
  783466
  736790
  752308
  752679
  765183
  751822
  768659
  741855
  760220
  753963
  773278
  776035
  783704
  791042
  797010
  420505
  432457
  438466
  463400
  445012
  423585
  423593
  454674
  418456
  433855
  440895
  492969
  594443
  389711
  528196
  546738
  577661
  653349
  631604
  598448
  618852
  592276
  594219
  595143
  595358
  621040
  621056
  632143
  628289
  390108
  419081
  428082
  436765
  419312
  452754
  467111
  452422
  456130
  477507
  498419
  507113
  514328
  506973
  550952
  563811
  557020
  560887
  580857
  668620
  579649
  582822
  595581
  587208
  595419
  596935
  601194
  784976
  795404
  796372
  789453
  803534
  808962
  752641
  758335
  812612
  812842
  766637
  762332
  769476
  755198
  760659
  800513
  438191
  480815
  419468
  433590
  459897
  425895
  458278
  480328
  434407
  441818
  459966
  461677
  467716
  417109
  509627
  501507
  507420
  517383
  538071
  521696
  663749
  605699
  585936
  607697
  614516
  595318
  602251
  433322
  509009
  525661
  612068
  826077
]
9.13 ms
(5.84%)
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
  389711
  390108
  417109
  418456
  419081
  419312
  419468
  420505
  423585
  423593
  425895
  428082
  432457
  433322
  433590
  433855
  434407
  436765
  438191
  438466
  440895
  441818
  445012
  452422
  452754
  454674
  456130
  458278
  459897
  459966
  461677
  463400
  467111
  467716
  477507
  480328
  480815
  492969
  498419
  501507
  506973
  507113
  507420
  509009
  509627
  514328
  517383
  521696
  525661
  528196
  538071
  546738
  550952
  557020
  560887
  563811
  577661
  579649
  580857
  582822
  585936
  587208
  592276
  594219
  594443
  595143
  595318
  595358
  595419
  595581
  596935
  598448
  601194
  602251
  605699
  607697
  612068
  614516
  618852
  621040
  621056
  628289
  631604
  632143
  653349
  663749
  668620
  736790
  741855
  751822
  752308
  752641
  752679
  753963
  755198
  758335
  760220
  760659
  762332
  765183
  765250
  766637
  768659
  769476
  773278
  776035
  783466
  783704
  784976
  789453
  791042
  795404
  796372
  797010
  800513
  803534
  808962
  812612
  812842
]
2.54 ms
(1.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск riding"
]
2.07 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateurs riding"
]
1.83 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск riding"
]

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.