Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.57 ms
(87.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
  79942
  387693
  390257
  401229
  404000
  418132
  418256
  418975
  419616
  420351
  421346
  421802
  422819
  423584
  423765
  423907
  424214
  426771
  428027
  432383
  432431
  432433
  432453
  432481
  432485
  432504
  432534
  432540
  433373
  433429
  433640
  433707
  433822
  435620
  457348
  459066
  462588
  469147
  471712
  472621
  472812
  475288
  475643
  480091
  480557
  483855
  490257
  493571
  496020
  496846
  500654
  503877
  505992
  508696
  511473
  513582
  515637
  521480
  525975
  526880
  532057
  534475
  535962
  536100
  553655
  555063
  559365
  561916
  564379
  565819
  578877
  583538
  604320
  622686
  660076
  663193
  686862
  687422
  695701
  695730
  695733
  695734
  695777
  695793
  695812
  708505
  710093
  710173
  713038
  718891
  721819
  727040
  730741
  735834
  735959
  739814
  739960
  753504
  757238
  757559
  760598
  760875
  760881
  761834
  767638
  767669
  767984
  768691
  772230
  777761
  778858
  785584
  788778
  791758
  791763
  797052
  812732
  814206
]
12.98 ms
(6.99%)
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
  532057
  535962
  508696
  525975
  561916
  559365
  687422
  695734
  695812
  710173
  718891
  708505
  710093
  660076
  663193
  713038
  604320
  623097
  778858
  791758
  788778
  735959
  739814
  760598
  785584
  791763
  753504
  757559
  760881
  768691
  739960
  757238
  760875
  767669
  735834
  767638
  772230
  730741
  761834
  767984
  721819
  777761
  797052
  812732
  79942
  423907
  432383
  432485
  433822
  459066
  469147
  421802
  432433
  432481
  433640
  472812
  404000
  432431
  432453
  432504
  432534
  432540
  390257
  419616
  426771
  433707
  480557
  422819
  433373
  475643
  521480
  526880
  483855
  500654
  553655
  695777
  578877
  727040
  462588
  565819
  401229
  424214
  420351
  622686
  511473
  457348
  471712
  564379
  686862
  602781
  418256
  433429
  515637
  493571
  387693
  421346
  423584
  423765
  418975
  428027
  435620
  418132
  814206
  472621
  480091
  505992
  503877
  536100
  496020
  496846
  513582
  534475
  475288
  490257
  583538
  555063
  695701
  695733
  695793
  695730
]
3.39 ms
(1.82%)
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
  79942
  387693
  390257
  401229
  404000
  418132
  418256
  418975
  419616
  420351
  421346
  421802
  422819
  423584
  423765
  423907
  424214
  426771
  428027
  432383
  432431
  432433
  432453
  432481
  432485
  432504
  432534
  432540
  433373
  433429
  433640
  433707
  433822
  435620
  457348
  459066
  462588
  469147
  471712
  472621
  472812
  475288
  475643
  480091
  480557
  483855
  490257
  493571
  496020
  496846
  500654
  503877
  505992
  508696
  511473
  513582
  515637
  521480
  525975
  526880
  532057
  534475
  535962
  536100
  553655
  555063
  559365
  561916
  564379
  565819
  578877
  583538
  604320
  622686
  660076
  663193
  686862
  687422
  695701
  695730
  695733
  695734
  695777
  695793
  695812
  708505
  710093
  710173
  713038
  718891
  721819
  727040
  730741
  735834
  735959
  739814
  739960
  753504
  757238
  757559
  760598
  760875
  760881
  761834
  767638
  767669
  767984
  768691
  772230
  777761
  778858
  785584
  788778
  791758
  791763
  797052
  812732
  814206
]
1.89 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"порно в колготках женâ…"
]
1.74 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "порн колготк жен"
]
1.47 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.