Query Metrics
7
Database Queries
7
Different statements
207.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
182.98 ms (88.23%) |
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 11393 387544 389966 400935 401282 404845 410060 413484 419035 420761 421204 424226 424646 426547 432120 439156 441110 443236 444921 445646 445873 445903 446130 448350 452305 453355 453825 456480 463933 464202 464901 465237 466027 467728 470120 470403 472299 474597 475071 476527 478702 479212 483135 483443 485086 490856 492177 497941 499503 499628 504482 505642 505977 511622 513435 513874 515125 519083 519145 521885 521931 523541 527281 528899 532380 537846 538653 540595 543013 545747 548080 548304 560638 561603 564272 565346 565426 566325 566996 567757 568017 569159 569740 571144 589573 590560 590620 594897 596120 596808 596872 597969 598042 598839 603215 605414 605762 610931 615748 619811 624484 631972 636554 660109 670190 677698 681189 690785 695171 706924 709316 721967 724816 770784 775241 787488 810826 811152 814665 815077 ] |
||||||||||||||||||||||||||||||
|
15.50 ms (7.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 815077 787488 770784 811152 11393 490856 548080 624484 413484 475071 538653 566996 610931 410060 424226 513874 483135 527281 445903 485086 631972 598042 605762 706924 441110 439156 470403 478702 453825 470120 464202 497941 523541 564272 681189 560638 596808 465237 401282 420761 519083 504482 569159 567757 400935 448350 453355 464901 466027 521885 537846 566325 571144 660109 597969 424646 463933 446130 474597 419035 467728 483443 499503 545747 589573 404845 532380 472299 387544 443236 445873 505977 810826 709316 479212 499628 590560 677698 521931 444921 540595 543013 565346 670190 690785 605414 590620 615748 445646 456480 452305 569740 619811 426547 519145 505642 598839 515125 528899 594897 548304 596872 389966 432120 814665 476527 513435 561603 695171 565426 596120 603215 636554 721967 775241 421204 511622 492177 568017 724816 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.16%) |
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 11393 387544 389966 400935 401282 404845 410060 413484 419035 420761 421204 424226 424646 426547 432120 439156 441110 443236 444921 445646 445873 445903 446130 448350 452305 453355 453825 456480 463933 464202 464901 465237 466027 467728 470120 470403 472299 474597 475071 476527 478702 479212 483135 483443 485086 490856 492177 497941 499503 499628 504482 505642 505977 511622 513435 513874 515125 519083 519145 521885 521931 523541 527281 528899 532380 537846 538653 540595 543013 545747 548080 548304 560638 561603 564272 565346 565426 566325 566996 567757 568017 569159 569740 571144 589573 590560 590620 594897 596120 596808 596872 597969 598042 598839 603215 605414 605762 610931 615748 619811 624484 631972 636554 660109 670190 677698 681189 690785 695171 706924 709316 721967 724816 770784 775241 787488 810826 811152 814665 815077 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public anal hard"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц анал hard"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.27 ms (0.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на улиц анал hard"
]
|
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.