Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.72 ms
(37.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sexmachine big ass"
]
206.35 ms
(36.50%)
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
  428235
  428305
  428553
  432270
  432294
  434080
  439417
  446107
  448082
  448551
  448914
  449024
  452822
  452824
  455902
  464844
  467112
  468233
  468495
  469096
  469636
  472257
  475415
  475422
  475426
  476657
  480477
  481226
  486243
  491126
  496240
  499919
  510956
  511869
  513221
  514086
  515265
  515272
  515423
  516640
  518183
  518185
  518187
  518505
  518891
  522151
  522163
  522182
  526164
  533841
  569756
  576125
  577122
  582396
  592593
  593486
  597878
  603391
  604721
  606549
  615022
  630406
  631301
  631321
  631331
  642042
  642065
  642835
  651632
  651863
  660417
  662856
  663158
  669589
  670956
  670970
  681804
  692654
  700682
  700693
  713156
  716001
  728363
  730338
  738480
  738487
  742421
  750623
  766294
  766830
  766939
  770169
  772235
  773846
  774842
  774874
  776997
  777001
  777762
  777921
  779769
  780065
  780067
  782419
  782894
  783214
  783319
  787095
  793962
  796640
  800502
  800508
  800543
  804159
  804465
  806413
  807142
  808115
  811325
  815270
]
123.00 ms
(21.76%)
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
  428235
  428305
  428553
  432270
  432294
  434080
  439417
  446107
  448082
  448551
  448914
  449024
  452822
  452824
  455902
  464844
  467112
  468233
  468495
  469096
  469636
  472257
  475415
  475422
  475426
  476657
  480477
  481226
  486243
  491126
  496240
  499919
  510956
  511869
  513221
  514086
  515265
  515272
  515423
  516640
  518183
  518185
  518187
  518505
  518891
  522151
  522163
  522182
  526164
  533841
  569756
  576125
  577122
  582396
  592593
  593486
  597878
  603391
  604721
  606549
  615022
  630406
  631301
  631321
  631331
  642042
  642065
  642835
  651632
  651863
  660417
  662856
  663158
  669589
  670956
  670970
  681804
  692654
  700682
  700693
  713156
  716001
  728363
  730338
  738480
  738487
  742421
  750623
  766294
  766830
  766939
  770169
  772235
  773846
  774842
  774874
  776997
  777001
  777762
  777921
  779769
  780065
  780067
  782419
  782894
  783214
  783319
  787095
  793962
  796640
  800502
  800508
  800543
  804159
  804465
  806413
  807142
  808115
  811325
  815270
]
18.54 ms
(3.28%)
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
  486243
  515423
  522163
  533841
  651863
  662856
  716001
  603391
  631331
  774842
  787095
  783214
  800508
  738487
  770169
  782419
  782894
  783319
  800543
  766939
  742421
  750623
  766294
  631301
  804465
  439417
  481226
  514086
  516640
  446107
  452822
  469636
  692654
  631321
  779769
  738480
  777001
  455902
  475426
  452824
  468233
  660417
  713156
  642042
  592593
  811325
  800502
  730338
  728363
  766830
  518505
  515272
  448082
  518185
  428553
  432270
  467112
  518187
  576125
  642065
  491126
  496240
  511869
  510956
  569756
  670956
  670970
  773846
  448914
  468495
  428305
  480477
  472257
  522182
  475415
  663158
  700693
  669589
  681804
  700682
  807142
  772235
  793962
  806413
  808115
  630406
  774874
  776997
  777921
  780067
  804159
  476657
  522151
  428235
  449024
  469096
  615022
  593486
  796640
  518183
  597878
  434080
  432294
  815270
  448551
  464844
  475422
  518891
  513221
  526164
  499919
  515265
  582396
  577122
  651632
  604721
  606549
  642835
  777762
  780065
]
2.06 ms
(0.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сексмашин большая большие жоп"
]
1.86 ms
(0.33%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сексмашин большая большие жоп"
]
1.80 ms
(0.32%)
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.