Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
172.63 ms
(85.10%)
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
  393798
  398683
  409822
  414220
  417560
  418134
  420450
  420829
  423544
  424562
  427623
  428685
  444109
  444848
  445724
  445757
  449238
  449295
  449327
  451282
  452697
  462612
  482590
  495640
  500081
  512366
  514210
  530855
  535089
  535189
  536369
  550438
  551602
  556949
  564369
  564461
  565846
  577963
  579460
  583655
  587125
  590415
  590459
  596230
  611314
  619448
  621498
  638775
  643984
  646437
  650489
  651874
  674233
  674547
  677061
  677322
  684360
  697558
  702639
  719108
  724441
  724725
  727473
  728192
  730420
  734351
  742983
  744163
  744834
  745361
  746304
  747799
  748990
  755608
  757519
  761883
  765897
  766043
  767469
  768105
  768249
  770765
  771426
  775653
  777133
  779237
  779918
  780326
  781932
  784357
  786121
  786882
  790367
  792258
  793246
  793301
  794182
  795104
  795374
  799206
  802368
  807513
  812271
  812306
  816774
  817229
  819548
  821541
  824145
  824208
  824402
  825189
  825258
  825898
  826347
  826724
  827269
  827271
  827711
]
20.34 ms
(10.03%)
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
  451282
  418134
  414220
  827269
  590459
  786882
  719108
  793301
  744163
  730420
  420450
  427623
  445724
  530855
  495640
  684360
  677061
  611314
  779237
  799206
  462612
  423544
  824145
  825258
  827271
  827711
  819548
  550438
  702639
  651874
  674547
  619448
  596230
  775653
  780326
  793246
  795374
  779918
  792258
  812271
  724725
  746304
  748990
  770765
  784357
  724441
  744834
  757519
  747799
  767469
  768105
  771426
  802368
  825898
  449327
  564461
  428685
  514210
  482590
  587125
  452697
  579460
  417560
  449238
  826724
  816774
  734351
  745361
  577963
  825189
  825511
  826347
  646437
  727473
  768249
  393798
  444109
  444848
  449295
  536369
  535089
  564369
  583655
  650489
  677322
  565846
  643984
  807513
  424562
  445757
  409822
  500081
  512366
  674233
  398683
  420829
  821541
  817229
  824208
  824402
  535189
  551602
  556949
  621498
  638775
  590415
  777133
  781932
  812306
  786121
  795104
  755608
  790367
  794182
  728192
  742983
  766043
  761883
  765897
  697558
]
2.74 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
  393798
  398683
  409822
  414220
  417560
  418134
  420450
  420829
  423544
  424562
  427623
  428685
  444109
  444848
  445724
  445757
  449238
  449295
  449327
  451282
  452697
  462612
  482590
  495640
  500081
  512366
  514210
  530855
  535089
  535189
  536369
  550438
  551602
  556949
  564369
  564461
  565846
  577963
  579460
  583655
  587125
  590415
  590459
  596230
  611314
  619448
  621498
  638775
  643984
  646437
  650489
  651874
  674233
  674547
  677061
  677322
  684360
  697558
  702639
  719108
  724441
  724725
  727473
  728192
  730420
  734351
  742983
  744163
  744834
  745361
  746304
  747799
  748990
  755608
  757519
  761883
  765897
  766043
  767469
  768105
  768249
  770765
  771426
  775653
  777133
  779237
  779918
  780326
  781932
  784357
  786121
  786882
  790367
  792258
  793246
  793301
  794182
  795104
  795374
  799206
  802368
  807513
  812271
  812306
  816774
  817229
  819548
  821541
  824145
  824208
  824402
  825189
  825258
  825898
  826347
  826724
  827269
  827271
  827711
]
2.31 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "shaved pussy lick"
]
1.82 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "бритая pussy лиза"
]
1.35 ms
(0.66%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "бритая pussy лиза"
]

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.