Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.64 ms
(87.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
  27777
  38313
  69969
  73926
  163368
  233346
  295616
  295700
  308583
  335196
  358200
  381811
  382378
  382884
  382979
  386103
  386297
  388482
  388848
  390387
  393734
  393747
  393783
  396165
  396734
  398805
  402588
  403045
  403049
  446376
  484126
  488311
  503926
  505524
  515110
  515118
  515198
  515227
  528353
  550436
  550662
  560384
  589579
  607167
  622376
  624464
  624851
  631901
  663919
  667858
  676525
  678726
  678802
  682511
  693624
  694540
  700662
  701488
  709591
  709639
  712804
  712830
  715097
  716069
  716161
  722659
  722676
  732422
  732426
  732457
  735480
  735516
  735814
  736403
  741445
  741484
  741639
  743034
  743039
  743123
  743147
  747832
  747852
  747858
  747861
  747875
  748214
  754895
  755780
  759572
  759596
  759642
  766020
  770202
  773578
  774155
  776732
  776878
  778602
  781987
  781992
  782399
  789228
  789233
  789270
  789806
  790954
  795077
  800249
  800881
  807938
  812132
  812148
  812150
  814722
  817404
  819963
  825258
  827117
  827204
]
11.97 ms
(6.66%)
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
  807938
  398805
  550436
  528353
  381811
  358200
  505524
  446376
  736403
  73926
  295616
  503926
  515198
  722659
  663919
  700662
  709591
  622376
  624851
  789233
  789270
  812150
  741484
  735480
  774155
  393747
  295700
  388482
  393783
  402588
  825258
  693624
  694540
  631901
  827204
  560384
  678726
  701488
  722676
  715097
  776732
  743147
  800881
  812148
  747852
  741639
  743039
  781987
  393734
  515118
  667858
  716069
  743123
  747858
  741445
  747875
  754895
  747861
  755780
  759596
  732426
  396734
  38313
  515227
  770202
  386297
  382979
  403045
  382378
  607167
  484126
  550662
  163368
  390387
  827117
  488311
  676525
  678802
  776878
  800249
  781992
  748214
  735814
  709639
  778602
  403049
  382884
  69969
  814722
  819963
  515110
  682511
  712830
  624464
  589579
  790954
  743034
  782399
  789806
  747832
  766020
  732422
  732457
  735516
  759642
  759572
  773578
  812132
  233346
  308583
  388848
  386103
  396165
  27777
  817404
  712804
  789228
  795077
  716161
  335196
]
2.67 ms
(1.48%)
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
  27777
  38313
  69969
  73926
  163368
  233346
  295616
  295700
  308583
  335196
  358200
  381811
  382378
  382884
  382979
  386103
  386297
  388482
  388848
  390387
  393734
  393747
  393783
  396165
  396734
  398805
  402588
  403045
  403049
  446376
  484126
  488311
  503926
  505524
  515110
  515118
  515198
  515227
  528353
  550436
  550662
  560384
  589579
  607167
  622376
  624464
  624851
  631901
  663919
  667858
  676525
  678726
  678802
  682511
  693624
  694540
  700662
  701488
  709591
  709639
  712804
  712830
  715097
  716069
  716161
  722659
  722676
  732422
  732426
  732457
  735480
  735516
  735814
  736403
  741445
  741484
  741639
  743034
  743039
  743123
  743147
  747832
  747852
  747858
  747861
  747875
  748214
  754895
  755780
  759572
  759596
  759642
  766020
  770202
  773578
  774155
  776732
  776878
  778602
  781987
  781992
  782399
  789228
  789233
  789270
  789806
  790954
  795077
  800249
  800881
  807938
  812132
  812148
  812150
  814722
  817404
  819963
  825258
  827117
  827204
]
2.05 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "grandpa секс"
]
2.01 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "grandpa fuck"
]
1.77 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "grandpa секс"
]

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.