Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.33 ms
(82.05%)
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
  12708
  34409
  43207
  91254
  102364
  131776
  133698
  149622
  150124
  183126
  260068
  268633
  305548
  305824
  324568
  351291
  381837
  381939
  382013
  382180
  382215
  382944
  383053
  383137
  383477
  383952
  384258
  385368
  385751
  385781
  386483
  386563
  387374
  388195
  388222
  392937
  397199
  398554
  400406
  400593
  400595
  403501
  404018
  411185
  412732
  413463
  413706
  413805
  418052
  426705
  427222
  427488
  430460
  432200
  432445
  442050
  443413
  443424
  444474
  448931
  454114
  456945
  469358
  471576
  477144
  485402
  494588
  532827
  543589
  550804
  575680
  582058
  587845
  591869
  601504
  633479
  634476
  634682
  646579
  658128
  665277
  667295
  668516
  669758
  687080
  704999
  707069
  709552
  710197
  712813
  715591
  720542
  723754
  723774
  725220
  733169
  733219
  736351
  737392
  739062
  740632
  744218
  744388
  755704
  759617
  761564
  762300
  764409
  764856
  772078
  775442
  777022
  778056
  788862
  797472
  798131
  799285
  801652
  802684
  803884
]
17.57 ms
(10.65%)
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
  426705
  448931
  456945
  469358
  477144
  454114
  471576
  532827
  494588
  485402
  543589
  646579
  668516
  707069
  720542
  658128
  665277
  667295
  709552
  710197
  669758
  687080
  550804
  575680
  582058
  601504
  633479
  634682
  591869
  634476
  587845
  777022
  775442
  778056
  723774
  737392
  761564
  772078
  797472
  798131
  799285
  725220
  744218
  755704
  759617
  723754
  740632
  744388
  762300
  764409
  733169
  733219
  736351
  739062
  764856
  704999
  712813
  715591
  788862
  801652
  802684
  803884
  400593
  413805
  427222
  427488
  324568
  351291
  386563
  413706
  382180
  387374
  404018
  412732
  432445
  443413
  43207
  133698
  385751
  386483
  385781
  383477
  91254
  383952
  384258
  385368
  382944
  383053
  383137
  102364
  150124
  131776
  149622
  183126
  392937
  268633
  305548
  260068
  305824
  381837
  381939
  382013
  382215
  34409
  12708
  388195
  388222
  397199
  400406
  400595
  398554
  403501
  413463
  418052
  442050
  430460
  444474
  443424
  411185
  432200
]
3.05 ms
(1.85%)
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
  12708
  34409
  43207
  91254
  102364
  131776
  133698
  149622
  150124
  183126
  260068
  268633
  305548
  305824
  324568
  351291
  381837
  381939
  382013
  382180
  382215
  382944
  383053
  383137
  383477
  383952
  384258
  385368
  385751
  385781
  386483
  386563
  387374
  388195
  388222
  392937
  397199
  398554
  400406
  400593
  400595
  403501
  404018
  411185
  412732
  413463
  413706
  413805
  418052
  426705
  427222
  427488
  430460
  432200
  432445
  442050
  443413
  443424
  444474
  448931
  454114
  456945
  469358
  471576
  477144
  485402
  494588
  532827
  543589
  550804
  575680
  582058
  587845
  591869
  601504
  633479
  634476
  634682
  646579
  658128
  665277
  667295
  668516
  669758
  687080
  704999
  707069
  709552
  710197
  712813
  715591
  720542
  723754
  723774
  725220
  733169
  733219
  736351
  737392
  739062
  740632
  744218
  744388
  755704
  759617
  761564
  762300
  764409
  764856
  772078
  775442
  777022
  778056
  788862
  797472
  798131
  799285
  801652
  802684
  803884
]
3.03 ms
(1.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "толстая"
]
2.38 ms
(1.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "толстой"
]
1.82 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "толстая"
]
1.76 ms
(1.07%)
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.