Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
191.59 ms
(87.23%)
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
  382816
  429614
  443366
  464775
  493007
  493561
  497840
  509724
  523515
  526425
  537007
  538439
  539350
  540193
  544622
  547143
  558729
  564669
  567312
  577112
  580462
  590656
  591796
  593697
  597931
  600710
  601177
  604512
  609536
  612152
  613154
  613277
  613440
  615514
  616887
  616926
  624304
  625065
  632395
  635787
  636873
  636981
  641490
  642917
  642949
  645794
  649034
  650572
  652494
  653661
  656816
  666421
  669692
  672800
  672867
  673872
  688805
  693366
  697456
  705306
  707297
  708170
  708915
  709528
  710949
  711620
  713051
  713710
  713724
  720024
  724003
  724795
  725275
  726055
  727309
  731268
  732728
  735640
  737265
  740298
  744361
  746877
  747003
  747793
  753203
  754638
  761239
  765920
  765930
  767249
  768228
  778074
  782436
  784658
  786885
  787985
  789257
  789498
  790261
  791287
  791422
  792821
  793302
  794740
  796016
  796335
  796477
  796597
  801510
  804911
  805641
  809273
  809365
  817603
  818112
  818847
  819180
  820371
  823653
  826646
]
15.17 ms
(6.91%)
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
  801510
  805641
  791287
  793302
  804911
  731268
  761239
  765930
  809365
  817603
  669692
  708170
  782436
  753203
  747793
  724003
  744361
  740298
  754638
  796597
  540193
  564669
  613277
  635787
  523515
  497840
  645794
  653661
  693366
  697456
  711620
  713710
  713724
  650572
  652494
  672867
  705306
  707297
  709528
  673872
  688805
  615514
  591796
  593697
  600710
  613154
  597931
  601177
  616887
  636873
  636981
  590656
  632395
  641490
  642917
  642949
  786885
  724795
  727309
  604512
  612152
  613440
  493007
  649034
  624304
  737265
  537007
  547143
  580462
  708915
  429614
  818112
  823653
  493561
  539350
  544622
  567312
  558729
  796016
  796335
  746877
  790261
  726055
  732728
  747003
  767249
  710949
  382816
  809273
  616926
  787985
  826646
  820371
  509724
  526425
  720024
  794740
  784658
  768228
  791422
  443366
  464775
  538439
  656816
  796477
  789257
  789498
  725275
  765920
  735640
  778074
  666421
  672800
  713051
  609536
  625065
  819180
  577112
  818847
  792821
]
4.58 ms
(2.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur condom sex"
]
3.52 ms
(1.60%)
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
  382816
  429614
  443366
  464775
  493007
  493561
  497840
  509724
  523515
  526425
  537007
  538439
  539350
  540193
  544622
  547143
  558729
  564669
  567312
  577112
  580462
  590656
  591796
  593697
  597931
  600710
  601177
  604512
  609536
  612152
  613154
  613277
  613440
  615514
  616887
  616926
  624304
  625065
  632395
  635787
  636873
  636981
  641490
  642917
  642949
  645794
  649034
  650572
  652494
  653661
  656816
  666421
  669692
  672800
  672867
  673872
  688805
  693366
  697456
  705306
  707297
  708170
  708915
  709528
  710949
  711620
  713051
  713710
  713724
  720024
  724003
  724795
  725275
  726055
  727309
  731268
  732728
  735640
  737265
  740298
  744361
  746877
  747003
  747793
  753203
  754638
  761239
  765920
  765930
  767249
  768228
  778074
  782436
  784658
  786885
  787985
  789257
  789498
  790261
  791287
  791422
  792821
  793302
  794740
  796016
  796335
  796477
  796597
  801510
  804911
  805641
  809273
  809365
  817603
  818112
  818847
  819180
  820371
  823653
  826646
]
1.65 ms
(0.75%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск condom секс"
]
1.62 ms
(0.74%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(0.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск condom секс"
]

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.