Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.37 ms
(83.90%)
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
  232940
  382460
  388856
  393391
  395276
  395714
  395846
  395863
  397385
  397921
  406563
  406566
  408240
  409021
  410577
  411841
  415147
  416034
  416346
  428580
  430168
  430695
  433259
  436719
  443199
  443695
  447516
  448955
  449893
  460175
  468369
  469513
  469568
  470232
  471813
  472788
  473148
  478652
  478963
  480397
  484052
  488619
  490419
  491275
  492138
  493218
  498321
  499821
  504061
  512770
  513144
  516226
  518562
  519063
  519094
  519218
  519233
  519573
  524486
  526525
  531262
  532958
  538010
  538970
  542247
  549224
  549846
  563643
  565257
  569146
  576520
  589551
  590194
  598387
  599928
  600314
  604103
  604304
  604519
  604905
  606425
  614347
  632358
  635916
  640677
  642753
  648564
  650011
  671930
  674269
  694135
  702463
  712006
  716897
  718152
  718909
  721715
  732382
  736784
  755429
  759967
  765517
  765554
  765721
  775436
  775818
  777580
  787274
  800052
  802845
  811503
  815456
  815541
  817278
  817832
  817878
  818327
  818358
  825831
  826521
]
18.18 ms
(9.95%)
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
  632358
  702463
  716897
  718152
  802845
  519218
  393391
  516226
  478963
  395846
  447516
  469513
  460175
  674269
  549224
  563643
  604304
  388856
  469568
  448955
  395276
  406566
  473148
  478652
  519233
  491275
  524486
  538010
  382460
  825831
  648564
  671930
  589551
  598387
  614347
  635916
  606425
  777580
  765721
  765517
  755429
  732382
  736784
  765554
  642753
  721715
  232940
  818358
  718909
  650011
  604905
  775818
  410577
  397385
  443199
  436719
  484052
  449893
  499821
  518562
  492138
  604519
  759967
  712006
  411841
  468369
  472788
  416346
  471813
  430695
  498321
  428580
  817832
  817878
  815456
  817278
  818327
  815541
  826521
  513144
  694135
  640677
  600314
  811503
  800052
  787274
  775436
  397921
  565257
  531262
  604103
  590194
  395714
  526525
  504061
  512770
  569146
  576520
  519063
  395863
  408240
  416034
  433259
  430168
  488619
  490419
  532958
  519094
  470232
  542247
  549846
  599928
  409021
  443695
  480397
  406563
  415147
  538970
  519573
  493218
]
3.30 ms
(1.80%)
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
  232940
  382460
  388856
  393391
  395276
  395714
  395846
  395863
  397385
  397921
  406563
  406566
  408240
  409021
  410577
  411841
  415147
  416034
  416346
  428580
  430168
  430695
  433259
  436719
  443199
  443695
  447516
  448955
  449893
  460175
  468369
  469513
  469568
  470232
  471813
  472788
  473148
  478652
  478963
  480397
  484052
  488619
  490419
  491275
  492138
  493218
  498321
  499821
  504061
  512770
  513144
  516226
  518562
  519063
  519094
  519218
  519233
  519573
  524486
  526525
  531262
  532958
  538010
  538970
  542247
  549224
  549846
  563643
  565257
  569146
  576520
  589551
  590194
  598387
  599928
  600314
  604103
  604304
  604519
  604905
  606425
  614347
  632358
  635916
  640677
  642753
  648564
  650011
  671930
  674269
  694135
  702463
  712006
  716897
  718152
  718909
  721715
  732382
  736784
  755429
  759967
  765517
  765554
  765721
  775436
  775818
  777580
  787274
  800052
  802845
  811503
  815456
  815541
  817278
  817832
  817878
  818327
  818358
  825831
  826521
]
2.15 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал mom член"
]
2.07 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal mom dick"
]
1.99 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал mom член"
]
1.75 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.