Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.70 ms
(84.53%)
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
  382025
  388308
  393724
  396020
  401229
  404740
  407795
  408284
  410608
  410657
  411201
  411751
  411787
  412593
  413944
  414357
  414548
  417344
  417482
  418399
  419406
  419557
  421604
  423563
  425320
  427454
  442994
  443773
  447926
  451500
  459486
  460533
  460911
  467605
  468628
  473735
  490953
  500312
  501611
  506143
  513978
  516625
  517612
  522205
  523114
  527733
  529243
  530486
  530630
  530770
  531120
  531215
  531254
  532703
  532754
  532772
  533538
  534797
  534995
  535006
  537903
  539233
  540405
  555783
  556909
  557336
  564416
  565276
  565539
  567323
  573087
  580340
  599559
  603386
  604060
  613172
  619556
  625412
  627806
  632636
  637034
  639748
  639752
  639759
  642018
  642660
  644941
  645861
  646923
  647854
  648839
  650830
  664531
  679016
  680593
  680597
  727643
  728385
  728881
  741990
  747140
  747459
  749289
  749321
  749338
  760788
  766649
  773668
  773822
  775284
  775385
  777577
  779682
  786815
  792341
  794980
  804756
  810678
  810978
  818592
]
14.99 ms
(9.33%)
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
  516625
  603386
  412593
  408284
  425320
  421604
  539233
  646923
  777577
  779682
  804756
  810978
  564416
  810678
  747459
  642660
  627806
  530770
  565539
  529243
  501611
  418399
  410657
  625412
  664531
  773668
  749321
  557336
  818592
  414357
  427454
  473735
  411787
  411201
  523114
  556909
  599559
  766649
  460533
  747140
  443773
  468628
  500312
  644941
  749338
  580340
  728385
  530486
  531120
  534995
  679016
  632636
  396020
  645861
  401229
  460911
  619556
  404740
  555783
  407795
  413944
  442994
  517612
  533538
  650830
  411751
  459486
  393724
  410608
  423563
  447926
  506143
  417482
  647854
  490953
  565276
  527733
  727643
  794980
  680597
  680593
  792341
  741990
  728881
  749289
  522205
  417344
  531215
  532754
  534797
  530630
  531254
  532703
  532772
  535006
  537903
  540405
  648839
  642018
  637034
  639752
  639759
  639748
  467605
  388308
  773822
  760788
  775284
  775385
  786815
  419406
  573087
  451500
  567323
  604060
  414548
  382025
  419557
  513978
  613172
]
2.82 ms
(1.76%)
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
  382025
  388308
  393724
  396020
  401229
  404740
  407795
  408284
  410608
  410657
  411201
  411751
  411787
  412593
  413944
  414357
  414548
  417344
  417482
  418399
  419406
  419557
  421604
  423563
  425320
  427454
  442994
  443773
  447926
  451500
  459486
  460533
  460911
  467605
  468628
  473735
  490953
  500312
  501611
  506143
  513978
  516625
  517612
  522205
  523114
  527733
  529243
  530486
  530630
  530770
  531120
  531215
  531254
  532703
  532754
  532772
  533538
  534797
  534995
  535006
  537903
  539233
  540405
  555783
  556909
  557336
  564416
  565276
  565539
  567323
  573087
  580340
  599559
  603386
  604060
  613172
  619556
  625412
  627806
  632636
  637034
  639748
  639752
  639759
  642018
  642660
  644941
  645861
  646923
  647854
  648839
  650830
  664531
  679016
  680593
  680597
  727643
  728385
  728881
  741990
  747140
  747459
  749289
  749321
  749338
  760788
  766649
  773668
  773822
  775284
  775385
  777577
  779682
  786815
  792341
  794980
  804756
  810678
  810978
  818592
]
1.86 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "куни и жёсткий трах"
]
1.84 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "куннилингус оральн секс хардкор секс"
]
1.79 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "куннилингус оральн секс хардкор секс"
]
1.54 ms
(0.96%)
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.