Query Metrics
7
Database Queries
7
Different statements
213.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
186.28 ms (87.19%) |
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 28294 34830 177455 365933 385162 387074 396557 406831 408024 418359 420576 420651 420882 445197 447363 447656 449695 450343 450794 450941 452578 453037 454913 455804 455805 456688 456859 456896 457578 457674 457728 457735 457750 457770 457781 457783 457784 458914 464295 468385 470509 471196 471811 476489 478690 485674 486408 488459 488539 498143 498497 500508 517384 523053 527603 528692 530152 550714 551191 553493 554351 557595 560013 563535 563690 566619 569923 578103 579768 590188 593008 598648 600736 619822 623660 624600 628301 628772 634372 651325 665227 670526 671893 672181 674514 677267 680947 684181 685513 693244 697008 697026 698063 703093 703494 708775 714053 714743 720382 720481 724126 728088 732913 733153 734071 738440 768663 770164 774339 779618 781930 784804 785513 793175 796248 797749 805287 809737 813292 813494 ] |
||||||||||||||||||||||||||||||
|
16.36 ms (7.66%) |
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 624600 445197 455804 420651 530152 677267 34830 551191 579768 578103 813494 406831 569923 720382 724126 28294 550714 698063 680947 628772 728088 770164 781930 563535 590188 628301 457750 488539 714053 797749 684181 457728 672181 720481 674514 468385 385162 703093 708775 553493 796248 600736 450794 452578 734071 733153 456859 498497 476489 685513 634372 805287 697008 785513 408024 365933 464295 447363 693244 670526 563690 809737 387074 457674 456688 498143 457784 471196 455805 447656 488459 458914 449695 456896 598648 651325 732913 623660 593008 457781 457735 560013 517384 470509 420576 557595 454913 177455 779618 665227 478690 619822 813292 420882 554351 774339 703494 453037 671893 486408 450343 457770 457783 793175 738440 471811 528692 768663 450941 566619 418359 500508 697026 784804 457578 523053 527603 396557 485674 714743 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.19%) |
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 28294 34830 177455 365933 385162 387074 396557 406831 408024 418359 420576 420651 420882 445197 447363 447656 449695 450343 450794 450941 452578 453037 454913 455804 455805 456688 456859 456896 457578 457674 457728 457735 457750 457770 457781 457783 457784 458914 464295 468385 470509 471196 471811 476489 478690 485674 486408 488459 488539 498143 498497 500508 517384 523053 527603 528692 530152 550714 551191 553493 554351 557595 560013 563535 563690 566619 569923 578103 579768 590188 593008 598648 600736 619822 623660 624600 628301 628772 634372 651325 665227 670526 671893 672181 674514 677267 680947 684181 685513 693244 697008 697026 698063 703093 703494 708775 714053 714743 720382 720481 724126 728088 732913 733153 734071 738440 768663 770164 774339 779618 781930 784804 785513 793175 796248 797749 805287 809737 813292 813494 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beach blowjob"
]
|
||||||||||||||||||||||||||||||
|
2.32 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пляж природ минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.74%) |
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.