Query Metrics
7
Database Queries
7
Different statements
138.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
113.76 ms (81.90%) |
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 423804 431741 435529 435548 438607 438615 440851 442431 443958 445767 447934 453585 455356 456597 456649 456752 457023 457383 461860 465439 478157 479389 480328 500616 503819 506136 506240 506822 507249 507625 510773 518883 522285 526084 528058 529048 529931 529976 532523 534103 534114 535037 535745 535855 536381 537472 542095 551523 553505 554614 558336 560046 560382 563605 572675 573369 579381 579405 579448 579451 579611 582437 583575 584476 586965 588736 590335 592571 592930 593873 595006 605263 606556 613172 613635 614059 622826 622829 625435 634305 660048 666420 667966 668083 670272 670383 672812 672878 677098 682336 691462 692750 693961 700733 706249 708643 714026 714117 720277 730953 732964 733681 741219 751510 751576 751611 751870 752148 761291 772941 774994 775708 778670 781873 795084 800895 803292 808293 811084 ] |
||||||||||||||||||||||||||||||
|
14.58 ms (10.50%) |
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 457383 456597 457023 500616 506822 510773 522285 529048 529976 534103 529931 534114 535855 503819 506136 507249 526084 528058 532523 535037 535745 536381 537472 465439 551523 558336 560046 579381 579405 579451 582437 583575 542095 563605 573369 579448 584476 560382 660048 666420 668083 682336 692750 706249 667966 670383 714117 720277 670272 672812 672878 677098 691462 693961 700733 553505 554614 572675 579611 586965 592930 595006 622826 588736 590335 592571 605263 613172 625435 606556 614059 622829 593873 634305 775708 781873 774994 795084 803292 751576 751611 808293 811084 741219 772941 732964 733681 751870 724357 730953 751510 752148 761291 613635 708643 714026 778670 800895 438607 438615 445767 453585 456752 435529 435548 440851 479389 423804 431741 443958 456649 480328 447934 461860 442431 455356 478157 518883 506240 507625 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.86%) |
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 423804 431741 435529 435548 438607 438615 440851 442431 443958 445767 447934 453585 455356 456597 456649 456752 457023 457383 461860 465439 478157 479389 480328 500616 503819 506136 506240 506822 507249 507625 510773 518883 522285 526084 528058 529048 529931 529976 532523 534103 534114 535037 535745 535855 536381 537472 542095 551523 553505 554614 558336 560046 560382 563605 572675 573369 579381 579405 579448 579451 579611 582437 583575 584476 586965 588736 590335 592571 592930 593873 595006 605263 606556 613172 613635 614059 622826 622829 625435 634305 660048 666420 667966 668083 670272 670383 672812 672878 677098 682336 691462 692750 693961 700733 706249 708643 714026 714117 720277 730953 732964 733681 741219 751510 751576 751611 751870 752148 761291 772941 774994 775708 778670 781873 795084 800895 803292 808293 811084 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife porn"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен porn"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.38%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен porn"
]
|
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.