Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.27 ms
(83.94%)
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
  11393
  41776
  87974
  88788
  118237
  118436
  154195
  155257
  384223
  393684
  394536
  396231
  396784
  398041
  413053
  419403
  421366
  421582
  426689
  427447
  454802
  471832
  472777
  473054
  488721
  499872
  504681
  508924
  510561
  514618
  515785
  516426
  516495
  530060
  540911
  541096
  541328
  541394
  542124
  542701
  544829
  544961
  544963
  545411
  545459
  546257
  547453
  547465
  547471
  547477
  547501
  548723
  550284
  550555
  550895
  550940
  554889
  556842
  556892
  556907
  556908
  561019
  568267
  571166
  573936
  576479
  580176
  580207
  583586
  588514
  594619
  595860
  596610
  598115
  601542
  602241
  606503
  609920
  610314
  612070
  615946
  617969
  620611
  620901
  624197
  624925
  633755
  645019
  649556
  653216
  660364
  660369
  660380
  668663
  668690
  669058
  670356
  671008
  672944
  672952
  673257
  677322
  677333
  706411
  709628
  719573
  725382
  735555
  736022
  742224
  742459
  744033
  745129
  747153
  747673
  747920
  752679
  754902
  782854
  799007
]
14.17 ms
(9.20%)
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
  541096
  541394
  542124
  544829
  544963
  545411
  547465
  547501
  550940
  556842
  580176
  541328
  545459
  550555
  550895
  561019
  568267
  576479
  540911
  542701
  546257
  547453
  547477
  554889
  556892
  556908
  573936
  580207
  653216
  660380
  668663
  672944
  677322
  677333
  660364
  660369
  670356
  671008
  672952
  706411
  668690
  673257
  709628
  544961
  547471
  548723
  550284
  556907
  571166
  583586
  595860
  602241
  606503
  617969
  620611
  594619
  598115
  601542
  624197
  588514
  609920
  615946
  620901
  633755
  596610
  799007
  782854
  736022
  744033
  745129
  747153
  747673
  752679
  742224
  742459
  735555
  747920
  725382
  754902
  612070
  719573
  87974
  118237
  413053
  473054
  88788
  155257
  396231
  421582
  426689
  471832
  396784
  11393
  41776
  118436
  154195
  384223
  393684
  394536
  421366
  508924
  516495
  514618
  516426
  515785
  488721
  499872
  504681
  510561
  669058
  649556
  624925
  427447
  454802
  472777
  530060
  645019
  610314
  419403
  398041
]
2.74 ms
(1.78%)
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
  11393
  41776
  87974
  88788
  118237
  118436
  154195
  155257
  384223
  393684
  394536
  396231
  396784
  398041
  413053
  419403
  421366
  421582
  426689
  427447
  454802
  471832
  472777
  473054
  488721
  499872
  504681
  508924
  510561
  514618
  515785
  516426
  516495
  530060
  540911
  541096
  541328
  541394
  542124
  542701
  544829
  544961
  544963
  545411
  545459
  546257
  547453
  547465
  547471
  547477
  547501
  548723
  550284
  550555
  550895
  550940
  554889
  556842
  556892
  556907
  556908
  561019
  568267
  571166
  573936
  576479
  580176
  580207
  583586
  588514
  594619
  595860
  596610
  598115
  601542
  602241
  606503
  609920
  610314
  612070
  615946
  617969
  620611
  620901
  624197
  624925
  633755
  645019
  649556
  653216
  660364
  660369
  660380
  668663
  668690
  669058
  670356
  671008
  672944
  672952
  673257
  677322
  677333
  706411
  709628
  719573
  725382
  735555
  736022
  742224
  742459
  744033
  745129
  747153
  747673
  747920
  752679
  754902
  782854
  799007
]
2.30 ms
(1.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "худую жестко"
]
1.89 ms
(1.23%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худая хардкор"
]
1.87 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худая хардкор"
]
1.75 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.