Query Metrics
7
Database Queries
7
Different statements
171.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.83 ms (83.87%) |
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 392822 396453 397834 407434 416407 417854 424280 426771 426939 427004 427315 427573 428798 430003 434623 434650 436732 437343 444860 445306 446918 447018 447800 451056 452175 453779 453897 456234 460033 460185 462524 463771 464273 472452 476375 477042 480963 483233 484499 489099 490755 493268 494323 504770 507586 508298 509816 514891 515893 516348 518231 518944 519735 519782 522062 522751 523752 526038 537549 544090 549596 551479 555628 562868 564855 565043 565682 567398 569879 571700 571799 571805 573939 574030 574840 578585 579332 580269 603800 603868 605403 605889 614589 618761 649246 652258 678766 684997 692945 698045 700849 709228 713938 721068 721431 726572 728172 732051 739327 740051 740932 744462 744860 756848 759723 766036 766413 766890 767235 776716 777260 790365 792406 793915 793997 796211 797905 802274 805819 810521 ] |
||||||||||||||||||||||||||||||
|
16.59 ms (9.67%) |
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 767235 792406 732051 766890 744462 603868 796211 805819 424280 434623 407434 396453 426771 446918 493268 464273 544090 555628 565682 571799 447800 416407 519735 523752 508298 397834 427573 453779 477042 452175 514891 460185 571805 713938 678766 700849 692945 565043 614589 605403 618761 790365 793915 777260 739327 740051 740932 793997 759723 766036 726572 756848 802274 434650 426939 436732 427004 483233 519782 522062 445306 573939 564855 476375 509816 518231 484499 515893 430003 456234 490755 453897 480963 537549 507586 522751 516348 518944 526038 504770 569879 549596 579332 551479 562868 574030 580269 649246 652258 721068 684997 709228 567398 571700 574840 578585 605889 603800 810521 766413 797905 728172 744860 698045 721431 776716 427315 417854 460033 489099 494323 392822 428798 444860 437343 462524 463771 472452 447018 451056 ] |
||||||||||||||||||||||||||||||
|
3.51 ms (2.04%) |
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 392822 396453 397834 407434 416407 417854 424280 426771 426939 427004 427315 427573 428798 430003 434623 434650 436732 437343 444860 445306 446918 447018 447800 451056 452175 453779 453897 456234 460033 460185 462524 463771 464273 472452 476375 477042 480963 483233 484499 489099 490755 493268 494323 504770 507586 508298 509816 514891 515893 516348 518231 518944 519735 519782 522062 522751 523752 526038 537549 544090 549596 551479 555628 562868 564855 565043 565682 567398 569879 571700 571799 571805 573939 574030 574840 578585 579332 580269 603800 603868 605403 605889 614589 618761 649246 652258 678766 684997 692945 698045 700849 709228 713938 721068 721431 726572 728172 732051 739327 740051 740932 744462 744860 756848 759723 766036 766413 766890 767235 776716 777260 790365 792406 793915 793997 796211 797905 802274 805819 810521 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sleeping fucked"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"спящ fucked"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"спящ fucked"
]
|
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.