Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.60 ms
(83.72%)
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
  202846
  381987
  382066
  382503
  387696
  390022
  398529
  405816
  439520
  452925
  453266
  454684
  455500
  457631
  458549
  466035
  466926
  469113
  469416
  471174
  474159
  474206
  475278
  475639
  478806
  487751
  490744
  499587
  500905
  511314
  513632
  513663
  513670
  513681
  516005
  516006
  519384
  528339
  531047
  531373
  531546
  537548
  537717
  539416
  541102
  544017
  546550
  547689
  549342
  550575
  554454
  557504
  561589
  562574
  570800
  574285
  574358
  577398
  579910
  583822
  586613
  587805
  589610
  592923
  596769
  605973
  612110
  615949
  615990
  621230
  629903
  643373
  646289
  662606
  676248
  677146
  680665
  681085
  692701
  696347
  709398
  710379
  710523
  710769
  714364
  714408
  714461
  720527
  729935
  731137
  733117
  734386
  736047
  738359
  741713
  742569
  744200
  744203
  744229
  744459
  744461
  746106
  746604
  746663
  755354
  760656
  770122
  770252
  777089
  777654
  784147
  789748
  790380
  794701
  797359
  798081
  802739
  809297
  811242
  817130
]
16.01 ms
(10.58%)
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
  744229
  490744
  516005
  539416
  516006
  596769
  439520
  531047
  547689
  549342
  554454
  574285
  615990
  629903
  817130
  537548
  537717
  579910
  570800
  583822
  676248
  709398
  562574
  615949
  784147
  612110
  790380
  458549
  680665
  475639
  455500
  466035
  513663
  544017
  574358
  714461
  710523
  681085
  592923
  643373
  734386
  736047
  469113
  452925
  457631
  528339
  487751
  513681
  586613
  499587
  577398
  405816
  471174
  589610
  478806
  519384
  382503
  646289
  561589
  744200
  546550
  662606
  760656
  729935
  381987
  390022
  474159
  531546
  541102
  714408
  692701
  696347
  720527
  587805
  777654
  794701
  802739
  731137
  797359
  744459
  770122
  733117
  738359
  742569
  755354
  770252
  746106
  714364
  811242
  475278
  500905
  202846
  382066
  387696
  453266
  474206
  469416
  511314
  531373
  550575
  557504
  710769
  677146
  605973
  809297
  746663
  798081
  741713
  744461
  744203
  746604
  621230
  710379
  777089
  789748
  398529
  454684
  466926
  513670
  513632
]
2.28 ms
(1.51%)
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
  202846
  381987
  382066
  382503
  387696
  390022
  398529
  405816
  439520
  452925
  453266
  454684
  455500
  457631
  458549
  466035
  466926
  469113
  469416
  471174
  474159
  474206
  475278
  475639
  478806
  487751
  490744
  499587
  500905
  511314
  513632
  513663
  513670
  513681
  516005
  516006
  519384
  528339
  531047
  531373
  531546
  537548
  537717
  539416
  541102
  544017
  546550
  547689
  549342
  550575
  554454
  557504
  561589
  562574
  570800
  574285
  574358
  577398
  579910
  583822
  586613
  587805
  589610
  592923
  596769
  605973
  612110
  615949
  615990
  621230
  629903
  643373
  646289
  662606
  676248
  677146
  680665
  681085
  692701
  696347
  709398
  710379
  710523
  710769
  714364
  714408
  714461
  720527
  729935
  731137
  733117
  734386
  736047
  738359
  741713
  742569
  744200
  744203
  744229
  744459
  744461
  746106
  746604
  746663
  755354
  760656
  770122
  770252
  777089
  777654
  784147
  789748
  790380
  794701
  797359
  798081
  802739
  809297
  811242
  817130
]
1.74 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "зрелые женщины эротик…"
]
1.62 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "зрелая женщин эротик"
]
1.51 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.45 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.