Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.56 ms
(84.62%)
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
  101056
  389495
  389803
  390818
  391219
  398940
  408339
  414064
  418692
  418943
  420742
  421199
  424721
  428115
  435171
  446019
  446272
  446695
  449023
  449107
  449470
  450392
  452355
  454282
  456214
  461840
  464836
  465553
  466460
  469081
  473400
  473479
  475860
  480478
  483444
  483686
  497037
  499326
  502777
  503712
  507168
  515275
  515546
  516605
  517736
  520161
  520252
  522184
  522632
  523245
  523461
  523599
  526102
  526556
  529340
  529351
  530811
  538708
  541212
  545882
  547959
  552081
  562418
  564486
  565127
  567331
  567414
  572006
  572764
  574086
  574657
  582282
  582443
  582955
  584158
  584726
  592605
  594113
  594125
  594150
  594201
  596470
  596649
  597284
  601388
  601744
  603310
  604782
  604843
  604909
  605591
  606636
  607070
  607236
  607966
  622592
  625553
  628641
  641436
  650345
  651845
  652513
  679213
  683297
  690020
  717410
  724467
  742383
  745345
  755350
  770123
  770402
  775414
  776398
  799049
  805630
  808027
  810103
  811271
  811415
]
19.20 ms
(10.38%)
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
  389495
  456214
  391219
  408339
  452355
  522632
  811415
  414064
  449023
  480478
  574086
  574657
  545882
  562418
  584158
  601744
  594125
  607070
  449470
  454282
  465553
  526556
  526102
  503712
  446272
  473400
  101056
  389803
  418692
  469081
  483444
  464836
  497037
  499326
  523599
  515546
  529351
  538708
  515275
  466460
  547959
  582955
  565127
  572764
  552081
  679213
  652513
  717410
  650345
  683297
  567414
  582443
  604782
  604909
  606636
  592605
  597284
  604843
  607966
  622592
  601388
  625553
  775414
  799049
  805630
  810103
  776398
  811271
  724467
  770123
  770402
  742383
  745345
  755350
  808027
  475860
  398940
  435171
  450392
  522184
  520252
  523461
  483686
  473479
  507168
  582282
  596649
  594201
  461840
  446019
  516605
  390818
  418943
  421199
  428115
  420742
  424721
  446695
  449107
  520161
  502777
  523245
  517736
  529340
  530811
  564486
  584726
  541212
  690020
  651845
  567331
  572006
  603310
  605591
  594150
  596470
  607236
  628641
  641436
  594113
]
2.56 ms
(1.38%)
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
  101056
  389495
  389803
  390818
  391219
  398940
  408339
  414064
  418692
  418943
  420742
  421199
  424721
  428115
  435171
  446019
  446272
  446695
  449023
  449107
  449470
  450392
  452355
  454282
  456214
  461840
  464836
  465553
  466460
  469081
  473400
  473479
  475860
  480478
  483444
  483686
  497037
  499326
  502777
  503712
  507168
  515275
  515546
  516605
  517736
  520161
  520252
  522184
  522632
  523245
  523461
  523599
  526102
  526556
  529340
  529351
  530811
  538708
  541212
  545882
  547959
  552081
  562418
  564486
  565127
  567331
  567414
  572006
  572764
  574086
  574657
  582282
  582443
  582955
  584158
  584726
  592605
  594113
  594125
  594150
  594201
  596470
  596649
  597284
  601388
  601744
  603310
  604782
  604843
  604909
  605591
  606636
  607070
  607236
  607966
  622592
  625553
  628641
  641436
  650345
  651845
  652513
  679213
  683297
  690020
  717410
  724467
  742383
  745345
  755350
  770123
  770402
  775414
  776398
  799049
  805630
  808027
  810103
  811271
  811415
]
1.95 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "busty masturbation"
]
1.70 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "busty мастурбац"
]
1.39 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "busty мастурбац"
]

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.