Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.51 ms
(87.74%)
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
  197
  15317
  76150
  91473
  185428
  338807
  384297
  391880
  393350
  395185
  396356
  398239
  401537
  401540
  403086
  423436
  459735
  518182
  522636
  533335
  533363
  545136
  546415
  575341
  579464
  595022
  603262
  612146
  621280
  624650
  635521
  635742
  644338
  647817
  648538
  649580
  653530
  654455
  663315
  675607
  683970
  695123
  722159
  722219
  730183
  730634
  733473
  734869
  736165
  740598
  740784
  746303
  755407
  758121
  762522
  764622
  766221
  766863
  767290
  767834
  768263
  769194
  775147
  775474
  776046
  776230
  777034
  778174
  778764
  779195
  779819
  781086
  781160
  783089
  783372
  785782
  786680
  789581
  791239
  791831
  792433
  794896
  795463
  795860
  796344
  796909
  797024
  797159
  797564
  799517
  800452
  801622
  802584
  803439
  803914
  807720
  810318
  810334
  810371
  813611
  814558
  817007
  817301
  817441
  818233
  818766
  819024
  819264
  819403
  819404
  820192
  823167
  823842
  824069
  824943
  825472
  826265
  826572
  826888
  827383
]
13.19 ms
(7.12%)
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
  766221
  612146
  775474
  778174
  781086
  785782
  786680
  802584
  91473
  384297
  824943
  823167
  733473
  197
  401540
  823842
  824069
  533335
  575341
  647817
  644338
  621280
  781160
  797564
  769194
  796909
  797024
  797159
  810371
  695123
  817441
  813611
  817301
  827383
  579464
  653530
  683970
  663315
  775147
  778764
  791831
  803439
  736165
  767834
  762522
  767290
  779819
  799517
  810334
  533363
  401537
  403086
  817007
  819404
  820192
  826888
  825472
  819264
  654455
  722159
  649580
  624650
  740598
  740784
  768263
  783372
  755407
  758121
  766863
  730634
  764622
  779195
  789581
  794896
  801622
  423436
  76150
  185428
  393350
  395185
  391880
  338807
  15317
  396356
  398239
  818766
  819403
  826572
  826265
  814558
  819024
  818233
  459735
  518182
  522636
  546415
  545136
  675607
  722219
  648538
  635521
  595022
  603262
  635742
  776230
  783089
  795463
  796344
  810318
  776046
  777034
  791239
  795860
  800452
  734869
  746303
  792433
  803914
  807720
  730183
]
2.99 ms
(1.61%)
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
  197
  15317
  76150
  91473
  185428
  338807
  384297
  391880
  393350
  395185
  396356
  398239
  401537
  401540
  403086
  423436
  459735
  518182
  522636
  533335
  533363
  545136
  546415
  575341
  579464
  595022
  603262
  612146
  621280
  624650
  635521
  635742
  644338
  647817
  648538
  649580
  653530
  654455
  663315
  675607
  683970
  695123
  722159
  722219
  730183
  730634
  733473
  734869
  736165
  740598
  740784
  746303
  755407
  758121
  762522
  764622
  766221
  766863
  767290
  767834
  768263
  769194
  775147
  775474
  776046
  776230
  777034
  778174
  778764
  779195
  779819
  781086
  781160
  783089
  783372
  785782
  786680
  789581
  791239
  791831
  792433
  794896
  795463
  795860
  796344
  796909
  797024
  797159
  797564
  799517
  800452
  801622
  802584
  803439
  803914
  807720
  810318
  810334
  810371
  813611
  814558
  817007
  817301
  817441
  818233
  818766
  819024
  819264
  819403
  819404
  820192
  823167
  823842
  824069
  824943
  825472
  826265
  826572
  826888
  827383
]
1.89 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "creampie fuck"
]
1.68 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "creampie секс"
]
1.55 ms
(0.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "creampie секс"
]

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.