Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.94 ms
(80.24%)
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
  226195
  263299
  384193
  386638
  392775
  399250
  399292
  399367
  401116
  401559
  402259
  403556
  413057
  413174
  413649
  415256
  416066
  417232
  417461
  418868
  419629
  420111
  420374
  420901
  422499
  422501
  422548
  422695
  422924
  422982
  425117
  427221
  432800
  432802
  434167
  434208
  444579
  447257
  447675
  451741
  451750
  453621
  454250
  456341
  456496
  456802
  457174
  458777
  462038
  462306
  464595
  465980
  467152
  467296
  471309
  473924
  475069
  475505
  475979
  476381
  477781
  478381
  481288
  484088
  489806
  491193
  492512
  494369
  495845
  501874
  503901
  511691
  512639
  512762
  513799
  514789
  515750
  519064
  519607
  521373
  522454
  523025
  523274
  524146
  524566
  528429
  529192
  530244
  546002
  550332
  556845
  557745
  558059
  559198
  560594
  562148
  562302
  562375
  564449
  566224
  567170
  570638
  573910
  574808
  575072
  576027
  576068
  576071
  576080
  576292
  588266
  590186
  598537
  598854
  601596
  606697
  620205
  663239
  720677
  756080
]
18.64 ms
(12.47%)
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
  575072
  566224
  576068
  384193
  401559
  418868
  481288
  401116
  413174
  432802
  478381
  512639
  492512
  523274
  226195
  263299
  422548
  434208
  419629
  456341
  475979
  451750
  467296
  515750
  558059
  574808
  560594
  720677
  546002
  576292
  588266
  598854
  417461
  432800
  471309
  475069
  399367
  420901
  444579
  476381
  416066
  503901
  519064
  512762
  521373
  576080
  399292
  403556
  417232
  422501
  413057
  422982
  447257
  464595
  456802
  550332
  573910
  562375
  576027
  576071
  564449
  570638
  556845
  557745
  590186
  601596
  756080
  402259
  447675
  473924
  475505
  422499
  425117
  462306
  465980
  386638
  420111
  458777
  477781
  420374
  453621
  462038
  524146
  530244
  501874
  489806
  511691
  524566
  529192
  484088
  494369
  523025
  606697
  620205
  663239
  413649
  513799
  562302
  422695
  427221
  422924
  451741
  457174
  514789
  559198
  562148
  567170
  598537
  392775
  399250
  434167
  467152
  415256
  456496
  454250
  519607
  522454
  495845
  528429
  491193
]
3.72 ms
(2.49%)
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
  226195
  263299
  384193
  386638
  392775
  399250
  399292
  399367
  401116
  401559
  402259
  403556
  413057
  413174
  413649
  415256
  416066
  417232
  417461
  418868
  419629
  420111
  420374
  420901
  422499
  422501
  422548
  422695
  422924
  422982
  425117
  427221
  432800
  432802
  434167
  434208
  444579
  447257
  447675
  451741
  451750
  453621
  454250
  456341
  456496
  456802
  457174
  458777
  462038
  462306
  464595
  465980
  467152
  467296
  471309
  473924
  475069
  475505
  475979
  476381
  477781
  478381
  481288
  484088
  489806
  491193
  492512
  494369
  495845
  501874
  503901
  511691
  512639
  512762
  513799
  514789
  515750
  519064
  519607
  521373
  522454
  523025
  523274
  524146
  524566
  528429
  529192
  530244
  546002
  550332
  556845
  557745
  558059
  559198
  560594
  562148
  562302
  562375
  564449
  566224
  567170
  570638
  573910
  574808
  575072
  576027
  576068
  576071
  576080
  576292
  588266
  590186
  598537
  598854
  601596
  606697
  620205
  663239
  720677
  756080
]
2.09 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "старики ебуться с баб%…"
]
1.82 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "старый секс женскийрод"
]
1.72 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(1.04%)
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.