Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
114.33 ms
(84.12%)
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
  398003
  398656
  418334
  422817
  426628
  432670
  434877
  445713
  447624
  449238
  451166
  459596
  470384
  479745
  480275
  481130
  501672
  521676
  528294
  551602
  563678
  564887
  566537
  571313
  582079
  590415
  593217
  595938
  616816
  621498
  631426
  648471
  660692
  668692
  672878
  675084
  680611
  699166
  714587
  722124
  724441
  728121
  728958
  732432
  732793
  732837
  733220
  733450
  734344
  734740
  739645
  742337
  743492
  743968
  744144
  744825
  744834
  746304
  748990
  749289
  750319
  752744
  753223
  756318
  758245
  759040
  759775
  762805
  767186
  767469
  768626
  771426
  773546
  775653
  775656
  777128
  778684
  780158
  780294
  780297
  780326
  782769
  784357
  786880
  786883
  786920
  787691
  788564
  790901
  791725
  792228
  792258
  793221
  793246
  795009
  795257
  795374
  797264
  798257
  798775
  800044
  800598
  801612
  802319
  802368
  804413
  806111
  807963
  808263
  809503
  811710
  812271
  818977
  819014
  819331
  819838
  820011
  820014
  824145
  825202
]
12.70 ms
(9.35%)
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
  775653
  780158
  780326
  795374
  775656
  786883
  788564
  792258
  812271
  743968
  746304
  748990
  790901
  800598
  807963
  808263
  724441
  728121
  734344
  734740
  739645
  744144
  744834
  759040
  756318
  768626
  732432
  742337
  771426
  749289
  758245
  714587
  777128
  792228
  398003
  480275
  470384
  551602
  563678
  680611
  699166
  648471
  582079
  631426
  479745
  501672
  722124
  773546
  780294
  422817
  809503
  804413
  521676
  593217
  595938
  616816
  668692
  672878
  447624
  451166
  795257
  733450
  732793
  752744
  759775
  787691
  449238
  459596
  797264
  798775
  426628
  398656
  434877
  660692
  621498
  590415
  793221
  780297
  798257
  801612
  811710
  762805
  744825
  819014
  528294
  432670
  571313
  445713
  825202
  818977
  820011
  820014
  824145
  819331
  819838
  564887
  778684
  782769
  793246
  795009
  800044
  767186
  784357
  786880
  786920
  791725
  802319
  728958
  732837
  743492
  753223
  750319
  767469
  802368
  806111
  418334
  481130
  675084
  733220
  566537
]
2.21 ms
(1.63%)
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
  398003
  398656
  418334
  422817
  426628
  432670
  434877
  445713
  447624
  449238
  451166
  459596
  470384
  479745
  480275
  481130
  501672
  521676
  528294
  551602
  563678
  564887
  566537
  571313
  582079
  590415
  593217
  595938
  616816
  621498
  631426
  648471
  660692
  668692
  672878
  675084
  680611
  699166
  714587
  722124
  724441
  728121
  728958
  732432
  732793
  732837
  733220
  733450
  734344
  734740
  739645
  742337
  743492
  743968
  744144
  744825
  744834
  746304
  748990
  749289
  750319
  752744
  753223
  756318
  758245
  759040
  759775
  762805
  767186
  767469
  768626
  771426
  773546
  775653
  775656
  777128
  778684
  780158
  780294
  780297
  780326
  782769
  784357
  786880
  786883
  786920
  787691
  788564
  790901
  791725
  792228
  792258
  793221
  793246
  795009
  795257
  795374
  797264
  798257
  798775
  800044
  800598
  801612
  802319
  802368
  804413
  806111
  807963
  808263
  809503
  811710
  812271
  818977
  819014
  819331
  819838
  820011
  820014
  824145
  825202
]
2.00 ms
(1.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "лижет у жены дома"
]
1.62 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "лиза жен домашн любительск"
]
1.56 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(1.09%)
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.