Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
112.49 ms
(83.47%)
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
  126458
  282465
  397131
  443417
  463321
  516702
  526480
  527506
  533010
  537568
  537767
  544457
  545734
  546740
  549290
  549991
  562928
  572946
  574251
  587975
  594596
  595599
  602415
  611309
  613949
  618782
  623348
  624539
  628441
  628767
  628887
  629398
  637647
  649267
  652053
  652554
  653572
  655101
  655314
  656046
  656739
  657034
  657270
  658292
  658367
  658413
  658820
  659608
  660761
  670175
  676482
  676503
  676520
  676996
  677109
  677213
  677689
  678011
  678218
  678802
  685471
  686040
  696397
  700660
  700681
  705352
  710391
  717848
  720573
  728431
  729720
  730575
  730851
  732442
  734287
  735773
  735999
  736947
  737100
  737245
  737370
  739381
  739747
  740059
  740500
  741377
  741976
  743265
  743708
  744037
  744552
  746279
  747577
  749534
  758651
  760356
  761076
  766314
  767302
  767309
  771476
  778519
  779225
  780444
  780527
  782133
  784321
  786069
  793518
  794865
  794918
  797408
  797421
  809730
  809980
  810838
  811544
  812010
  827642
  827660
]
11.67 ms
(8.66%)
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
  549290
  574251
  544457
  657270
  676520
  677213
  720573
  658367
  676482
  678011
  696397
  546740
  549991
  594596
  623348
  811544
  778519
  779225
  794865
  797421
  739747
  760356
  812010
  730851
  741976
  749534
  758651
  730575
  734287
  737245
  735999
  780444
  780527
  809730
  397131
  443417
  827642
  463321
  537767
  516702
  677109
  678802
  685471
  700681
  710391
  628441
  637647
  618782
  810838
  740059
  740500
  761076
  728431
  732442
  602415
  700660
  717848
  782133
  126458
  526480
  533010
  629398
  282465
  827660
  537568
  527506
  562928
  545734
  572946
  655314
  676503
  676996
  649267
  652053
  657034
  659608
  677689
  686040
  652554
  653572
  655101
  656046
  656739
  658292
  658413
  658820
  660761
  670175
  678218
  705352
  595599
  611309
  613949
  628887
  628767
  587975
  784321
  797408
  786069
  793518
  809980
  729720
  737370
  741377
  746279
  767302
  794918
  744552
  767309
  771476
  735773
  743265
  737100
  739381
  743708
  747577
  736947
  744037
  766314
  624539
]
2.70 ms
(2.00%)
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
  126458
  282465
  397131
  443417
  463321
  516702
  526480
  527506
  533010
  537568
  537767
  544457
  545734
  546740
  549290
  549991
  562928
  572946
  574251
  587975
  594596
  595599
  602415
  611309
  613949
  618782
  623348
  624539
  628441
  628767
  628887
  629398
  637647
  649267
  652053
  652554
  653572
  655101
  655314
  656046
  656739
  657034
  657270
  658292
  658367
  658413
  658820
  659608
  660761
  670175
  676482
  676503
  676520
  676996
  677109
  677213
  677689
  678011
  678218
  678802
  685471
  686040
  696397
  700660
  700681
  705352
  710391
  717848
  720573
  728431
  729720
  730575
  730851
  732442
  734287
  735773
  735999
  736947
  737100
  737245
  737370
  739381
  739747
  740059
  740500
  741377
  741976
  743265
  743708
  744037
  744552
  746279
  747577
  749534
  758651
  760356
  761076
  766314
  767302
  767309
  771476
  778519
  779225
  780444
  780527
  782133
  784321
  786069
  793518
  794865
  794918
  797408
  797421
  809730
  809980
  810838
  811544
  812010
  827642
  827660
]
2.34 ms
(1.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "смотрет порно 18"
]
2.10 ms
(1.56%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(1.33%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "смотрет порн 18"
]
1.67 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "смотрет порн 18"
]

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.