Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.51 ms
(83.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
  341729
  394417
  399824
  401500
  406171
  407015
  408460
  410934
  415936
  420120
  421078
  423329
  424411
  426009
  427182
  436932
  438001
  438067
  442831
  443094
  443103
  446167
  447265
  448562
  451266
  451620
  454364
  455986
  456393
  460041
  467553
  467571
  468675
  471171
  472496
  474632
  477439
  477442
  477554
  478044
  482499
  482510
  483473
  483553
  484402
  487435
  489280
  493893
  494162
  501499
  507646
  509808
  509879
  510394
  517603
  520714
  521805
  522094
  523851
  523868
  525662
  532504
  532785
  532945
  534041
  534993
  536281
  536283
  536640
  537017
  537902
  537906
  546828
  549799
  550670
  551936
  554338
  556054
  557243
  565423
  575806
  580966
  583725
  594016
  599852
  600346
  600973
  601887
  608695
  610271
  610822
  614553
  618596
  623205
  627703
  630915
  636579
  639742
  641455
  641690
  641986
  642064
  643013
  647877
  648740
  650333
  650813
  667550
  676024
  681161
  696518
  699526
  699554
  699610
  700294
  720720
  720927
  732069
  755108
  827855
]
16.04 ms
(10.57%)
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
  827855
  600973
  667550
  408460
  399824
  438001
  426009
  447265
  474632
  507646
  720720
  510394
  546828
  421078
  532945
  648740
  536283
  732069
  467571
  472496
  468675
  551936
  341729
  407015
  442831
  482510
  460041
  534041
  536281
  537906
  536640
  537902
  493893
  650333
  681161
  699554
  696518
  614553
  601887
  643013
  700294
  494162
  600346
  448562
  534993
  554338
  699526
  650813
  630915
  451266
  550670
  484402
  456393
  647877
  594016
  454364
  610271
  443094
  455986
  521805
  532785
  610822
  401500
  755108
  517603
  575806
  627703
  639742
  523851
  537017
  520714
  522094
  580966
  642064
  599852
  641455
  483553
  451620
  471171
  478044
  509808
  557243
  720927
  438067
  482499
  641986
  618596
  424411
  489280
  532504
  636579
  608695
  509879
  487435
  467553
  423329
  676024
  477442
  523868
  641690
  477439
  420120
  415936
  623205
  427182
  410934
  483473
  443103
  446167
  477554
  556054
  565423
  549799
  583725
  501499
  436932
  699610
  394417
  406171
  525662
]
2.98 ms
(1.97%)
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
  341729
  394417
  399824
  401500
  406171
  407015
  408460
  410934
  415936
  420120
  421078
  423329
  424411
  426009
  427182
  436932
  438001
  438067
  442831
  443094
  443103
  446167
  447265
  448562
  451266
  451620
  454364
  455986
  456393
  460041
  467553
  467571
  468675
  471171
  472496
  474632
  477439
  477442
  477554
  478044
  482499
  482510
  483473
  483553
  484402
  487435
  489280
  493893
  494162
  501499
  507646
  509808
  509879
  510394
  517603
  520714
  521805
  522094
  523851
  523868
  525662
  532504
  532785
  532945
  534041
  534993
  536281
  536283
  536640
  537017
  537902
  537906
  546828
  549799
  550670
  551936
  554338
  556054
  557243
  565423
  575806
  580966
  583725
  594016
  599852
  600346
  600973
  601887
  608695
  610271
  610822
  614553
  618596
  623205
  627703
  630915
  636579
  639742
  641455
  641690
  641986
  642064
  643013
  647877
  648740
  650333
  650813
  667550
  676024
  681161
  696518
  699526
  699554
  699610
  700294
  720720
  720927
  732069
  755108
  827855
]
1.88 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "slut threesome"
]
1.47 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "slut секс втро"
]
1.41 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "slut секс втро"
]

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.