Query Metrics
7
Database Queries
7
Different statements
156.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.37 ms (85.11%) |
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 9938 72305 181569 187286 384066 384988 389616 391932 392679 395146 395644 395668 409374 412000 412992 449896 451500 477550 491360 516679 531377 531548 533281 536731 538935 541402 544792 548483 549312 551756 553301 555038 579308 588229 589903 591476 592535 599271 603200 606417 609967 618759 619637 628600 630068 645928 663486 663902 664290 665038 665477 667254 667855 668174 668680 669744 670479 670493 694023 697473 714191 715536 715547 715589 720493 720515 720608 720610 721496 726119 726149 726808 728150 729091 730339 730484 733542 738957 740117 744170 744201 744208 744797 755369 760549 765215 770177 770207 770244 772549 772879 772883 775826 776404 781963 785434 785932 789325 793664 798081 799141 799638 800345 800347 803357 808518 810130 811351 815040 815573 816495 817290 818509 818643 818666 818768 818773 819606 824353 824572 ] |
||||||||||||||||||||||||||||||
|
13.68 ms (8.73%) |
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 392679 664290 785932 816495 818768 531548 544792 553301 549312 663902 720493 589903 592535 799141 811351 798081 730484 770177 726808 772879 800345 187286 384066 409374 516679 451500 395146 389616 818643 645928 715589 697473 721496 720515 599271 803357 789325 740117 755369 772883 772549 785434 808518 384988 181569 391932 395644 395668 72305 9938 412992 412000 815040 817290 824353 815573 818666 818509 818773 819606 824572 477550 491360 449896 533281 538935 531377 536731 548483 551756 555038 579308 541402 665038 667855 668680 715547 663486 668174 694023 720610 665477 667254 669744 670479 670493 714191 606417 609967 588229 619637 628600 630068 591476 603200 618759 781963 799638 810130 776404 800347 726119 729091 744170 744201 744208 744797 793664 728150 770207 770244 765215 726149 730339 733542 738957 760549 715536 720608 775826 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.62%) |
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 9938 72305 181569 187286 384066 384988 389616 391932 392679 395146 395644 395668 409374 412000 412992 449896 451500 477550 491360 516679 531377 531548 533281 536731 538935 541402 544792 548483 549312 551756 553301 555038 579308 588229 589903 591476 592535 599271 603200 606417 609967 618759 619637 628600 630068 645928 663486 663902 664290 665038 665477 667254 667855 668174 668680 669744 670479 670493 694023 697473 714191 715536 715547 715589 720493 720515 720608 720610 721496 726119 726149 726808 728150 729091 730339 730484 733542 738957 740117 744170 744201 744208 744797 755369 760549 765215 770177 770207 770244 772549 772879 772883 775826 776404 781963 785434 785932 789325 793664 798081 799141 799638 800345 800347 803357 808518 810130 811351 815040 815573 816495 817290 818509 818643 818666 818768 818773 819606 824353 824572 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature stockings"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.07%) |
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.