Query Metrics
7
Database Queries
7
Different statements
153.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.52 ms (84.18%) |
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 7196 95673 96048 96371 96963 96997 309449 341729 382049 382355 383160 383211 383641 387550 390841 395727 395981 396358 397306 397940 404952 404968 405016 405054 405061 405093 407357 409995 410930 410941 411014 411078 411681 411851 413263 413711 415081 416820 417897 417999 418478 418534 419064 419483 419517 421345 421557 429766 431412 435624 447124 451266 451548 474621 476143 478048 480504 488805 490685 494171 497560 497776 498033 506823 509809 510270 510394 511318 516449 522153 522361 526224 527464 529243 530492 530500 531239 532783 532959 533011 534041 534993 536283 536292 537902 537906 537913 540291 542591 544833 552898 554338 556421 593829 600346 601651 614730 620794 629326 634156 636286 640733 641642 650333 678128 693925 695184 699526 707315 730818 742849 747140 748528 748530 775780 776206 799284 801970 813082 813579 ] |
||||||||||||||||||||||||||||||
|
15.17 ms (9.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 506823 537913 397940 530492 474621 411681 383160 404952 413263 480504 490685 431412 498033 540291 395981 529243 96963 387550 418478 419064 522153 532959 536283 695184 410930 382049 383641 96997 404968 405061 497776 96048 405016 405054 416820 410941 813579 533011 614730 309449 411014 417897 510270 747140 620794 478048 383211 341729 96371 390841 397306 421345 411078 435624 421557 530500 531239 534041 511318 537906 526224 527464 536292 537902 542591 556421 650333 693925 634156 601651 636286 748530 801970 396358 395727 7196 407357 405093 409995 419517 488805 510394 678128 799284 629326 95673 429766 415081 476143 544833 593829 600346 742849 382355 419483 447124 413711 509809 516449 552898 748528 776206 730818 494171 532783 534993 554338 699526 640733 411851 417999 451266 497560 522361 641642 813082 707315 775780 418534 451548 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.67%) |
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 7196 95673 96048 96371 96963 96997 309449 341729 382049 382355 383160 383211 383641 387550 390841 395727 395981 396358 397306 397940 404952 404968 405016 405054 405061 405093 407357 409995 410930 410941 411014 411078 411681 411851 413263 413711 415081 416820 417897 417999 418478 418534 419064 419483 419517 421345 421557 429766 431412 435624 447124 451266 451548 474621 476143 478048 480504 488805 490685 494171 497560 497776 498033 506823 509809 510270 510394 511318 516449 522153 522361 526224 527464 529243 530492 530500 531239 532783 532959 533011 534041 534993 536283 536292 537902 537906 537913 540291 542591 544833 552898 554338 556421 593829 600346 601651 614730 620794 629326 634156 636286 640733 641642 650333 678128 693925 695184 699526 707315 730818 742849 747140 748528 748530 775780 776206 799284 801970 813082 813579 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мжм секс втро хардкор секс"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мжм жесткий трах"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мжм секс втро хардкор секс"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.