Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.88 ms
(84.35%)
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
  25721
  388500
  396447
  397160
  398100
  399421
  399422
  399430
  400322
  400328
  401644
  409803
  410781
  412758
  413368
  413703
  413733
  414359
  418903
  420544
  425333
  426819
  437330
  441073
  441077
  444922
  445885
  451213
  454389
  462969
  466904
  467587
  473476
  487013
  488302
  490469
  493974
  502205
  503773
  519133
  520010
  526985
  557056
  564749
  565657
  567540
  568114
  571791
  575680
  576006
  577531
  577805
  578472
  581366
  583924
  594077
  607499
  611093
  625037
  626333
  628826
  639587
  640298
  644710
  650269
  656621
  659446
  664194
  664606
  665237
  665277
  665397
  667543
  672255
  674125
  680273
  682977
  697208
  697496
  700902
  700911
  700920
  701263
  701677
  704097
  705052
  706202
  709280
  709710
  710926
  712826
  712827
  712828
  715270
  716493
  724307
  728974
  733003
  736467
  742362
  743057
  744071
  746921
  750864
  753744
  755579
  756331
  757496
  758780
  758794
  761254
  800821
  801521
  808642
  810903
  811267
  812882
  824111
  827932
]
14.89 ms
(9.17%)
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
  697496
  710926
  650269
  665277
  672255
  697208
  700911
  704097
  659446
  664194
  665237
  680273
  682977
  709280
  716493
  575680
  581366
  628826
  640298
  644710
  808642
  810903
  800821
  801521
  812882
  733003
  744071
  755579
  728974
  750864
  761254
  611093
  701263
  414359
  399422
  413368
  827932
  451213
  454389
  674125
  656621
  724307
  756331
  742362
  444922
  758780
  488302
  25721
  397160
  398100
  743057
  709710
  409803
  401644
  410781
  396447
  564749
  811267
  571791
  578472
  487013
  577531
  667543
  413703
  425333
  399421
  441077
  441073
  445885
  607499
  758794
  400328
  400322
  426819
  418903
  437330
  824111
  567540
  583924
  715270
  700902
  705052
  700920
  701677
  706202
  639587
  770409
  736467
  753744
  757496
  746921
  399430
  413733
  576006
  665397
  712826
  712828
  473476
  526985
  466904
  388500
  493974
  519133
  594077
  412758
  420544
  462969
  467587
  490469
  503773
  502205
  557056
  565657
  568114
  577805
  664606
  712827
  625037
  626333
  520010
]
3.40 ms
(2.10%)
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
  25721
  388500
  396447
  397160
  398100
  399421
  399422
  399430
  400322
  400328
  401644
  409803
  410781
  412758
  413368
  413703
  413733
  414359
  418903
  420544
  425333
  426819
  437330
  441073
  441077
  444922
  445885
  451213
  454389
  462969
  466904
  467587
  473476
  487013
  488302
  490469
  493974
  502205
  503773
  519133
  520010
  526985
  557056
  564749
  565657
  567540
  568114
  571791
  575680
  576006
  577531
  577805
  578472
  581366
  583924
  594077
  607499
  611093
  625037
  626333
  628826
  639587
  640298
  644710
  650269
  656621
  659446
  664194
  664606
  665237
  665277
  665397
  667543
  672255
  674125
  680273
  682977
  697208
  697496
  700902
  700911
  700920
  701263
  701677
  704097
  705052
  706202
  709280
  709710
  710926
  712826
  712827
  712828
  715270
  716493
  724307
  728974
  733003
  736467
  742362
  743057
  744071
  746921
  750864
  753744
  755579
  756331
  757496
  758780
  758794
  761254
  800821
  801521
  808642
  810903
  811267
  812882
  824111
  827932
]
1.95 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "chubby girl 18"
]
1.76 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "chubby девушк 18"
]
1.73 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "chubby девушк 18"
]

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.