Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
238.20 ms
(50.86%)
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
  286389
  348262
  408326
  416155
  418088
  421563
  422028
  422223
  423955
  426844
  433211
  435404
  442335
  443492
  446425
  449635
  449778
  453517
  456886
  459368
  460767
  461401
  461811
  464366
  464658
  470609
  473115
  480214
  481249
  485948
  490063
  496475
  499497
  516462
  520206
  520460
  524535
  525156
  527667
  542971
  543974
  544515
  545099
  548725
  553428
  555206
  555696
  555751
  556561
  559985
  566055
  566061
  566295
  568368
  571797
  571840
  576904
  576935
  577996
  578739
  582708
  583598
  584660
  585170
  588794
  590892
  593849
  595756
  596176
  596641
  598633
  599230
  604251
  606734
  611588
  611812
  613246
  617614
  625776
  628659
  658810
  660111
  660435
  675110
  687259
  701610
  707434
  709560
  712243
  718615
  734537
  747066
  760181
  771177
  771182
  771255
  771609
  775707
  776582
  780706
  784717
  789491
  789571
  790008
  791356
  792412
  795028
  795143
  795148
  795915
  796193
  797262
  798622
  799394
  802947
  805212
  809481
  812265
  812387
  812684
]
209.00 ms
(44.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov licking"
]
12.79 ms
(2.73%)
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
  525156
  520206
  464658
  481249
  485948
  543974
  548725
  556561
  568368
  571797
  553428
  559985
  566055
  566061
  571840
  576904
  584660
  544515
  545099
  555206
  576935
  577996
  658810
  687259
  712243
  660111
  660435
  555696
  578739
  583598
  613246
  617614
  596176
  588794
  598633
  599230
  611812
  585170
  590892
  606734
  611588
  628659
  784717
  789571
  795915
  798622
  812387
  812684
  775707
  776582
  795143
  795148
  760181
  790008
  791356
  797262
  802947
  771255
  747066
  771177
  771609
  771182
  780706
  789491
  792412
  799394
  805212
  809481
  812265
  460767
  416155
  421563
  459368
  470609
  480214
  286389
  423955
  426844
  435404
  418088
  461401
  473115
  453517
  461811
  499497
  555751
  701610
  709560
  718615
  625776
  596641
  796193
  795028
  734537
  582708
  566295
  707434
  675110
  604251
  446425
  433211
  442335
  449635
  527667
  520460
  524535
  542971
  593849
  595756
  449778
  464366
  422028
  516462
  490063
  348262
  408326
  422223
  443492
  456886
  496475
]
3.44 ms
(0.73%)
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
  286389
  348262
  408326
  416155
  418088
  421563
  422028
  422223
  423955
  426844
  433211
  435404
  442335
  443492
  446425
  449635
  449778
  453517
  456886
  459368
  460767
  461401
  461811
  464366
  464658
  470609
  473115
  480214
  481249
  485948
  490063
  496475
  499497
  516462
  520206
  520460
  524535
  525156
  527667
  542971
  543974
  544515
  545099
  548725
  553428
  555206
  555696
  555751
  556561
  559985
  566055
  566061
  566295
  568368
  571797
  571840
  576904
  576935
  577996
  578739
  582708
  583598
  584660
  585170
  588794
  590892
  593849
  595756
  596176
  596641
  598633
  599230
  604251
  606734
  611588
  611812
  613246
  617614
  625776
  628659
  658810
  660111
  660435
  675110
  687259
  701610
  707434
  709560
  712243
  718615
  734537
  747066
  760181
  771177
  771182
  771255
  771609
  775707
  776582
  780706
  784717
  789491
  789571
  790008
  791356
  792412
  795028
  795143
  795148
  795915
  796193
  797262
  798622
  799394
  802947
  805212
  809481
  812265
  812387
  812684
]
1.90 ms
(0.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов лиза"
]
1.69 ms
(0.36%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.36 ms
(0.29%)
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.