Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.94 ms
(86.85%)
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
  129246
  392165
  398436
  400563
  469503
  488848
  506571
  514702
  528880
  530664
  541565
  542443
  545798
  547941
  549951
  552861
  554709
  560342
  566737
  568612
  579127
  589083
  592741
  599763
  601948
  606212
  611541
  614455
  623710
  625597
  625750
  633052
  633563
  633664
  634289
  634362
  638947
  644857
  644974
  650692
  662480
  666476
  669896
  669903
  680612
  694704
  695652
  695980
  695997
  696009
  696061
  697917
  701604
  706642
  707812
  708297
  709517
  709855
  710042
  718717
  733983
  734261
  734386
  734429
  735235
  736031
  736510
  740238
  740761
  744034
  744568
  746098
  751377
  751422
  752765
  754885
  760932
  764993
  768042
  768669
  773584
  778186
  780884
  785562
  788141
  789650
  791579
  797826
  798746
  798857
  799010
  800663
  803156
  804418
  809767
  812230
  812238
  814166
  817403
  817519
  817788
  819438
  819452
  820475
  820504
  820564
  821037
  821140
  821143
  821168
  821564
  823157
  825538
  828046
  828047
  828065
  828098
  828243
  828376
]
14.71 ms
(7.94%)
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
  788141
  791579
  744034
  754885
  768669
  785562
  803156
  514702
  129246
  817403
  820504
  820564
  821143
  822935
  821140
  740761
  733983
  599763
  392165
  400563
  817519
  821168
  821564
  819438
  819452
  821037
  823157
  814166
  817788
  828065
  828243
  825538
  530664
  542443
  541565
  568612
  566737
  718717
  547941
  554709
  611541
  592741
  634289
  789650
  798746
  798857
  804418
  734261
  736031
  797826
  812230
  812238
  736510
  740238
  744568
  735235
  751377
  633563
  706642
  709855
  780884
  799010
  800663
  398436
  760932
  606212
  633664
  625750
  633052
  644857
  680612
  710042
  669896
  768042
  506571
  528880
  560342
  650692
  828046
  828098
  828376
  828047
  549951
  488848
  638947
  601948
  545798
  662480
  614455
  634362
  589083
  734429
  701604
  579127
  669903
  778186
  734386
  773584
  809767
  764993
  752765
  746098
  751422
  707812
  644974
  820475
  469503
  552861
  695652
  695980
  695997
  696009
  696061
  709517
  666476
  694704
  697917
  708297
  623710
  625597
]
2.75 ms
(1.48%)
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
  129246
  392165
  398436
  400563
  469503
  488848
  506571
  514702
  528880
  530664
  541565
  542443
  545798
  547941
  549951
  552861
  554709
  560342
  566737
  568612
  579127
  589083
  592741
  599763
  601948
  606212
  611541
  614455
  623710
  625597
  625750
  633052
  633563
  633664
  634289
  634362
  638947
  644857
  644974
  650692
  662480
  666476
  669896
  669903
  680612
  694704
  695652
  695980
  695997
  696009
  696061
  697917
  701604
  706642
  707812
  708297
  709517
  709855
  710042
  718717
  733983
  734261
  734386
  734429
  735235
  736031
  736510
  740238
  740761
  744034
  744568
  746098
  751377
  751422
  752765
  754885
  760932
  764993
  768042
  768669
  773584
  778186
  780884
  785562
  788141
  789650
  791579
  797826
  798746
  798857
  799010
  800663
  803156
  804418
  809767
  812230
  812238
  814166
  817403
  817519
  817788
  819438
  819452
  820475
  820504
  820564
  821037
  821140
  821143
  821168
  821564
  823157
  825538
  828046
  828047
  828065
  828098
  828243
  828376
]
1.91 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public cock"
]
1.82 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на cock улиц"
]
1.67 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.51 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на cock улиц"
]

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.