Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.40 ms
(85.50%)
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
  172262
  285231
  385931
  400791
  400826
  406978
  409261
  409371
  410029
  410324
  411685
  413783
  414138
  414174
  415573
  417782
  417927
  420561
  421204
  421559
  421665
  422710
  424970
  427654
  437867
  446206
  453138
  454329
  455569
  456458
  457341
  459246
  460514
  460619
  463832
  464209
  464404
  464454
  465512
  466972
  467155
  468022
  468730
  468809
  469023
  469377
  469465
  471435
  479767
  480758
  483150
  485659
  489472
  490905
  495385
  496119
  496935
  499236
  503441
  505447
  506016
  506437
  508131
  509101
  511219
  511833
  515363
  515661
  515970
  517283
  517579
  517792
  518019
  518564
  519622
  520817
  520930
  521167
  522608
  522662
  524117
  528316
  528952
  536136
  547815
  562719
  567222
  569009
  573298
  580252
  580839
  582270
  582487
  582915
  584566
  593225
  598846
  601160
  604723
  605152
  607014
  608195
  619703
  621492
  634688
  636559
  650544
  700702
  705536
  716307
  726810
  747316
  747475
  756497
  759892
  759946
  770228
  770291
  783291
  814782
]
14.64 ms
(8.67%)
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
  747475
  726810
  756497
  770228
  508131
  467155
  483150
  406978
  415573
  459246
  524117
  471435
  582270
  409371
  424970
  400791
  285231
  422710
  464404
  417927
  522608
  518019
  511833
  511219
  517579
  582915
  420561
  417782
  468022
  453138
  580839
  547815
  468809
  456458
  468730
  410324
  446206
  517792
  517283
  520930
  584566
  562719
  520817
  605152
  608195
  636559
  528952
  621492
  604723
  783291
  515970
  410029
  495385
  567222
  747316
  700702
  385931
  455569
  505447
  409261
  454329
  469377
  528316
  536136
  519622
  460619
  580252
  573298
  569009
  593225
  607014
  598846
  601160
  634688
  400826
  466972
  506016
  496935
  503441
  522662
  465512
  469023
  469465
  490905
  619703
  414174
  509101
  521167
  172262
  413783
  421665
  411685
  437867
  814782
  480758
  515661
  499236
  464454
  705536
  716307
  650544
  582487
  759892
  770291
  759946
  421559
  463832
  464209
  414138
  421204
  427654
  457341
  479767
  460514
  515363
  489472
  485659
  506437
  496119
  518564
]
3.00 ms
(1.77%)
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
  172262
  285231
  385931
  400791
  400826
  406978
  409261
  409371
  410029
  410324
  411685
  413783
  414138
  414174
  415573
  417782
  417927
  420561
  421204
  421559
  421665
  422710
  424970
  427654
  437867
  446206
  453138
  454329
  455569
  456458
  457341
  459246
  460514
  460619
  463832
  464209
  464404
  464454
  465512
  466972
  467155
  468022
  468730
  468809
  469023
  469377
  469465
  471435
  479767
  480758
  483150
  485659
  489472
  490905
  495385
  496119
  496935
  499236
  503441
  505447
  506016
  506437
  508131
  509101
  511219
  511833
  515363
  515661
  515970
  517283
  517579
  517792
  518019
  518564
  519622
  520817
  520930
  521167
  522608
  522662
  524117
  528316
  528952
  536136
  547815
  562719
  567222
  569009
  573298
  580252
  580839
  582270
  582487
  582915
  584566
  593225
  598846
  601160
  604723
  605152
  607014
  608195
  619703
  621492
  634688
  636559
  650544
  700702
  705536
  716307
  726810
  747316
  747475
  756497
  759892
  759946
  770228
  770291
  783291
  814782
]
1.94 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в чулках сексуальная %…"
]
1.73 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "чулк нижн бел сексуальн"
]
1.54 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.