Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.63 ms
(81.77%)
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
  386503
  405520
  445851
  446023
  450336
  455981
  497478
  499796
  499860
  506363
  518176
  518950
  520804
  522395
  526768
  527231
  528887
  529180
  535672
  545199
  549817
  557100
  559704
  560104
  561397
  562006
  565687
  565695
  565699
  565754
  565771
  565790
  582352
  591627
  593003
  602260
  610647
  611350
  613845
  614170
  618795
  620983
  621343
  623328
  630084
  641068
  645317
  663318
  674815
  700588
  700631
  701591
  704928
  709257
  714515
  717406
  720079
  720382
  724328
  726465
  726478
  726488
  726489
  726501
  726510
  726513
  726517
  726531
  726566
  726587
  726701
  726708
  726879
  728009
  728048
  728835
  730953
  733142
  741190
  743455
  745980
  748889
  749106
  749462
  756097
  760694
  765379
  766618
  769797
  778393
  789783
  790378
  792655
  793341
  795398
  795525
  795758
  796088
  796109
  800846
  801327
  802104
  802185
  802826
  809516
  810668
  810681
  810696
  810864
  810982
  810983
  811001
  811511
  814822
  815064
  815354
  816975
  818463
  822692
  826130
]
18.16 ms
(12.21%)
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
  674815
  720382
  717406
  645317
  701591
  704928
  720079
  565699
  610647
  614170
  618795
  623328
  810681
  811001
  811511
  789783
  790378
  793341
  802185
  745980
  795525
  796088
  800846
  810864
  728048
  766618
  726465
  726531
  743455
  749106
  769797
  728835
  730953
  733142
  749462
  726701
  756097
  765379
  641068
  714515
  778393
  810696
  386503
  450336
  529180
  405520
  815354
  818463
  814822
  826130
  445851
  455981
  527231
  499860
  526768
  499796
  559704
  561397
  565754
  562006
  545199
  700588
  663318
  560104
  565771
  620983
  630084
  591627
  613845
  621343
  795758
  796109
  809516
  726489
  726510
  726513
  726517
  795398
  810983
  726566
  724328
  726478
  726879
  728009
  760694
  726501
  741190
  700631
  810668
  810982
  535672
  446023
  801327
  822692
  816975
  815064
  518950
  522395
  506363
  520804
  549817
  557100
  709257
  565687
  565695
  565790
  582352
  593003
  611350
  792655
  802104
  802826
  726488
  726708
  748889
  726587
  602260
  518176
  497478
  528887
]
2.55 ms
(1.71%)
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
  386503
  405520
  445851
  446023
  450336
  455981
  497478
  499796
  499860
  506363
  518176
  518950
  520804
  522395
  526768
  527231
  528887
  529180
  535672
  545199
  549817
  557100
  559704
  560104
  561397
  562006
  565687
  565695
  565699
  565754
  565771
  565790
  582352
  591627
  593003
  602260
  610647
  611350
  613845
  614170
  618795
  620983
  621343
  623328
  630084
  641068
  645317
  663318
  674815
  700588
  700631
  701591
  704928
  709257
  714515
  717406
  720079
  720382
  724328
  726465
  726478
  726488
  726489
  726501
  726510
  726513
  726517
  726531
  726566
  726587
  726701
  726708
  726879
  728009
  728048
  728835
  730953
  733142
  741190
  743455
  745980
  748889
  749106
  749462
  756097
  760694
  765379
  766618
  769797
  778393
  789783
  790378
  792655
  793341
  795398
  795525
  795758
  796088
  796109
  800846
  801327
  802104
  802185
  802826
  809516
  810668
  810681
  810696
  810864
  810982
  810983
  811001
  811511
  814822
  815064
  815354
  816975
  818463
  822692
  826130
]
2.03 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "horny latina"
]
1.59 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.51 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "horny латинская"
]
1.28 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "horny латинская"
]

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.