Query Metrics
7
Database Queries
7
Different statements
163.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.50 ms (81.74%) |
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 181043 376405 398619 404024 412832 412984 417838 420064 420816 421874 425141 427709 432568 432699 432706 432731 433614 435592 442980 443210 444281 446055 446562 446872 452183 454149 455878 456224 457524 461038 463870 464156 464262 464794 468114 468124 468380 472895 479253 485644 489317 493066 493325 493781 503241 510104 511955 513847 514956 518506 520419 521137 521664 527761 530146 531279 535437 547563 549009 549821 552285 565896 566788 570906 573337 579965 590473 591324 592206 592410 593236 598822 602400 614557 614696 616910 619857 626887 628518 640526 670024 676655 686185 697473 704192 716055 720098 720123 724483 729955 734456 740515 742588 757938 759882 759926 761531 762083 762411 765728 771763 772549 773424 779711 788826 794361 796296 796504 796699 796963 797738 798572 798725 802053 802571 806928 810274 810308 827038 827996 ] |
||||||||||||||||||||||||||||||
|
20.13 ms (12.33%) |
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 404024 716055 425141 531279 552285 592410 454149 376405 442980 468380 570906 614696 616910 464262 802053 757938 759926 742588 427709 511955 432699 676655 446872 493781 686185 412832 464156 398619 521137 518506 724483 181043 420816 435592 535437 461038 513847 463870 565896 827038 779711 802571 771763 796504 472895 521664 446055 432731 417838 432568 464794 549821 626887 591324 493325 489317 456224 514956 503241 510104 573337 598822 443210 827996 527761 720098 720123 697473 704192 628518 640526 619857 788826 798572 798725 796699 810274 734456 761531 806928 759882 729955 762083 772549 794361 797738 432706 530146 547563 592206 420064 412984 444281 520419 579965 566788 590473 614557 421874 455878 493066 485644 549009 670024 796296 765728 796963 740515 762411 773424 602400 810308 433614 457524 593236 468124 468114 452183 446562 479253 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.52%) |
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 181043 376405 398619 404024 412832 412984 417838 420064 420816 421874 425141 427709 432568 432699 432706 432731 433614 435592 442980 443210 444281 446055 446562 446872 452183 454149 455878 456224 457524 461038 463870 464156 464262 464794 468114 468124 468380 472895 479253 485644 489317 493066 493325 493781 503241 510104 511955 513847 514956 518506 520419 521137 521664 527761 530146 531279 535437 547563 549009 549821 552285 565896 566788 570906 573337 579965 590473 591324 592206 592410 593236 598822 602400 614557 614696 616910 619857 626887 628518 640526 670024 676655 686185 697473 704192 716055 720098 720123 724483 729955 734456 740515 742588 757938 759882 759926 761531 762083 762411 765728 771763 772549 773424 779711 788826 794361 796296 796504 796699 796963 797738 798572 798725 802053 802571 806928 810274 810308 827038 827996 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal no panties"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.90%) |
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.