Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.77 ms
(82.07%)
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
  88664
  182036
  182135
  357457
  382410
  398073
  398500
  401810
  413404
  414087
  439417
  449017
  452830
  456699
  457815
  472257
  475415
  475417
  477348
  477503
  478523
  478611
  479722
  479838
  480471
  480472
  483522
  485283
  486243
  495208
  495211
  496842
  499885
  499922
  499927
  499930
  514270
  515259
  515423
  522148
  522163
  522173
  522182
  526902
  533841
  541858
  542163
  544799
  547476
  549538
  549654
  553130
  554907
  560932
  564567
  566544
  570911
  570917
  585783
  603391
  631301
  631331
  651863
  660578
  662856
  663158
  669589
  681804
  692688
  697834
  697839
  700693
  713501
  713507
  716001
  720582
  734868
  738476
  738481
  738487
  738490
  740929
  741157
  742421
  750623
  752603
  752687
  760471
  762561
  766294
  766939
  770169
  774842
  779718
  780019
  780038
  782419
  782855
  782894
  783212
  783214
  783319
  785267
  787095
  790506
  796993
  800508
  800543
  800792
  803751
  804465
  805643
  806466
  806861
  807000
  807581
  807660
  811705
  813219
  819361
]
17.91 ms
(11.78%)
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
  796993
  803751
  807581
  813219
  88664
  182036
  382410
  478611
  182135
  357457
  401810
  413404
  819361
  456699
  449017
  457815
  479722
  485283
  486243
  515423
  522163
  522148
  533841
  495208
  495211
  515259
  542163
  554907
  570917
  651863
  662856
  716001
  697834
  713501
  713507
  553130
  564567
  585783
  603391
  631331
  774842
  779718
  782855
  787095
  806466
  811705
  780019
  780038
  783214
  785267
  800508
  807000
  738487
  752603
  752687
  762561
  770169
  782419
  782894
  783212
  783319
  790506
  800543
  807660
  766939
  734868
  738476
  738481
  738490
  760471
  740929
  741157
  742421
  750623
  766294
  631301
  800792
  804465
  805643
  806861
  477503
  414087
  475417
  398073
  439417
  478523
  398500
  477348
  479838
  480471
  452830
  483522
  472257
  496842
  499927
  499930
  514270
  522173
  522182
  499922
  499885
  526902
  475415
  480472
  547476
  549654
  560932
  566544
  570911
  541858
  544799
  549538
  663158
  697839
  720582
  660578
  692688
  700693
  669589
  681804
]
2.56 ms
(1.68%)
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
  88664
  182036
  182135
  357457
  382410
  398073
  398500
  401810
  413404
  414087
  439417
  449017
  452830
  456699
  457815
  472257
  475415
  475417
  477348
  477503
  478523
  478611
  479722
  479838
  480471
  480472
  483522
  485283
  486243
  495208
  495211
  496842
  499885
  499922
  499927
  499930
  514270
  515259
  515423
  522148
  522163
  522173
  522182
  526902
  533841
  541858
  542163
  544799
  547476
  549538
  549654
  553130
  554907
  560932
  564567
  566544
  570911
  570917
  585783
  603391
  631301
  631331
  651863
  660578
  662856
  663158
  669589
  681804
  692688
  697834
  697839
  700693
  713501
  713507
  716001
  720582
  734868
  738476
  738481
  738487
  738490
  740929
  741157
  742421
  750623
  752603
  752687
  760471
  762561
  766294
  766939
  770169
  774842
  779718
  780019
  780038
  782419
  782855
  782894
  783212
  783214
  783319
  785267
  787095
  790506
  796993
  800508
  800543
  800792
  803751
  804465
  805643
  806466
  806861
  807000
  807581
  807660
  811705
  813219
  819361
]
1.88 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sexmachine"
]
1.75 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сексмашин"
]
1.66 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сексмашин"
]
1.51 ms
(1.00%)
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.