Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.75 ms
(83.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
  394532
  396275
  396740
  397345
  397350
  397535
  399058
  399853
  404234
  404366
  408994
  414509
  414516
  418049
  418411
  418421
  419149
  419906
  421127
  425707
  426041
  427126
  428523
  428569
  431028
  443205
  443215
  443301
  444823
  445284
  445526
  445551
  445821
  445900
  447043
  447323
  447340
  447855
  449019
  451684
  456254
  459234
  459237
  463943
  467844
  468574
  468584
  468587
  469656
  470321
  471355
  473056
  473094
  473778
  475451
  475750
  475989
  479333
  484342
  489366
  489370
  496088
  498238
  506579
  508534
  510622
  511268
  516427
  517727
  517819
  518935
  521779
  522905
  526996
  535465
  540595
  540918
  540926
  543892
  545539
  548046
  548872
  552030
  552567
  553920
  555807
  556406
  561818
  564827
  565051
  566102
  569134
  573873
  579624
  581132
  584153
  585373
  585398
  587125
  592374
  598252
  600485
  600553
  600623
  618373
  619367
  620291
  624249
  652121
  658110
  667106
  693024
  702404
  744844
  747004
  747929
  755743
  777306
  791368
  827610
]
19.93 ms
(11.20%)
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
  508534
  535465
  475750
  548872
  693024
  652121
  658110
  702404
  564827
  565051
  620291
  624249
  600623
  600553
  777306
  791368
  755743
  747929
  397345
  397535
  473778
  445821
  447043
  471355
  397350
  419149
  451684
  489370
  540926
  667106
  600485
  618373
  399058
  443215
  426041
  445551
  449019
  459234
  517819
  518935
  573873
  414509
  445526
  467844
  456254
  414516
  479333
  469656
  516427
  498238
  396740
  543892
  585373
  404234
  496088
  396275
  399853
  418049
  428523
  444823
  421127
  443205
  443301
  827610
  475451
  445900
  473094
  553920
  555807
  581132
  561818
  566102
  569134
  584153
  587125
  619367
  585398
  592374
  744844
  747004
  394532
  445284
  463943
  468584
  468574
  468587
  470321
  431028
  526996
  540918
  484342
  489366
  517727
  522905
  552030
  447323
  475989
  404366
  425707
  579624
  548046
  428569
  418411
  418421
  473056
  598252
  427126
  447340
  506579
  419906
  408994
  459237
  447855
  510622
  540595
  511268
  521779
  545539
  552567
  556406
]
2.80 ms
(1.57%)
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
  394532
  396275
  396740
  397345
  397350
  397535
  399058
  399853
  404234
  404366
  408994
  414509
  414516
  418049
  418411
  418421
  419149
  419906
  421127
  425707
  426041
  427126
  428523
  428569
  431028
  443205
  443215
  443301
  444823
  445284
  445526
  445551
  445821
  445900
  447043
  447323
  447340
  447855
  449019
  451684
  456254
  459234
  459237
  463943
  467844
  468574
  468584
  468587
  469656
  470321
  471355
  473056
  473094
  473778
  475451
  475750
  475989
  479333
  484342
  489366
  489370
  496088
  498238
  506579
  508534
  510622
  511268
  516427
  517727
  517819
  518935
  521779
  522905
  526996
  535465
  540595
  540918
  540926
  543892
  545539
  548046
  548872
  552030
  552567
  553920
  555807
  556406
  561818
  564827
  565051
  566102
  569134
  573873
  579624
  581132
  584153
  585373
  585398
  587125
  592374
  598252
  600485
  600553
  600623
  618373
  619367
  620291
  624249
  652121
  658110
  667106
  693024
  702404
  744844
  747004
  747929
  755743
  777306
  791368
  827610
]
1.83 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny tiny tits"
]
1.63 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые tiny сиськ"
]
1.40 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худые tiny сиськ"
]

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.