Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.18 ms
(83.98%)
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
  248084
  265677
  285404
  382107
  383299
  384974
  397516
  401581
  406852
  425904
  446329
  472937
  473107
  477883
  529899
  530323
  532050
  532067
  532086
  533022
  533204
  533211
  537562
  537691
  537721
  537756
  539597
  540446
  544332
  544337
  547305
  547308
  547310
  547314
  547328
  549273
  549307
  549328
  549348
  549365
  549371
  549377
  549385
  549386
  549389
  549392
  549911
  549933
  549938
  549957
  549961
  549965
  549971
  550330
  551706
  554068
  557521
  559128
  570772
  570774
  570827
  570828
  570952
  572564
  572576
  572578
  572585
  572611
  572630
  572670
  572765
  574176
  574227
  579918
  579938
  579950
  581427
  591165
  603279
  614294
  629901
  629902
  629936
  638560
  643084
  653258
  669481
  678570
  690831
  691521
  692198
  692222
  692231
  692803
  693059
  694541
  695196
  699764
  715438
  730221
  737792
  757918
  765818
  781122
  781155
  812419
]
12.71 ms
(8.74%)
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
  629902
  549385
  570774
  384974
  406852
  533022
  547310
  549911
  572578
  549389
  544332
  692222
  692803
  669481
  678570
  549386
  579918
  638560
  730221
  248084
  549938
  629901
  540446
  532050
  547305
  549965
  570828
  579950
  544337
  549273
  694541
  699764
  547308
  549957
  572611
  574227
  781122
  812419
  737792
  781155
  382107
  401581
  537721
  533211
  549961
  533204
  532086
  530323
  547314
  549348
  572564
  549307
  570772
  653258
  692231
  603279
  383299
  537562
  554068
  539597
  537756
  549328
  549971
  570827
  551706
  715438
  549392
  572576
  572585
  614294
  285404
  473107
  397516
  549365
  572670
  572630
  629936
  765818
  757918
  446329
  550330
  579938
  265677
  691521
  477883
  529899
  532067
  537691
  549377
  559128
  547328
  574176
  549933
  695196
  572765
  581427
  591165
  643084
  690831
  557521
  570952
  693059
  692198
  425904
  549371
  472937
]
3.12 ms
(2.15%)
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
  248084
  265677
  285404
  382107
  383299
  384974
  397516
  401581
  406852
  425904
  446329
  472937
  473107
  477883
  529899
  530323
  532050
  532067
  532086
  533022
  533204
  533211
  537562
  537691
  537721
  537756
  539597
  540446
  544332
  544337
  547305
  547308
  547310
  547314
  547328
  549273
  549307
  549328
  549348
  549365
  549371
  549377
  549385
  549386
  549389
  549392
  549911
  549933
  549938
  549957
  549961
  549965
  549971
  550330
  551706
  554068
  557521
  559128
  570772
  570774
  570827
  570828
  570952
  572564
  572576
  572578
  572585
  572611
  572630
  572670
  572765
  574176
  574227
  579918
  579938
  579950
  581427
  591165
  603279
  614294
  629901
  629902
  629936
  638560
  643084
  653258
  669481
  678570
  690831
  691521
  692198
  692222
  692231
  692803
  693059
  694541
  695196
  699764
  715438
  730221
  737792
  757918
  765818
  781122
  781155
  812419
]
2.31 ms
(1.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "scene erotic"
]
1.94 ms
(1.33%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "scene эротик"
]
1.46 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "scene эротик"
]

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.