Query Metrics
7
Database Queries
7
Different statements
160.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.72 ms (83.14%) |
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 13767 383387 396540 397548 399773 418359 420576 421432 426548 428891 435844 440963 446061 447780 448401 450941 453068 454913 455020 456883 456894 457041 457578 457674 457735 457744 457770 457781 457783 457791 457983 470509 471811 472930 473289 478690 481557 483263 483754 485674 486408 495459 503308 504687 504909 507327 517384 518027 518643 523047 523053 523072 524601 526086 527561 527603 528692 532361 534540 534612 535008 535391 539353 544604 544956 556001 557595 559016 562364 563535 566619 568193 569618 576480 577678 580710 590722 593008 598921 613629 619822 621342 624460 634345 634432 634463 644198 644218 644585 661004 671893 680931 680977 687664 693624 695398 703494 710400 714033 714049 714056 721882 722038 722109 728068 728713 735640 738440 738909 738951 752148 761143 761157 768663 793024 803684 803839 810627 819063 819434 ] |
||||||||||||||||||||||||||||||
|
16.59 ms (10.31%) |
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 454913 563535 457781 457735 517384 534612 661004 518643 457674 478690 619822 703494 695398 470509 420576 735640 544604 457744 523053 527603 680931 687664 714033 722109 810627 722038 483754 485674 507327 457783 456883 504687 693624 644218 580710 644198 624460 590722 523047 544956 421432 738909 471811 557595 728068 473289 593008 448401 523072 721882 680977 634345 495459 556001 518027 613629 803684 566619 486408 435844 457770 568193 504909 457578 418359 535391 634432 803839 761157 450941 738440 738951 447780 383387 456894 671893 768663 440963 524601 569618 559016 752148 426548 539353 483263 532361 621342 562364 819434 399773 535008 528692 576480 457983 728713 527561 534540 577678 793024 598921 397548 472930 526086 714049 634463 710400 457791 396540 481557 714056 428891 13767 819063 455020 446061 457041 453068 644585 761143 503308 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (2.03%) |
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 13767 383387 396540 397548 399773 418359 420576 421432 426548 428891 435844 440963 446061 447780 448401 450941 453068 454913 455020 456883 456894 457041 457578 457674 457735 457744 457770 457781 457783 457791 457983 470509 471811 472930 473289 478690 481557 483263 483754 485674 486408 495459 503308 504687 504909 507327 517384 518027 518643 523047 523053 523072 524601 526086 527561 527603 528692 532361 534540 534612 535008 535391 539353 544604 544956 556001 557595 559016 562364 563535 566619 568193 569618 576480 577678 580710 590722 593008 598921 613629 619822 621342 624460 634345 634432 634463 644198 644218 644585 661004 671893 680931 680977 687664 693624 695398 703494 710400 714033 714049 714056 721882 722038 722109 728068 728713 735640 738440 738909 738951 752148 761143 761157 768663 793024 803684 803839 810627 819063 819434 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beach public blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пляж природ на улиц минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.03%) |
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.