Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.31 ms
(84.64%)
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
  449086
  455079
  455081
  459559
  461056
  461890
  463122
  463280
  468288
  469566
  470442
  470903
  473831
  475280
  497311
  500300
  500748
  500758
  502487
  505129
  505829
  508273
  511379
  513049
  514241
  515071
  515433
  515953
  515971
  517325
  518108
  518125
  518219
  518671
  522105
  522280
  522604
  522785
  523181
  523823
  523857
  524322
  524530
  525243
  525736
  526381
  527434
  527780
  527867
  527942
  528038
  528202
  530028
  530272
  530370
  530376
  531129
  532164
  532768
  532954
  533073
  534274
  535022
  535084
  536666
  537028
  537670
  537685
  540984
  541849
  542912
  543374
  544528
  545440
  549036
  550128
  550579
  550633
  550680
  553315
  556426
  559111
  559453
  559454
  559942
  560192
  562373
  562820
  563537
  564758
  565150
  566148
  566243
  568537
  571246
  572023
  573748
  580094
  585999
  589105
  589240
  599964
  600410
  601584
  602519
  603403
  604061
  604865
  624742
  632169
  632708
  638576
  641644
  676623
  678141
  679810
  719624
  778268
  786120
  805146
]
18.58 ms
(9.57%)
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
  604061
  805146
  463280
  461890
  524322
  528202
  459559
  449086
  515953
  550680
  549036
  559454
  566148
  603403
  518219
  515971
  522280
  525736
  522604
  513049
  518671
  522785
  523181
  523823
  527434
  540984
  559942
  565150
  589105
  638576
  515433
  505829
  530370
  475280
  580094
  604865
  500300
  514241
  468288
  455081
  527780
  500748
  550633
  556426
  585999
  632169
  455079
  511379
  500758
  542912
  545440
  562820
  523857
  719624
  559111
  544528
  563537
  518108
  559453
  599964
  473831
  461056
  536666
  541849
  469566
  522105
  505129
  530272
  534274
  532768
  528038
  531129
  530028
  530376
  532164
  543374
  550579
  572023
  566243
  601584
  589240
  632708
  525243
  537028
  470903
  532954
  527867
  537670
  568537
  679810
  641644
  786120
  502487
  535022
  537685
  550128
  560192
  571246
  678141
  676623
  527942
  497311
  515071
  518125
  526381
  533073
  535084
  573748
  602519
  508273
  524530
  562373
  600410
  470442
  564758
  517325
  778268
  553315
  624742
  463122
]
3.24 ms
(1.67%)
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
  449086
  455079
  455081
  459559
  461056
  461890
  463122
  463280
  468288
  469566
  470442
  470903
  473831
  475280
  497311
  500300
  500748
  500758
  502487
  505129
  505829
  508273
  511379
  513049
  514241
  515071
  515433
  515953
  515971
  517325
  518108
  518125
  518219
  518671
  522105
  522280
  522604
  522785
  523181
  523823
  523857
  524322
  524530
  525243
  525736
  526381
  527434
  527780
  527867
  527942
  528038
  528202
  530028
  530272
  530370
  530376
  531129
  532164
  532768
  532954
  533073
  534274
  535022
  535084
  536666
  537028
  537670
  537685
  540984
  541849
  542912
  543374
  544528
  545440
  549036
  550128
  550579
  550633
  550680
  553315
  556426
  559111
  559453
  559454
  559942
  560192
  562373
  562820
  563537
  564758
  565150
  566148
  566243
  568537
  571246
  572023
  573748
  580094
  585999
  589105
  589240
  599964
  600410
  601584
  602519
  603403
  604061
  604865
  624742
  632169
  632708
  638576
  641644
  676623
  678141
  679810
  719624
  778268
  786120
  805146
]
2.28 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sport sex"
]
2.02 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "спортивная секс"
]
2.00 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "спортивная секс"
]
1.71 ms
(0.88%)
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.