Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
167.78 ms
(88.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
  5537
  213144
  382084
  384892
  396157
  396347
  397151
  398779
  405236
  475493
  530819
  548487
  558966
  567125
  573867
  574515
  585665
  587457
  592808
  616941
  619341
  631143
  634016
  638101
  653306
  653313
  654416
  658096
  660955
  663335
  664617
  674523
  681734
  691546
  692069
  701817
  705115
  713172
  719149
  719472
  723095
  726341
  726463
  727870
  731059
  739515
  751701
  753357
  753909
  754799
  762537
  763270
  765765
  766181
  767553
  768391
  769222
  773216
  774122
  774274
  777601
  778226
  778908
  779393
  779920
  780209
  780222
  780319
  780458
  781035
  782038
  783732
  784163
  784390
  787246
  788096
  789309
  790913
  791107
  791230
  791472
  792077
  793465
  796630
  798655
  799403
  800267
  802420
  802564
  810387
  810617
  813912
  814101
  816186
  817212
  817824
  817984
  818016
  818131
  818245
  818598
  819793
  820489
  820622
  821642
  822672
  823642
  824114
  824431
  824474
  824918
  825389
  825730
  825747
  825927
  826191
  826551
  828854
]
11.16 ms
(5.89%)
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
  774122
  405236
  787246
  573867
  382084
  826551
  713172
  763270
  653306
  719472
  778908
  778226
  810617
  767553
  826191
  825927
  824474
  825389
  816186
  825747
  475493
  660955
  638101
  585665
  634016
  777601
  783732
  769222
  396347
  818131
  820622
  824431
  822579
  824114
  548487
  558966
  691546
  653313
  663335
  664617
  719149
  723095
  674523
  567125
  587457
  616941
  780319
  780458
  791230
  780222
  781035
  754799
  765765
  762537
  619341
  631143
  784390
  791472
  792077
  814101
  701817
  592808
  779393
  779920
  799403
  784163
  802420
  766181
  753909
  774274
  789309
  753357
  5537
  817984
  818016
  818598
  823642
  813912
  825730
  821642
  828854
  827979
  574515
  658096
  705115
  796630
  798655
  790913
  731059
  810387
  726463
  739515
  782038
  802564
  384892
  396157
  398779
  824918
  530819
  681734
  692069
  793465
  780209
  751701
  788096
  768391
  726341
  727870
  791107
  213144
  817824
  820489
  654416
  773216
  800267
  397151
  822672
  817212
  818245
  819793
]
3.33 ms
(1.76%)
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
  5537
  213144
  382084
  384892
  396157
  396347
  397151
  398779
  405236
  475493
  530819
  548487
  558966
  567125
  573867
  574515
  585665
  587457
  592808
  616941
  619341
  631143
  634016
  638101
  653306
  653313
  654416
  658096
  660955
  663335
  664617
  674523
  681734
  691546
  692069
  701817
  705115
  713172
  719149
  719472
  723095
  726341
  726463
  727870
  731059
  739515
  751701
  753357
  753909
  754799
  762537
  763270
  765765
  766181
  767553
  768391
  769222
  773216
  774122
  774274
  777601
  778226
  778908
  779393
  779920
  780209
  780222
  780319
  780458
  781035
  782038
  783732
  784163
  784390
  787246
  788096
  789309
  790913
  791107
  791230
  791472
  792077
  793465
  796630
  798655
  799403
  800267
  802420
  802564
  810387
  810617
  813912
  814101
  816186
  817212
  817824
  817984
  818016
  818131
  818245
  818598
  819793
  820489
  820622
  821642
  822672
  823642
  824114
  824431
  824474
  824918
  825389
  825730
  825747
  825927
  826191
  826551
  828854
]
2.04 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teens blowjob"
]
1.86 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teens минет оральн секс"
]
1.72 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.51 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teens минет оральн секс"
]

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.