Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.57 ms
(81.04%)
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
  387522
  400474
  411731
  413134
  416880
  423697
  425979
  426481
  433584
  434763
  435550
  438052
  439467
  442750
  447094
  447604
  449450
  451133
  456466
  456487
  457026
  457226
  458744
  458882
  459191
  462572
  463966
  464721
  465385
  466397
  466491
  467642
  469011
  474964
  477881
  479955
  479962
  484879
  485258
  485589
  485619
  485996
  490945
  492986
  500576
  500976
  501415
  502729
  503498
  504132
  504320
  505078
  506233
  507630
  507641
  513007
  514904
  517143
  517927
  519476
  520098
  520898
  521017
  522513
  524239
  525186
  526865
  528663
  528751
  536871
  538194
  548297
  549729
  552380
  555000
  560814
  563722
  565687
  565695
  565773
  571048
  575557
  576081
  579396
  582920
  584465
  585156
  588052
  588953
  591219
  591694
  597432
  602944
  603067
  603783
  605498
  605963
  609235
  610011
  610832
  612068
  614715
  623211
  623499
  625369
  626405
  637172
  641414
  670056
  691137
  693284
  696430
  721895
  722277
  726718
  733319
  742279
  757094
  767025
  785507
]
18.28 ms
(12.29%)
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
  466397
  479955
  456466
  474964
  463966
  479962
  484879
  504320
  526865
  485589
  485619
  507630
  522513
  485258
  490945
  492986
  502729
  519476
  521017
  411731
  605963
  785507
  757094
  458744
  506233
  538194
  626405
  447094
  467642
  462572
  528751
  520098
  525186
  500976
  505078
  507641
  536871
  693284
  576081
  610832
  625369
  387522
  485996
  552380
  416880
  413134
  423697
  425979
  439467
  426481
  434763
  449450
  458882
  459191
  465385
  456487
  517927
  528663
  524239
  500576
  514904
  520898
  501415
  503498
  504132
  513007
  517143
  548297
  549729
  571048
  579396
  560814
  563722
  565773
  575557
  584465
  555000
  670056
  691137
  696430
  721895
  722277
  565687
  565695
  582920
  588052
  603067
  610011
  585156
  591694
  623499
  588953
  591219
  614715
  623211
  597432
  602944
  603783
  605498
  609235
  637172
  641414
  726718
  733319
  767025
  742279
  612068
  464721
  433584
  442750
  447604
  451133
  457026
  457226
  466491
  469011
  477881
  400474
  435550
  438052
]
2.45 ms
(1.64%)
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
  387522
  400474
  411731
  413134
  416880
  423697
  425979
  426481
  433584
  434763
  435550
  438052
  439467
  442750
  447094
  447604
  449450
  451133
  456466
  456487
  457026
  457226
  458744
  458882
  459191
  462572
  463966
  464721
  465385
  466397
  466491
  467642
  469011
  474964
  477881
  479955
  479962
  484879
  485258
  485589
  485619
  485996
  490945
  492986
  500576
  500976
  501415
  502729
  503498
  504132
  504320
  505078
  506233
  507630
  507641
  513007
  514904
  517143
  517927
  519476
  520098
  520898
  521017
  522513
  524239
  525186
  526865
  528663
  528751
  536871
  538194
  548297
  549729
  552380
  555000
  560814
  563722
  565687
  565695
  565773
  571048
  575557
  576081
  579396
  582920
  584465
  585156
  588052
  588953
  591219
  591694
  597432
  602944
  603067
  603783
  605498
  605963
  609235
  610011
  610832
  612068
  614715
  623211
  623499
  625369
  626405
  637172
  641414
  670056
  691137
  693284
  696430
  721895
  722277
  726718
  733319
  742279
  757094
  767025
  785507
]
2.22 ms
(1.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife porn"
]
1.90 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен porn"
]
1.79 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен porn"
]
1.57 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.