Query Metrics
7
Database Queries
7
Different statements
180.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.61 ms (86.34%) |
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 41516 79388 95700 95788 155198 331119 382460 383564 385341 387221 387295 388713 391150 395147 396722 396730 397074 399355 401203 405848 406350 407515 411052 411684 415942 419342 420614 421967 423790 430549 432562 432680 443340 448855 450065 453373 456902 462610 463953 464451 465125 466460 467568 473010 479472 488383 488797 500197 501591 517870 531225 533490 536182 536186 539570 540461 552704 558581 560292 560456 565965 580329 581580 590850 591067 591582 596895 597197 603387 605145 613932 617800 624803 630288 634163 634711 636326 644961 665204 665826 674978 675123 675645 675723 676463 681637 684106 710937 716223 719858 722520 722552 730715 737305 744993 755387 757402 757974 766546 769476 774606 780710 782538 783038 783048 783693 784078 788364 796650 796723 797383 802343 811477 811604 812759 813444 814654 817469 823386 823929 ] |
||||||||||||||||||||||||||||||
|
14.23 ms (7.90%) |
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 823386 539570 719858 665826 797383 774606 811604 613932 155198 560292 382460 95700 405848 634711 757402 580329 391150 675123 488383 443340 432680 432562 399355 415942 466460 533490 540461 796650 730715 757974 811477 769476 464451 783048 630288 420614 684106 710937 784078 385341 453373 536182 423790 465125 41516 488797 388713 591067 591582 500197 421967 634163 590850 676463 479472 681637 581580 558581 796723 665204 675723 396722 387221 552704 411684 782538 462610 406350 463953 501591 536186 560456 722552 716223 605145 813444 783038 744993 737305 780710 783693 817469 814654 823929 448855 675645 565965 624803 766546 802343 411052 407515 395147 467568 383564 331119 79388 430549 419342 456902 450065 603387 596895 517870 644961 531225 674978 597197 401203 473010 95788 387295 396730 397074 722520 788364 812759 755387 617800 636326 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.56%) |
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 41516 79388 95700 95788 155198 331119 382460 383564 385341 387221 387295 388713 391150 395147 396722 396730 397074 399355 401203 405848 406350 407515 411052 411684 415942 419342 420614 421967 423790 430549 432562 432680 443340 448855 450065 453373 456902 462610 463953 464451 465125 466460 467568 473010 479472 488383 488797 500197 501591 517870 531225 533490 536182 536186 539570 540461 552704 558581 560292 560456 565965 580329 581580 590850 591067 591582 596895 597197 603387 605145 613932 617800 624803 630288 634163 634711 636326 644961 665204 665826 674978 675123 675645 675723 676463 681637 684106 710937 716223 719858 722520 722552 730715 737305 744993 755387 757402 757974 766546 769476 774606 780710 782538 783038 783048 783693 784078 788364 796650 796723 797383 802343 811477 811604 812759 813444 814654 817469 823386 823929 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"black чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"black чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"black stockings"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.