Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.58 ms
(84.68%)
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
  328446
  421833
  437530
  439649
  447038
  448402
  454294
  454801
  455891
  456788
  460486
  464376
  466493
  466778
  467571
  468374
  470625
  479152
  482525
  484628
  490287
  496794
  504756
  507102
  511257
  513265
  513301
  513775
  516634
  516823
  517594
  518072
  520208
  525641
  526227
  528081
  528682
  535084
  558792
  559486
  562590
  563007
  566187
  571308
  573248
  573483
  576804
  577147
  577215
  577437
  578411
  578793
  581427
  581433
  586442
  586564
  588404
  590437
  591167
  591908
  593865
  595731
  599533
  600851
  603640
  603673
  603678
  604710
  604955
  605524
  605529
  605532
  606533
  609652
  610695
  614365
  620726
  620754
  623149
  628654
  632413
  632502
  661567
  665586
  692460
  699398
  709241
  715522
  716380
  720659
  726248
  726973
  733223
  734371
  736798
  739916
  742675
  742683
  744339
  749488
  759010
  759696
  760859
  766623
  767212
  767804
  768758
  769502
  789973
  795039
  795901
  802161
  802487
  803781
  810123
  811955
  811964
  819767
  823456
  827101
]
14.33 ms
(8.95%)
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
  573248
  736798
  769502
  632502
  767212
  470625
  720659
  581427
  586442
  591167
  802161
  742675
  810123
  789973
  593865
  600851
  484628
  603678
  744339
  454801
  513301
  558792
  661567
  566187
  605529
  605524
  603673
  742683
  827101
  733223
  605532
  525641
  504756
  517594
  577147
  614365
  749488
  739916
  528682
  576804
  526227
  811964
  811955
  464376
  520208
  577215
  571308
  604955
  591908
  716380
  578411
  466493
  479152
  578793
  454294
  665586
  692460
  620726
  563007
  573483
  586564
  709241
  726973
  715522
  577437
  604710
  516823
  562590
  516634
  628654
  590437
  468374
  437530
  759696
  759010
  535084
  603640
  768758
  513775
  328446
  610695
  606533
  421833
  734371
  795901
  802487
  609652
  559486
  496794
  823456
  767804
  518072
  599533
  795039
  620754
  760859
  528081
  819767
  803781
  581433
  507102
  588404
  511257
  482525
  726248
  490287
  439649
  632413
  455891
  467571
  460486
  456788
  466778
  623149
  595731
  447038
  448402
  699398
  766623
  513265
]
3.02 ms
(1.89%)
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
  328446
  421833
  437530
  439649
  447038
  448402
  454294
  454801
  455891
  456788
  460486
  464376
  466493
  466778
  467571
  468374
  470625
  479152
  482525
  484628
  490287
  496794
  504756
  507102
  511257
  513265
  513301
  513775
  516634
  516823
  517594
  518072
  520208
  525641
  526227
  528081
  528682
  535084
  558792
  559486
  562590
  563007
  566187
  571308
  573248
  573483
  576804
  577147
  577215
  577437
  578411
  578793
  581427
  581433
  586442
  586564
  588404
  590437
  591167
  591908
  593865
  595731
  599533
  600851
  603640
  603673
  603678
  604710
  604955
  605524
  605529
  605532
  606533
  609652
  610695
  614365
  620726
  620754
  623149
  628654
  632413
  632502
  661567
  665586
  692460
  699398
  709241
  715522
  716380
  720659
  726248
  726973
  733223
  734371
  736798
  739916
  742675
  742683
  744339
  749488
  759010
  759696
  760859
  766623
  767212
  767804
  768758
  769502
  789973
  795039
  795901
  802161
  802487
  803781
  810123
  811955
  811964
  819767
  823456
  827101
]
2.03 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur mature cuckold"
]
1.88 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск mature куколд"
]
1.45 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск mature куколд"
]

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.