Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
642.11 ms
(48.92%)
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
  382846
  505537
  520742
  532298
  532430
  537386
  539797
  547000
  547018
  547041
  548327
  550159
  551677
  553592
  555496
  555613
  558724
  559842
  560061
  560222
  562444
  563052
  563264
  566652
  567727
  567962
  568186
  574742
  575003
  576441
  585793
  591358
  591489
  592510
  593952
  594067
  594171
  594409
  598885
  598970
  602334
  603367
  604989
  605247
  606396
  610053
  618028
  618676
  619176
  627013
  627363
  631055
  631575
  631662
  632926
  634732
  636141
  636436
  636482
  638849
  640148
  641263
  641539
  643645
  643751
  644207
  644536
  644605
  644710
  646042
  646164
  665332
  665337
  667365
  667455
  668794
  671920
  672752
  675509
  682406
  691173
  700702
  701427
  701705
  702440
  705315
  707561
  708657
  709300
  709920
  710185
  710912
  713134
  715260
  715270
  717473
  723817
  724494
  730062
  743003
  743786
  743792
  745298
  745324
  748465
  758264
  758283
  763546
  783462
  794188
  796283
  796578
  797898
  800739
  804529
  804631
  804660
  807884
  811483
  823713
]
273.25 ms
(20.82%)
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
  634732
  707561
  710912
  574742
  627013
  537386
  567727
  550159
  646042
  675509
  705315
  667455
  631575
  631662
  603367
  618676
  636482
  643751
  602334
  644536
  702440
  539797
  548327
  555613
  558724
  646164
  715270
  547000
  553592
  585793
  783462
  797898
  804660
  730062
  743003
  796578
  800739
  745324
  743786
  758283
  632926
  794188
  807884
  811483
  641263
  591489
  796283
  682406
  665332
  638849
  605247
  560061
  575003
  665337
  562444
  598885
  610053
  619176
  641539
  598970
  636436
  591358
  743792
  804631
  567962
  547041
  566652
  576441
  594409
  563052
  563264
  672752
  532430
  710185
  723817
  560222
  520742
  724494
  592510
  745298
  717473
  547018
  594171
  804529
  823713
  618028
  715260
  668794
  701705
  708657
  709920
  713134
  636141
  640148
  644207
  631055
  700702
  709300
  551677
  667365
  644710
  627363
  594067
  604989
  763546
  644605
  701427
  532298
  758264
  691173
  748465
  382846
  568186
  606396
  671920
  559842
  555496
  643645
  505537
  593952
]
206.80 ms
(15.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big tits amateurs"
]
185.03 ms
(14.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
  382846
  505537
  520742
  532298
  532430
  537386
  539797
  547000
  547018
  547041
  548327
  550159
  551677
  553592
  555496
  555613
  558724
  559842
  560061
  560222
  562444
  563052
  563264
  566652
  567727
  567962
  568186
  574742
  575003
  576441
  585793
  591358
  591489
  592510
  593952
  594067
  594171
  594409
  598885
  598970
  602334
  603367
  604989
  605247
  606396
  610053
  618028
  618676
  619176
  627013
  627363
  631055
  631575
  631662
  632926
  634732
  636141
  636436
  636482
  638849
  640148
  641263
  641539
  643645
  643751
  644207
  644536
  644605
  644710
  646042
  646164
  665332
  665337
  667365
  667455
  668794
  671920
  672752
  675509
  682406
  691173
  700702
  701427
  701705
  702440
  705315
  707561
  708657
  709300
  709920
  710185
  710912
  713134
  715260
  715270
  717473
  723817
  724494
  730062
  743003
  743786
  743792
  745298
  745324
  748465
  758264
  758283
  763546
  783462
  794188
  796283
  796578
  797898
  800739
  804529
  804631
  804660
  807884
  811483
  823713
]
2.10 ms
(0.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(0.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие сиськ любительск"
]
1.53 ms
(0.12%)
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.