Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.88 ms
(82.09%)
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
  6958
  124661
  134506
  204605
  206046
  237986
  238244
  327502
  331382
  381993
  382611
  383475
  383801
  387279
  388423
  391206
  400883
  401004
  402123
  404084
  404404
  419590
  420412
  425931
  428087
  433542
  433620
  438058
  443873
  444136
  445340
  448738
  450069
  455186
  455619
  460124
  462371
  462821
  462826
  466038
  466055
  472940
  473927
  475427
  475917
  483230
  485074
  491351
  501517
  503974
  505530
  505935
  505944
  509167
  515672
  515688
  515692
  515706
  515711
  517081
  520933
  521174
  522744
  522961
  523148
  525619
  526882
  528673
  530556
  535328
  538042
  538973
  542193
  544586
  545820
  545909
  546973
  549164
  553658
  554791
  559433
  563131
  564275
  564640
  568699
  571378
  571940
  585473
  585526
  588326
  589142
  591823
  596324
  596928
  600808
  601255
  601619
  618985
  619474
  626945
  630879
  633674
  642934
  680625
  687098
  689318
  695401
  702294
  711589
  716231
  717122
  718764
  759837
  759972
  760822
  776856
  778210
  799034
  805123
  805292
]
16.82 ms
(10.80%)
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
  526882
  237986
  718764
  702294
  805123
  759972
  238244
  438058
  535328
  546973
  433620
  538973
  448738
  515711
  445340
  571940
  585526
  485074
  545909
  687098
  134506
  466055
  554791
  383801
  563131
  466038
  433542
  760822
  515672
  428087
  542193
  400883
  404084
  530556
  571378
  716231
  601255
  630879
  600808
  759837
  717122
  778210
  420412
  525619
  383475
  689318
  520933
  549164
  553658
  626945
  444136
  528673
  402123
  462821
  425931
  327502
  503974
  564640
  559433
  596324
  206046
  455186
  680625
  596928
  501517
  521174
  462826
  401004
  522744
  491351
  589142
  591823
  450069
  382611
  404404
  538042
  601619
  618985
  799034
  505935
  588326
  619474
  483230
  545820
  711589
  776856
  805292
  388423
  475917
  523148
  515692
  387279
  509167
  204605
  443873
  475427
  472940
  419590
  515706
  331382
  124661
  515688
  695401
  633674
  381993
  473927
  6958
  391206
  642934
  460124
  505530
  505944
  462371
  544586
  564275
  568699
  585473
  455619
  522961
  517081
]
3.20 ms
(2.05%)
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
  6958
  124661
  134506
  204605
  206046
  237986
  238244
  327502
  331382
  381993
  382611
  383475
  383801
  387279
  388423
  391206
  400883
  401004
  402123
  404084
  404404
  419590
  420412
  425931
  428087
  433542
  433620
  438058
  443873
  444136
  445340
  448738
  450069
  455186
  455619
  460124
  462371
  462821
  462826
  466038
  466055
  472940
  473927
  475427
  475917
  483230
  485074
  491351
  501517
  503974
  505530
  505935
  505944
  509167
  515672
  515688
  515692
  515706
  515711
  517081
  520933
  521174
  522744
  522961
  523148
  525619
  526882
  528673
  530556
  535328
  538042
  538973
  542193
  544586
  545820
  545909
  546973
  549164
  553658
  554791
  559433
  563131
  564275
  564640
  568699
  571378
  571940
  585473
  585526
  588326
  589142
  591823
  596324
  596928
  600808
  601255
  601619
  618985
  619474
  626945
  630879
  633674
  642934
  680625
  687098
  689318
  695401
  702294
  711589
  716231
  717122
  718764
  759837
  759972
  760822
  776856
  778210
  799034
  805123
  805292
]
2.25 ms
(1.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "порно с секретаршей в …"
]
2.13 ms
(1.37%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.85 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "порн секретарш в"
]
1.65 ms
(1.06%)
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.