Query Metrics
7
Database Queries
7
Different statements
178.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.60 ms (85.41%) |
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 368196 417737 433137 433164 445092 447514 451625 452568 452905 462658 465918 472272 486145 488234 519202 530755 532806 533813 534482 536085 537302 538721 545990 553170 554076 557547 565952 568271 575315 579455 581255 588278 590982 591085 591781 593545 594194 594218 594232 594235 595316 598044 606324 609864 612243 620399 624464 626261 636032 636037 640108 641794 652749 661959 662783 662900 664245 664472 666728 668154 681876 683272 685618 692008 693026 693539 696086 697452 699416 703052 712027 712421 718884 720820 722619 725343 726747 732433 736454 737375 737387 740889 744942 746038 746478 746954 748322 750124 750278 750982 752416 763406 767231 768398 769202 771041 771200 774702 775408 778294 778346 778347 782410 784309 784403 791198 793449 793902 795893 796920 798177 801268 804170 805545 810671 810709 810952 814398 814711 823433 ] |
||||||||||||||||||||||||||||||
|
15.13 ms (8.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 720820 545990 588278 591781 609864 805545 775408 793902 810671 752416 784309 793449 795893 810952 725343 771200 763406 736454 767231 750124 750278 640108 703052 774702 778346 778347 796920 804170 451625 433137 823433 814398 814711 532806 534482 538721 536085 519202 533813 486145 568271 581255 553170 557547 579455 664245 664472 712027 718884 652749 661959 666728 668154 699416 722619 662900 685618 692008 697452 590982 636032 593545 595316 624464 591085 594218 594232 606324 784403 791198 801268 778294 726747 737375 748322 769202 782410 732433 746478 746954 750982 768398 737387 740889 746038 771041 636037 810709 368196 472272 452568 565952 433164 447514 530755 537302 488234 575315 554076 681876 662783 693539 696086 641794 594235 612243 744942 626261 445092 452905 462658 465918 417737 598044 712421 683272 693026 620399 594194 798177 ] |
||||||||||||||||||||||||||||||
|
3.73 ms (2.09%) |
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 368196 417737 433137 433164 445092 447514 451625 452568 452905 462658 465918 472272 486145 488234 519202 530755 532806 533813 534482 536085 537302 538721 545990 553170 554076 557547 565952 568271 575315 579455 581255 588278 590982 591085 591781 593545 594194 594218 594232 594235 595316 598044 606324 609864 612243 620399 624464 626261 636032 636037 640108 641794 652749 661959 662783 662900 664245 664472 666728 668154 681876 683272 685618 692008 693026 693539 696086 697452 699416 703052 712027 712421 718884 720820 722619 725343 726747 732433 736454 737375 737387 740889 744942 746038 746478 746954 748322 750124 750278 750982 752416 763406 767231 768398 769202 771041 771200 774702 775408 778294 778346 778347 782410 784309 784403 791198 793449 793902 795893 796920 798177 801268 804170 805545 810671 810709 810952 814398 814711 823433 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen saggy tits"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen saggy сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen saggy сиськ"
]
|
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.