Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
233.47 ms
(90.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
  4510
  47079
  78760
  79683
  224590
  233862
  271093
  351650
  383477
  386389
  386940
  389859
  390521
  391575
  397502
  398105
  398331
  407159
  434465
  453591
  476470
  483839
  489260
  490519
  493250
  497372
  501998
  511943
  514211
  518477
  526338
  534507
  537403
  540745
  541157
  547950
  554581
  558954
  558988
  559497
  568892
  569626
  571433
  575238
  579029
  580004
  580050
  590555
  590582
  593691
  600768
  601437
  610473
  610880
  610893
  614617
  615185
  624960
  625283
  628203
  628213
  632882
  634588
  639911
  646980
  651746
  651795
  655457
  657800
  661618
  667168
  676767
  680786
  683478
  683649
  685432
  687717
  689266
  695454
  697549
  701894
  708326
  711052
  711071
  715844
  717118
  726313
  735029
  735362
  736643
  738222
  738341
  740835
  749882
  754700
  754742
  757740
  762737
  762740
  764667
  765028
  767972
  777511
  777808
  778136
  779583
  779735
  782325
  786576
  787598
  790299
  791168
  792255
  792349
  793174
  798619
  799851
  802015
  802341
  810548
]
15.18 ms
(5.86%)
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
  632882
  434465
  676767
  490519
  79683
  554581
  501998
  489260
  569626
  541157
  4510
  453591
  625283
  386389
  736643
  762737
  782325
  540745
  600768
  792255
  754742
  779735
  657800
  526338
  593691
  386940
  534507
  661618
  701894
  695454
  575238
  610880
  792349
  738341
  610893
  78760
  579029
  777511
  735362
  518477
  497372
  646980
  493250
  651746
  407159
  558988
  624960
  639911
  590582
  802341
  790299
  726313
  711052
  711071
  777808
  383477
  483839
  547950
  778136
  786576
  793174
  738222
  791168
  754700
  762740
  224590
  634588
  683649
  651795
  787598
  390521
  47079
  601437
  397502
  511943
  717118
  715844
  708326
  628213
  614617
  799851
  271093
  398331
  559497
  558954
  689266
  667168
  697549
  580004
  580050
  757740
  389859
  610473
  767972
  740835
  391575
  735029
  764667
  398105
  514211
  571433
  655457
  351650
  568892
  810548
  615185
  537403
  687717
  685432
  628203
  590555
  802015
  779583
  765028
  749882
  798619
  233862
  476470
  680786
  683478
]
3.50 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
  4510
  47079
  78760
  79683
  224590
  233862
  271093
  351650
  383477
  386389
  386940
  389859
  390521
  391575
  397502
  398105
  398331
  407159
  434465
  453591
  476470
  483839
  489260
  490519
  493250
  497372
  501998
  511943
  514211
  518477
  526338
  534507
  537403
  540745
  541157
  547950
  554581
  558954
  558988
  559497
  568892
  569626
  571433
  575238
  579029
  580004
  580050
  590555
  590582
  593691
  600768
  601437
  610473
  610880
  610893
  614617
  615185
  624960
  625283
  628203
  628213
  632882
  634588
  639911
  646980
  651746
  651795
  655457
  657800
  661618
  667168
  676767
  680786
  683478
  683649
  685432
  687717
  689266
  695454
  697549
  701894
  708326
  711052
  711071
  715844
  717118
  726313
  735029
  735362
  736643
  738222
  738341
  740835
  749882
  754700
  754742
  757740
  762737
  762740
  764667
  765028
  767972
  777511
  777808
  778136
  779583
  779735
  782325
  786576
  787598
  790299
  791168
  792255
  792349
  793174
  798619
  799851
  802015
  802341
  810548
]
2.04 ms
(0.79%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс рот"
]
1.95 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ебут рот"
]
1.58 ms
(0.61%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.39 ms
(0.54%)
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.