Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
184.50 ms
(88.14%)
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
  55966
  95943
  187843
  188266
  188338
  233486
  358566
  358887
  384581
  384911
  386378
  389351
  389863
  389945
  393055
  395153
  395919
  399585
  400489
  400838
  400861
  402897
  405188
  407650
  409938
  410254
  411237
  411350
  411766
  411914
  412311
  414771
  416982
  421565
  422171
  422200
  422354
  423426
  425990
  427308
  428827
  430313
  432735
  433241
  435700
  436437
  439616
  439623
  439717
  439754
  446112
  454274
  454525
  456564
  459804
  460315
  463968
  465963
  466015
  466182
  466212
  467619
  468406
  469472
  469509
  470213
  470215
  473139
  474627
  474694
  476559
  478546
  483557
  484671
  484738
  486346
  489138
  494037
  496269
  499826
  504091
  516107
  527915
  550350
  551579
  561632
  561816
  564686
  565134
  566993
  573801
  576412
  580631
  581349
  593125
  593487
  597170
  597963
  598386
  603536
  623493
  645891
  650388
  696415
  726838
  732054
  741896
  742704
  760827
  761590
  766613
  769491
  771163
  777420
  789722
  790813
  793770
  814235
  818630
  823857
]
15.88 ms
(7.58%)
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
  422354
  469509
  467619
  469472
  411350
  474627
  465963
  484671
  484738
  489138
  188266
  395919
  460315
  483557
  726838
  427308
  358566
  456564
  400489
  402897
  463968
  439717
  516107
  593125
  439623
  411237
  407650
  428827
  425990
  430313
  551579
  573801
  386378
  422200
  446112
  476559
  358887
  400838
  454274
  470213
  478546
  95943
  421565
  435700
  439616
  474694
  405188
  439754
  454525
  466015
  470215
  384911
  399585
  423426
  411914
  409938
  411766
  468406
  561632
  696415
  645891
  565134
  777420
  761590
  793770
  741896
  732054
  760827
  188338
  389351
  410254
  564686
  566993
  603536
  598386
  473139
  414771
  550350
  597170
  771163
  416982
  580631
  436437
  459804
  527915
  597963
  494037
  412311
  433241
  499826
  422171
  393055
  466212
  504091
  486346
  814235
  576412
  581349
  561816
  593487
  496269
  384581
  233486
  395153
  389863
  389945
  818630
  823857
  650388
  790813
  742704
  769491
  623493
  789722
  766613
  466182
  187843
  55966
  400861
  432735
]
3.18 ms
(1.52%)
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
  55966
  95943
  187843
  188266
  188338
  233486
  358566
  358887
  384581
  384911
  386378
  389351
  389863
  389945
  393055
  395153
  395919
  399585
  400489
  400838
  400861
  402897
  405188
  407650
  409938
  410254
  411237
  411350
  411766
  411914
  412311
  414771
  416982
  421565
  422171
  422200
  422354
  423426
  425990
  427308
  428827
  430313
  432735
  433241
  435700
  436437
  439616
  439623
  439717
  439754
  446112
  454274
  454525
  456564
  459804
  460315
  463968
  465963
  466015
  466182
  466212
  467619
  468406
  469472
  469509
  470213
  470215
  473139
  474627
  474694
  476559
  478546
  483557
  484671
  484738
  486346
  489138
  494037
  496269
  499826
  504091
  516107
  527915
  550350
  551579
  561632
  561816
  564686
  565134
  566993
  573801
  576412
  580631
  581349
  593125
  593487
  597170
  597963
  598386
  603536
  623493
  645891
  650388
  696415
  726838
  732054
  741896
  742704
  760827
  761590
  766613
  769491
  771163
  777420
  789722
  790813
  793770
  814235
  818630
  823857
]
1.61 ms
(0.77%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.70%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young парен анал"
]
1.35 ms
(0.65%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young парен анал"
]
1.35 ms
(0.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young boy anal"
]

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.