Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
163.09 ms
(88.47%)
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
  79862
  145635
  151163
  335455
  391575
  395330
  396933
  397403
  398269
  398783
  398919
  400521
  404025
  418522
  420509
  421956
  427158
  431537
  435716
  443271
  443838
  444715
  447040
  449264
  449273
  452662
  455507
  456113
  459083
  460261
  461013
  469382
  483240
  490260
  490458
  496736
  496758
  499018
  504069
  504161
  505572
  509430
  510551
  511274
  513652
  514608
  515322
  516057
  520641
  524004
  526532
  528584
  535855
  537630
  544050
  545686
  553344
  560289
  564715
  564858
  566862
  570096
  572715
  578551
  579879
  580133
  585207
  598964
  603967
  604404
  607472
  620441
  621336
  621603
  623898
  626104
  627695
  630758
  639681
  650964
  653208
  685431
  685489
  689139
  689232
  704019
  707833
  707886
  708701
  709935
  713205
  714443
  715899
  723227
  729308
  736120
  737186
  740423
  748747
  750602
  752961
  754740
  761564
  766861
  777169
  784498
  791504
  795098
  795471
  795620
  797090
  797101
  797871
  799298
  806054
  810339
  810414
  813710
  824228
  825572
]
12.42 ms
(6.74%)
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
  151163
  535855
  689139
  514608
  797101
  766861
  443838
  435716
  564715
  544050
  564858
  585207
  750602
  496758
  685431
  524004
  748747
  761564
  427158
  515322
  713205
  708701
  579879
  404025
  469382
  607472
  509430
  795620
  603967
  570096
  639681
  623898
  452662
  397403
  824228
  398269
  396933
  456113
  545686
  421956
  449273
  511274
  797871
  496736
  715899
  504161
  79862
  685489
  707833
  621603
  723227
  418522
  505572
  490458
  752961
  490260
  537630
  516057
  795471
  797090
  580133
  707886
  653208
  630758
  621336
  443271
  335455
  400521
  444715
  799298
  810339
  499018
  627695
  431537
  449264
  526532
  460261
  714443
  572715
  510551
  398919
  813710
  777169
  810414
  736120
  398783
  483240
  513652
  709935
  620441
  598964
  737186
  704019
  553344
  784498
  825572
  754740
  729308
  740423
  528584
  560289
  566862
  604404
  455507
  650964
  145635
  395330
  578551
  447040
  626104
  791504
  461013
  520641
  391575
  806054
  459083
  420509
  504069
  795098
  689232
]
2.49 ms
(1.35%)
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
  79862
  145635
  151163
  335455
  391575
  395330
  396933
  397403
  398269
  398783
  398919
  400521
  404025
  418522
  420509
  421956
  427158
  431537
  435716
  443271
  443838
  444715
  447040
  449264
  449273
  452662
  455507
  456113
  459083
  460261
  461013
  469382
  483240
  490260
  490458
  496736
  496758
  499018
  504069
  504161
  505572
  509430
  510551
  511274
  513652
  514608
  515322
  516057
  520641
  524004
  526532
  528584
  535855
  537630
  544050
  545686
  553344
  560289
  564715
  564858
  566862
  570096
  572715
  578551
  579879
  580133
  585207
  598964
  603967
  604404
  607472
  620441
  621336
  621603
  623898
  626104
  627695
  630758
  639681
  650964
  653208
  685431
  685489
  689139
  689232
  704019
  707833
  707886
  708701
  709935
  713205
  714443
  715899
  723227
  729308
  736120
  737186
  740423
  748747
  750602
  752961
  754740
  761564
  766861
  777169
  784498
  791504
  795098
  795471
  795620
  797090
  797101
  797871
  799298
  806054
  810339
  810414
  813710
  824228
  825572
]
1.74 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "домашний секс брюнетк…"
]
1.63 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск секс черноволосая"
]
1.43 ms
(0.78%)
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.