Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
174.58 ms
(86.65%)
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
  393724
  406059
  406089
  410051
  411201
  414306
  414357
  414548
  419406
  421131
  421273
  421352
  428372
  442994
  443323
  447258
  447444
  451492
  458555
  467605
  470135
  472125
  478853
  484699
  489285
  494620
  496086
  500947
  508418
  508430
  508528
  514706
  515415
  516569
  516625
  517784
  517857
  518917
  521469
  525178
  525731
  526359
  527411
  527428
  527464
  530630
  531204
  531251
  531254
  532665
  532762
  534625
  535038
  535456
  537247
  544824
  557812
  560203
  565539
  574149
  584602
  590256
  597239
  600289
  600312
  601581
  603386
  604061
  612856
  628363
  628381
  628402
  632046
  637034
  637427
  639258
  639748
  640435
  640793
  644025
  647895
  648593
  650145
  650476
  650830
  653870
  676638
  677287
  693078
  693269
  715544
  715670
  718970
  719524
  722829
  724719
  725310
  727334
  727505
  736912
  739915
  740875
  743130
  759502
  771321
  775279
  776787
  781776
  786924
  792679
  796556
  797472
  800252
  802658
  805797
  807953
  811004
  813247
  814075
  825217
]
17.45 ms
(8.66%)
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
  515415
  527411
  527464
  470135
  693269
  715670
  628381
  478853
  447444
  514706
  525178
  508418
  727334
  743130
  640435
  637427
  612856
  800252
  797472
  811004
  727505
  792679
  442994
  518917
  494620
  496086
  527428
  532665
  535038
  544824
  565539
  650476
  648593
  650830
  604061
  603386
  807953
  447258
  421131
  393724
  521469
  517857
  484699
  489285
  516569
  759502
  776787
  825217
  719524
  722829
  796556
  724719
  414357
  421352
  414306
  537247
  517784
  530630
  531254
  647895
  600312
  637034
  632046
  639748
  644025
  421273
  406059
  419406
  451492
  467605
  411201
  414548
  516625
  535456
  500947
  677287
  715544
  693078
  557812
  601581
  739915
  771321
  508430
  639258
  406089
  526359
  508528
  531204
  531251
  534625
  532762
  574149
  584602
  590256
  628402
  640793
  597239
  600289
  628363
  458555
  410051
  718970
  814075
  650145
  805797
  802658
  725310
  786924
  740875
  775279
  781776
  813247
  736912
  443323
  428372
  472125
  525731
  560203
  676638
  653870
]
2.23 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "extreme facesitting"
]
2.08 ms
(1.03%)
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
  393724
  406059
  406089
  410051
  411201
  414306
  414357
  414548
  419406
  421131
  421273
  421352
  428372
  442994
  443323
  447258
  447444
  451492
  458555
  467605
  470135
  472125
  478853
  484699
  489285
  494620
  496086
  500947
  508418
  508430
  508528
  514706
  515415
  516569
  516625
  517784
  517857
  518917
  521469
  525178
  525731
  526359
  527411
  527428
  527464
  530630
  531204
  531251
  531254
  532665
  532762
  534625
  535038
  535456
  537247
  544824
  557812
  560203
  565539
  574149
  584602
  590256
  597239
  600289
  600312
  601581
  603386
  604061
  612856
  628363
  628381
  628402
  632046
  637034
  637427
  639258
  639748
  640435
  640793
  644025
  647895
  648593
  650145
  650476
  650830
  653870
  676638
  677287
  693078
  693269
  715544
  715670
  718970
  719524
  722829
  724719
  725310
  727334
  727505
  736912
  739915
  740875
  743130
  759502
  771321
  775279
  776787
  781776
  786924
  792679
  796556
  797472
  800252
  802658
  805797
  807953
  811004
  813247
  814075
  825217
]
1.77 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "хардкор фейсситтинг"
]
1.74 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.80%)
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.