Query Metrics
7
Database Queries
7
Different statements
158.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.11 ms (83.60%) |
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 79952 187611 187643 188122 191246 210377 383833 388213 388815 390749 391550 393534 397155 401660 402137 405320 407760 410235 413307 413709 416013 416082 416094 417850 419004 420348 423521 424145 424154 434023 444501 444961 448592 448900 453668 454199 456890 458539 464109 467774 472087 475896 476340 488117 489067 489127 495007 498475 499979 505971 509079 533813 544669 545499 547793 551678 557450 560092 567735 579785 591086 595928 599732 604118 607405 614748 614753 620327 625819 635932 638292 638872 643378 663858 663877 664815 665209 665438 665873 665884 666798 667012 667484 667846 672601 673204 675990 678421 681640 687386 693421 698910 699446 709481 709861 710849 716278 717009 726817 734702 740162 740490 741729 745435 748468 754361 755403 756669 763749 765147 770185 773578 774427 785121 790625 797245 799193 812409 819032 828641 ] |
||||||||||||||||||||||||||||||
|
14.80 ms (9.36%) |
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 663858 665884 614753 604118 740162 748468 812409 191246 488117 391550 419004 828641 819032 498475 774427 499979 533813 665438 675990 698910 665209 667484 672601 681640 699446 709481 716278 664815 665873 693421 620327 607405 799193 726817 734702 763749 754361 745435 756669 765147 773578 614748 643378 717009 785121 187611 388213 475896 420348 635932 423521 467774 383833 79952 444501 678421 709861 740490 755403 625819 388815 416013 505971 489127 416094 489067 557450 448900 416082 417850 476340 454199 464109 434023 495007 188122 393534 402137 405320 407760 472087 210377 453668 458539 547793 567735 444961 424145 509079 401660 448592 410235 413709 579785 663877 667846 595928 638292 741729 770185 187643 390749 397155 413307 424154 456890 545499 551678 666798 667012 710849 687386 673204 544669 560092 638872 591086 599732 797245 790625 ] |
||||||||||||||||||||||||||||||
|
3.22 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 79952 187611 187643 188122 191246 210377 383833 388213 388815 390749 391550 393534 397155 401660 402137 405320 407760 410235 413307 413709 416013 416082 416094 417850 419004 420348 423521 424145 424154 434023 444501 444961 448592 448900 453668 454199 456890 458539 464109 467774 472087 475896 476340 488117 489067 489127 495007 498475 499979 505971 509079 533813 544669 545499 547793 551678 557450 560092 567735 579785 591086 595928 599732 604118 607405 614748 614753 620327 625819 635932 638292 638872 643378 663858 663877 664815 665209 665438 665873 665884 666798 667012 667484 667846 672601 673204 675990 678421 681640 687386 693421 698910 699446 709481 709861 710849 716278 717009 726817 734702 740162 740490 741729 745435 748468 754361 755403 756669 763749 765147 770185 773578 774427 785121 790625 797245 799193 812409 819032 828641 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde natural tits"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая натуральная натуральные сиськ без силикон"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.16%) |
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.