Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.22 ms
(82.59%)
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
  6863
  21575
  33488
  38261
  78786
  177440
  313892
  386190
  386416
  387018
  389593
  390698
  390709
  391288
  395724
  402335
  410660
  410841
  419179
  419739
  421599
  429365
  431152
  439055
  447328
  447501
  447641
  447999
  449407
  451671
  451685
  452539
  456976
  458253
  458666
  459320
  459593
  461970
  463086
  464300
  464763
  466778
  470253
  470340
  470537
  470722
  475855
  476627
  477387
  477420
  477863
  477973
  478205
  478515
  479991
  480338
  481328
  484155
  486751
  488588
  490846
  491215
  492835
  493814
  494608
  497029
  498130
  498220
  498921
  499051
  502290
  503797
  504902
  505319
  509400
  517604
  518278
  521954
  522492
  522824
  522862
  523507
  524444
  526122
  533633
  538265
  538411
  538415
  544168
  546748
  547618
  549322
  552827
  556187
  558017
  559042
  559231
  561733
  562395
  565081
  567403
  567695
  569991
  570402
  574784
  575158
  577178
  581212
  589106
  591201
  595819
  604789
  606995
  618173
  653261
  656525
  672674
  675795
  747943
  780600
]
16.94 ms
(10.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
  493814
  499051
  524444
  538265
  490846
  497029
  498130
  505319
  522492
  522824
  538411
  575158
  780600
  449407
  503797
  386190
  6863
  387018
  452539
  526122
  509400
  567403
  570402
  606995
  480338
  447328
  447501
  494608
  486751
  177440
  33488
  78786
  672674
  451671
  498220
  522862
  502290
  577178
  581212
  544168
  549322
  565081
  574784
  656525
  653261
  569991
  589106
  595819
  386416
  390709
  470253
  21575
  421599
  439055
  470722
  478205
  313892
  389593
  410660
  429365
  504902
  498921
  521954
  523507
  484155
  492835
  488588
  538415
  395724
  38261
  390698
  419179
  463086
  464300
  478515
  447641
  475855
  459320
  491215
  517604
  533633
  464763
  476627
  477387
  477863
  552827
  559231
  567695
  547618
  559042
  556187
  561733
  675795
  546748
  558017
  562395
  604789
  618173
  591201
  747943
  391288
  458253
  470340
  479991
  481328
  431152
  458666
  466778
  419739
  451685
  461970
  477420
  477973
  402335
  410841
  447999
  456976
  459593
  470537
  518278
]
4.06 ms
(2.53%)
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
  6863
  21575
  33488
  38261
  78786
  177440
  313892
  386190
  386416
  387018
  389593
  390698
  390709
  391288
  395724
  402335
  410660
  410841
  419179
  419739
  421599
  429365
  431152
  439055
  447328
  447501
  447641
  447999
  449407
  451671
  451685
  452539
  456976
  458253
  458666
  459320
  459593
  461970
  463086
  464300
  464763
  466778
  470253
  470340
  470537
  470722
  475855
  476627
  477387
  477420
  477863
  477973
  478205
  478515
  479991
  480338
  481328
  484155
  486751
  488588
  490846
  491215
  492835
  493814
  494608
  497029
  498130
  498220
  498921
  499051
  502290
  503797
  504902
  505319
  509400
  517604
  518278
  521954
  522492
  522824
  522862
  523507
  524444
  526122
  533633
  538265
  538411
  538415
  544168
  546748
  547618
  549322
  552827
  556187
  558017
  559042
  559231
  561733
  562395
  565081
  567403
  567695
  569991
  570402
  574784
  575158
  577178
  581212
  589106
  591201
  595819
  604789
  606995
  618173
  653261
  656525
  672674
  675795
  747943
  780600
]
1.99 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "спин секс"
]
1.89 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "за спиной трах"
]
1.52 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "спин секс"
]
1.48 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.