Query Metrics
7
Database Queries
7
Different statements
292.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
264.10 ms (90.30%) |
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 395291 396635 398426 405947 411433 414651 418009 418268 419061 419758 422340 437363 437810 437864 440625 441623 445471 445672 447810 447896 448097 449323 452036 452828 453369 457803 461086 466772 467868 468614 471118 477483 481789 491678 499105 501611 503405 507123 509024 510396 512285 512471 514070 515603 516291 518848 521581 523131 524508 525669 526659 527415 528384 530624 530625 530627 532676 534268 534850 535019 535057 537204 537863 544825 550397 560198 560203 560350 562491 569223 570704 595061 599836 600014 601162 601529 601535 603685 603954 604060 612061 615774 617410 619446 624480 627722 633780 634784 635234 636321 637003 639798 640772 642000 648853 653487 656568 674368 674953 676641 678066 679774 714125 719146 738877 740862 749153 750592 765680 793926 804464 811497 813794 814031 815017 817888 820150 823255 826408 827099 ] |
||||||||||||||||||||||||||||||
|
18.93 ms (6.47%) |
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 604060 468614 562491 674368 811497 601535 804464 603954 793926 750592 437363 396635 405947 441623 449323 448097 499105 509024 530627 535057 526659 534268 560198 653487 595061 615774 627722 635234 411433 512285 813794 398426 437810 447896 503405 516291 535019 537204 544825 648853 676641 601529 521581 422340 452036 453369 518848 523131 527415 530624 534850 481789 678066 636321 642000 619446 624480 467868 471118 466772 461086 525669 501611 826408 820150 719146 740862 550397 560350 601162 447810 445672 510396 524508 537863 560203 570704 639798 634784 514070 765680 749153 817888 823255 827099 507123 714125 738877 600014 418268 457803 395291 414651 418009 419061 814031 815017 452828 515603 530625 532676 528384 477483 569223 656568 674953 633780 599836 603685 640772 612061 617410 419758 437864 491678 512471 440625 679774 637003 445471 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (0.97%) |
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 395291 396635 398426 405947 411433 414651 418009 418268 419061 419758 422340 437363 437810 437864 440625 441623 445471 445672 447810 447896 448097 449323 452036 452828 453369 457803 461086 466772 467868 468614 471118 477483 481789 491678 499105 501611 503405 507123 509024 510396 512285 512471 514070 515603 516291 518848 521581 523131 524508 525669 526659 527415 528384 530624 530625 530627 532676 534268 534850 535019 535057 537204 537863 544825 550397 560198 560203 560350 562491 569223 570704 595061 599836 600014 601162 601529 601535 603685 603954 604060 612061 615774 617410 619446 624480 627722 633780 634784 635234 636321 637003 639798 640772 642000 648853 653487 656568 674368 674953 676641 678066 679774 714125 719146 738877 740862 749153 750592 765680 793926 804464 811497 813794 814031 815017 817888 820150 823255 826408 827099 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"licking squirt"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.58%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.56%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.52%) |
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.