Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.95 ms
(83.21%)
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
  20617
  21323
  38857
  324568
  326944
  379377
  384433
  388642
  401816
  405727
  407156
  407522
  408988
  411829
  411880
  415988
  416297
  420135
  420202
  428450
  432687
  439174
  445596
  457396
  458844
  467639
  467955
  469366
  474465
  478032
  478427
  480365
  484363
  492646
  495121
  495666
  496112
  499485
  500674
  510590
  512184
  512210
  512212
  515734
  516430
  519291
  519437
  531554
  533499
  535617
  541598
  542565
  545484
  546219
  550642
  550776
  550991
  551086
  551969
  551994
  552042
  552053
  552897
  552913
  554432
  554766
  554790
  554866
  556363
  557494
  557514
  557537
  557823
  558429
  559852
  559855
  559897
  562900
  563310
  565982
  565993
  565998
  566015
  566605
  567321
  575329
  579347
  579721
  580266
  583280
  590966
  592422
  599820
  600539
  601081
  606674
  619199
  621035
  622266
  622972
  623513
  623554
  623599
  636658
  670526
  697354
  706373
  712154
  717298
  767029
  768164
  774773
  776911
  810813
  813226
  815674
  818148
  819082
  823636
  828866
]
16.06 ms
(10.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
  717298
  408988
  469366
  557494
  411829
  379377
  420135
  324568
  512184
  767029
  484363
  458844
  516430
  499485
  551969
  550776
  552897
  559855
  583280
  621035
  474465
  557514
  415988
  407522
  457396
  495121
  565982
  445596
  510590
  388642
  407156
  420202
  416297
  38857
  563310
  819082
  566015
  554432
  541598
  818148
  828866
  535617
  405727
  492646
  552042
  712154
  552913
  622266
  601081
  823636
  774773
  623554
  557537
  432687
  579721
  810813
  515734
  590966
  556363
  559852
  565993
  566605
  768164
  478427
  554866
  542565
  519437
  428450
  551086
  575329
  533499
  496112
  326944
  554790
  21323
  411880
  439174
  495666
  551994
  580266
  558429
  579347
  546219
  670526
  706373
  545484
  557823
  599820
  600539
  623599
  636658
  776911
  401816
  512210
  519291
  384433
  552053
  559897
  554766
  562900
  550642
  565998
  20617
  512212
  478032
  567321
  606674
  619199
  623513
  467955
  480365
  500674
  815674
  697354
  813226
  467639
  592422
  531554
  550991
  622972
]
3.30 ms
(2.11%)
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
  20617
  21323
  38857
  324568
  326944
  379377
  384433
  388642
  401816
  405727
  407156
  407522
  408988
  411829
  411880
  415988
  416297
  420135
  420202
  428450
  432687
  439174
  445596
  457396
  458844
  467639
  467955
  469366
  474465
  478032
  478427
  480365
  484363
  492646
  495121
  495666
  496112
  499485
  500674
  510590
  512184
  512210
  512212
  515734
  516430
  519291
  519437
  531554
  533499
  535617
  541598
  542565
  545484
  546219
  550642
  550776
  550991
  551086
  551969
  551994
  552042
  552053
  552897
  552913
  554432
  554766
  554790
  554866
  556363
  557494
  557514
  557537
  557823
  558429
  559852
  559855
  559897
  562900
  563310
  565982
  565993
  565998
  566015
  566605
  567321
  575329
  579347
  579721
  580266
  583280
  590966
  592422
  599820
  600539
  601081
  606674
  619199
  621035
  622266
  622972
  623513
  623554
  623599
  636658
  670526
  697354
  706373
  712154
  717298
  767029
  768164
  774773
  776911
  810813
  813226
  815674
  818148
  819082
  823636
  828866
]
1.90 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mother asian"
]
1.75 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин азиатк"
]
1.50 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.