Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
242.67 ms
(89.72%)
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
  304300
  407418
  411201
  414357
  419633
  420814
  420874
  426702
  428174
  429844
  434654
  437864
  440923
  442455
  446108
  446745
  447191
  447608
  447668
  451064
  451654
  452827
  452833
  453409
  455060
  463426
  464366
  464887
  470175
  473392
  488789
  493034
  496033
  504173
  505325
  508353
  514660
  515564
  521850
  525970
  530630
  530851
  531261
  532643
  532703
  533376
  537675
  537929
  537988
  542583
  543556
  543659
  544796
  556911
  559453
  569359
  588811
  590073
  596919
  598504
  600071
  600418
  600500
  606578
  606821
  621287
  624942
  629411
  630869
  632618
  637021
  637034
  639119
  640732
  642060
  644916
  644952
  647307
  648825
  649619
  649914
  661034
  662065
  670811
  672388
  677781
  678732
  700306
  706765
  710096
  720202
  722373
  729691
  737117
  740527
  740817
  740910
  741518
  747140
  749237
  749669
  751110
  751435
  759005
  762064
  765222
  766302
  767430
  777574
  777818
  778811
  782511
  782539
  787438
  792689
  796682
  807067
  807190
  818067
  823519
]
17.72 ms
(6.55%)
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
  792689
  740817
  740527
  737117
  782511
  429844
  428174
  447608
  533376
  649914
  624942
  642060
  762064
  629411
  470175
  473392
  440923
  766302
  447191
  543556
  437864
  537929
  647307
  543659
  446108
  493034
  670811
  590073
  588811
  777818
  767430
  782539
  807190
  759005
  749669
  504173
  452833
  531261
  530851
  537988
  542583
  649619
  544796
  747140
  606578
  455060
  505325
  515564
  639119
  407418
  451654
  463426
  508353
  644916
  532643
  446745
  600071
  751435
  464366
  304300
  442455
  818067
  662065
  672388
  678732
  661034
  706765
  720202
  600500
  621287
  596919
  807067
  729691
  740910
  741518
  749237
  751110
  796682
  426702
  630869
  434654
  556911
  640732
  451064
  514660
  496033
  414357
  447668
  521850
  530630
  532703
  537675
  559453
  677781
  648825
  722373
  637021
  637034
  632618
  453409
  411201
  464887
  420814
  420874
  419633
  644952
  823519
  452827
  488789
  525970
  700306
  710096
  569359
  598504
  600418
  606821
  777574
  778811
  787438
  765222
]
3.23 ms
(1.20%)
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
  304300
  407418
  411201
  414357
  419633
  420814
  420874
  426702
  428174
  429844
  434654
  437864
  440923
  442455
  446108
  446745
  447191
  447608
  447668
  451064
  451654
  452827
  452833
  453409
  455060
  463426
  464366
  464887
  470175
  473392
  488789
  493034
  496033
  504173
  505325
  508353
  514660
  515564
  521850
  525970
  530630
  530851
  531261
  532643
  532703
  533376
  537675
  537929
  537988
  542583
  543556
  543659
  544796
  556911
  559453
  569359
  588811
  590073
  596919
  598504
  600071
  600418
  600500
  606578
  606821
  621287
  624942
  629411
  630869
  632618
  637021
  637034
  639119
  640732
  642060
  644916
  644952
  647307
  648825
  649619
  649914
  661034
  662065
  670811
  672388
  677781
  678732
  700306
  706765
  710096
  720202
  722373
  729691
  737117
  740527
  740817
  740910
  741518
  747140
  749237
  749669
  751110
  751435
  759005
  762064
  765222
  766302
  767430
  777574
  777818
  778811
  782511
  782539
  787438
  792689
  796682
  807067
  807190
  818067
  823519
]
2.16 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen pussy дилд"
]
1.88 ms
(0.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen pussy dildo"
]
1.42 ms
(0.53%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.40 ms
(0.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen pussy дилд"
]

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.