Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
117.82 ms
(83.02%)
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
  391861
  392021
  423867
  426893
  432379
  433054
  433435
  436423
  436791
  438016
  438979
  439543
  439899
  440696
  451420
  457837
  458909
  461984
  462023
  462737
  467878
  474931
  475851
  480876
  480912
  482258
  485646
  486368
  489047
  493448
  494242
  496196
  498303
  510979
  511596
  512596
  513344
  513670
  513939
  514483
  518883
  521639
  522956
  524562
  535332
  536217
  551896
  552338
  565880
  569935
  579426
  581514
  590538
  592528
  594339
  594421
  595447
  606571
  610078
  612483
  616798
  616936
  616989
  619874
  619947
  622878
  626364
  626609
  631625
  643250
  657514
  661062
  671195
  672807
  674618
  678823
  685843
  689145
  690648
  695543
  696148
  699892
  701531
  702301
  703969
  704066
  704072
  705019
  713240
  719544
  722216
  735974
  736702
  741699
  746748
  756371
  760901
  764711
  767722
  778781
  780328
  783391
  785225
  787373
  789251
  789930
  790514
  791283
  795062
  797709
  798265
  800954
  806398
  810532
  812447
  813138
  813369
  813582
  813595
  813921
]
14.54 ms
(10.24%)
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
  480912
  451420
  498303
  496196
  594421
  606571
  467878
  439543
  622878
  552338
  480876
  433054
  522956
  494242
  426893
  514483
  565880
  671195
  689145
  695543
  701531
  705019
  672807
  690648
  616798
  610078
  616936
  612483
  619947
  592528
  438016
  813595
  813582
  813921
  512596
  536217
  657514
  678823
  696148
  699892
  643250
  785225
  789251
  790514
  806398
  810532
  813138
  813369
  778781
  791283
  798265
  800954
  812447
  787373
  789930
  795062
  736702
  756371
  764711
  767722
  760901
  735974
  746748
  783391
  797709
  462023
  392021
  513670
  489047
  513939
  581514
  440696
  474931
  485646
  579426
  551896
  674618
  619874
  433435
  436791
  438979
  439899
  432379
  461984
  462737
  475851
  482258
  458909
  518883
  521639
  510979
  486368
  524562
  535332
  713240
  661062
  685843
  594339
  595447
  626609
  702301
  513344
  436423
  741699
  423867
  457837
  493448
  511596
  626364
  391861
  569935
  703969
  704072
  719544
  704066
  722216
  616989
  631625
  590538
  780328
]
2.71 ms
(1.91%)
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
  391861
  392021
  423867
  426893
  432379
  433054
  433435
  436423
  436791
  438016
  438979
  439543
  439899
  440696
  451420
  457837
  458909
  461984
  462023
  462737
  467878
  474931
  475851
  480876
  480912
  482258
  485646
  486368
  489047
  493448
  494242
  496196
  498303
  510979
  511596
  512596
  513344
  513670
  513939
  514483
  518883
  521639
  522956
  524562
  535332
  536217
  551896
  552338
  565880
  569935
  579426
  581514
  590538
  592528
  594339
  594421
  595447
  606571
  610078
  612483
  616798
  616936
  616989
  619874
  619947
  622878
  626364
  626609
  631625
  643250
  657514
  661062
  671195
  672807
  674618
  678823
  685843
  689145
  690648
  695543
  696148
  699892
  701531
  702301
  703969
  704066
  704072
  705019
  713240
  719544
  722216
  735974
  736702
  741699
  746748
  756371
  760901
  764711
  767722
  778781
  780328
  783391
  785225
  787373
  789251
  789930
  790514
  791283
  795062
  797709
  798265
  800954
  806398
  810532
  812447
  813138
  813369
  813582
  813595
  813921
]
2.00 ms
(1.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "оргазмы русское домашние"
]
1.68 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "оргазм русск домашн любительск"
]
1.63 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "оргазм русск домашн любительск"
]
1.55 ms
(1.09%)
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.