Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.07 ms
(84.36%)
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
  24855
  79601
  118226
  122488
  385690
  390360
  391108
  391554
  397445
  401601
  405690
  408432
  409934
  415777
  418054
  422277
  433380
  439758
  452297
  454274
  457449
  457473
  458623
  460659
  461717
  462010
  462931
  463695
  465270
  465540
  466227
  469034
  471164
  471608
  472670
  473949
  474132
  474265
  475968
  477927
  478806
  478904
  481124
  483629
  488414
  495250
  496726
  506866
  508698
  513641
  514205
  518763
  522094
  523636
  523833
  523867
  526526
  529236
  530003
  531533
  532746
  534683
  537135
  540799
  547423
  549829
  549848
  549851
  554992
  555086
  555108
  555119
  555138
  558700
  564286
  567683
  568991
  571103
  578734
  584771
  590613
  593083
  602959
  715368
  715572
  720105
  726595
  726602
  731254
  731836
  731913
  733097
  734373
  734730
  736196
  737598
  739927
  740991
  741023
  742585
  742749
  744968
  747958
  748395
  757388
  763547
  765391
  766650
  783145
  787580
  789160
  794420
  795731
  797178
  801254
  801450
  802132
  802195
  818349
  826127
]
14.46 ms
(8.96%)
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
  766650
  726602
  747958
  783145
  801450
  415777
  526526
  555138
  452297
  508698
  547423
  740991
  514205
  748395
  558700
  460659
  481124
  513641
  540799
  79601
  473949
  555086
  578734
  523636
  465270
  454274
  390360
  458623
  555108
  439758
  469034
  457473
  401601
  409934
  555119
  474132
  532746
  462010
  568991
  554992
  523867
  726595
  478904
  478806
  466227
  737598
  518763
  763547
  731254
  475968
  567683
  529236
  734730
  731913
  720105
  795731
  471164
  472670
  122488
  391108
  522094
  584771
  549848
  602959
  457449
  483629
  534683
  523833
  118226
  818349
  463695
  488414
  495250
  531533
  794420
  802132
  797178
  715572
  391554
  826127
  537135
  593083
  739927
  742585
  731836
  736196
  741023
  742749
  802195
  397445
  801254
  549829
  571103
  433380
  506866
  733097
  564286
  787580
  789160
  765391
  496726
  385690
  715368
  408432
  477927
  744968
  462931
  530003
  418054
  590613
  422277
  549851
  734373
  757388
  24855
  461717
  465540
  474265
  471608
  405690
]
2.92 ms
(1.81%)
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
  24855
  79601
  118226
  122488
  385690
  390360
  391108
  391554
  397445
  401601
  405690
  408432
  409934
  415777
  418054
  422277
  433380
  439758
  452297
  454274
  457449
  457473
  458623
  460659
  461717
  462010
  462931
  463695
  465270
  465540
  466227
  469034
  471164
  471608
  472670
  473949
  474132
  474265
  475968
  477927
  478806
  478904
  481124
  483629
  488414
  495250
  496726
  506866
  508698
  513641
  514205
  518763
  522094
  523636
  523833
  523867
  526526
  529236
  530003
  531533
  532746
  534683
  537135
  540799
  547423
  549829
  549848
  549851
  554992
  555086
  555108
  555119
  555138
  558700
  564286
  567683
  568991
  571103
  578734
  584771
  590613
  593083
  602959
  715368
  715572
  720105
  726595
  726602
  731254
  731836
  731913
  733097
  734373
  734730
  736196
  737598
  739927
  740991
  741023
  742585
  742749
  744968
  747958
  748395
  757388
  763547
  765391
  766650
  783145
  787580
  789160
  794420
  795731
  797178
  801254
  801450
  802132
  802195
  818349
  826127
]
2.25 ms
(1.39%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.13 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "жену ебут зрелую"
]
1.80 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен секс зрелая женщин"
]
1.66 ms
(1.03%)
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.