Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
143.16 ms
(85.43%)
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
  314552
  388392
  396353
  428259
  437486
  440902
  444657
  446098
  450338
  452971
  469261
  487188
  493665
  495364
  531821
  533995
  543127
  543846
  554956
  555082
  558342
  562228
  564103
  564557
  568477
  588433
  590029
  594267
  597165
  598805
  601550
  604138
  606251
  609875
  619442
  621174
  629092
  633611
  642232
  642689
  652274
  652954
  654097
  656597
  665392
  680472
  682924
  683303
  692816
  694142
  694917
  700925
  702046
  704178
  710368
  712481
  713098
  715121
  716121
  717921
  718934
  726297
  727653
  728260
  733846
  733887
  735028
  736592
  737553
  742185
  743436
  744450
  745341
  746555
  749669
  750275
  750307
  750710
  753638
  755341
  755937
  758096
  759914
  761098
  761192
  761594
  766611
  766910
  767050
  771203
  776287
  776524
  777940
  778989
  782429
  782745
  786356
  789532
  789672
  791006
  791809
  792142
  795628
  796106
  796162
  796652
  800247
  800531
  800554
  800721
  802732
  804638
  806331
  807510
  809656
  811663
  813539
  813627
  814417
  815116
]
14.74 ms
(8.79%)
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
  656597
  710368
  717921
  554956
  606251
  594267
  588433
  776524
  778989
  796162
  802732
  782429
  789532
  792142
  727653
  737553
  750710
  755937
  759914
  761594
  811663
  813539
  733887
  743436
  750307
  755341
  766910
  746555
  753638
  767050
  728260
  745341
  749669
  766611
  609875
  715121
  789672
  791006
  809656
  388392
  531821
  562228
  702046
  712481
  683303
  713098
  642232
  795628
  806331
  744450
  735028
  314552
  452971
  396353
  558342
  800554
  800531
  642689
  437486
  814417
  568477
  692816
  680472
  704178
  804638
  733846
  791809
  807510
  450338
  495364
  813627
  815116
  533995
  564103
  652954
  654097
  718934
  652274
  700925
  629092
  619442
  590029
  601550
  776287
  786356
  777940
  782745
  796652
  800721
  761098
  736592
  771203
  726297
  750275
  758096
  761192
  800247
  428259
  440902
  444657
  446098
  487188
  469261
  493665
  555082
  543846
  543127
  665392
  682924
  694917
  694142
  716121
  564557
  598805
  633611
  597165
  604138
  621174
  796106
  742185
]
2.70 ms
(1.61%)
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
  314552
  388392
  396353
  428259
  437486
  440902
  444657
  446098
  450338
  452971
  469261
  487188
  493665
  495364
  531821
  533995
  543127
  543846
  554956
  555082
  558342
  562228
  564103
  564557
  568477
  588433
  590029
  594267
  597165
  598805
  601550
  604138
  606251
  609875
  619442
  621174
  629092
  633611
  642232
  642689
  652274
  652954
  654097
  656597
  665392
  680472
  682924
  683303
  692816
  694142
  694917
  700925
  702046
  704178
  710368
  712481
  713098
  715121
  716121
  717921
  718934
  726297
  727653
  728260
  733846
  733887
  735028
  736592
  737553
  742185
  743436
  744450
  745341
  746555
  749669
  750275
  750307
  750710
  753638
  755341
  755937
  758096
  759914
  761098
  761192
  761594
  766611
  766910
  767050
  771203
  776287
  776524
  777940
  778989
  782429
  782745
  786356
  789532
  789672
  791006
  791809
  792142
  795628
  796106
  796162
  796652
  800247
  800531
  800554
  800721
  802732
  804638
  806331
  807510
  809656
  811663
  813539
  813627
  814417
  815116
]
2.06 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "горячий анальный секс…"
]
1.75 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "горяч анал"
]
1.62 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "горяч анал"
]
1.55 ms
(0.93%)
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.