Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.50 ms
(83.32%)
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
  12132
  104130
  188501
  382246
  386759
  387848
  390264
  392404
  396051
  400642
  401307
  403575
  404371
  405070
  406125
  408085
  409934
  410686
  415803
  417336
  420381
  420438
  420637
  420761
  421648
  426316
  427555
  428229
  434724
  440838
  440996
  443811
  443883
  445275
  445943
  447109
  447516
  448375
  448781
  449847
  452183
  452659
  452909
  452998
  453176
  454270
  454303
  457449
  461066
  462169
  463374
  465790
  466175
  467003
  468362
  469200
  469352
  469470
  469537
  469567
  469748
  471313
  472399
  472495
  473511
  474597
  476934
  477734
  478540
  478652
  478784
  479860
  480413
  481047
  482529
  483568
  483618
  484752
  485306
  486904
  488421
  489756
  491969
  493033
  493795
  497332
  497426
  497645
  497919
  498725
  499503
  500289
  502242
  505257
  505267
  505606
  513705
  513729
  516666
  517343
  519180
  519372
  519586
  521291
  524605
  525748
  526450
  527871
  527888
  552535
  555138
  557197
  561694
  564397
  565158
  566052
  573728
  588077
  595392
  596630
]
17.16 ms
(10.63%)
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
  493795
  485306
  478784
  428229
  445275
  513705
  400642
  406125
  404371
  420381
  426316
  472399
  595392
  382246
  474597
  477734
  454303
  466175
  499503
  513729
  521291
  491969
  420438
  480413
  493033
  497332
  486904
  12132
  445943
  564397
  387848
  410686
  462169
  489756
  573728
  390264
  481047
  452998
  448781
  524605
  443883
  452659
  461066
  401307
  452909
  457449
  440996
  488421
  527871
  519180
  104130
  483568
  557197
  427555
  469470
  471313
  469352
  482529
  555138
  596630
  469200
  476934
  403575
  420637
  472495
  443811
  454270
  517343
  497426
  497919
  502242
  386759
  408085
  440838
  447516
  447109
  465790
  452183
  467003
  448375
  417336
  420761
  468362
  478652
  483618
  505267
  500289
  525748
  478540
  498725
  188501
  396051
  434724
  463374
  469537
  473511
  552535
  565158
  561694
  588077
  479860
  421648
  392404
  405070
  469567
  415803
  449847
  505606
  497645
  519372
  519586
  484752
  505257
  526450
  527888
  409934
  453176
  516666
  566052
  469748
]
2.48 ms
(1.54%)
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
  12132
  104130
  188501
  382246
  386759
  387848
  390264
  392404
  396051
  400642
  401307
  403575
  404371
  405070
  406125
  408085
  409934
  410686
  415803
  417336
  420381
  420438
  420637
  420761
  421648
  426316
  427555
  428229
  434724
  440838
  440996
  443811
  443883
  445275
  445943
  447109
  447516
  448375
  448781
  449847
  452183
  452659
  452909
  452998
  453176
  454270
  454303
  457449
  461066
  462169
  463374
  465790
  466175
  467003
  468362
  469200
  469352
  469470
  469537
  469567
  469748
  471313
  472399
  472495
  473511
  474597
  476934
  477734
  478540
  478652
  478784
  479860
  480413
  481047
  482529
  483568
  483618
  484752
  485306
  486904
  488421
  489756
  491969
  493033
  493795
  497332
  497426
  497645
  497919
  498725
  499503
  500289
  502242
  505257
  505267
  505606
  513705
  513729
  516666
  517343
  519180
  519372
  519586
  521291
  524605
  525748
  526450
  527871
  527888
  552535
  555138
  557197
  561694
  564397
  565158
  566052
  573728
  588077
  595392
  596630
]
2.23 ms
(1.38%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мужскойрод анал"
]
1.72 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "чувака в очко"
]
1.61 ms
(1.00%)
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.