Query Metrics
7
Database Queries
7
Different statements
295.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
271.20 ms (91.64%) |
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 13428 29295 34104 38857 182340 231260 335993 386990 396029 397365 398928 400050 400524 402425 412551 413702 418013 424043 424238 424528 426647 432374 432518 441928 442463 450046 458662 460319 463403 472624 473113 475956 476799 505135 509673 511314 514001 515621 520850 526831 528322 529340 533715 534419 537097 544024 552754 560957 563409 567248 574768 576686 577315 580329 585550 588334 588600 592810 592994 595762 603359 606040 606087 610697 613304 622416 635615 639127 650749 663281 672821 675085 687307 695544 696914 698882 706640 710337 714316 716119 718054 718878 719028 731544 738325 742457 747308 750195 751321 752842 754303 754756 755897 756522 759160 761247 769467 770107 777659 779495 780771 784510 785327 789259 791029 791455 792002 793944 795612 806596 807582 810096 814309 814438 814765 824138 824450 828451 828819 ] |
||||||||||||||||||||||||||||||
|
15.63 ms (5.28%) |
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 755897 769467 754303 731544 780771 789259 791029 182340 412551 606087 386990 580329 511314 828819 675085 622416 400050 398928 460319 526831 814438 650749 706640 806596 784510 751321 752842 750195 785327 544024 574768 432374 418013 718054 807582 441928 560957 754756 473113 396029 413702 463403 585550 595762 613304 472624 505135 588600 635615 458662 426647 475956 476799 520850 515621 402425 610697 537097 759160 424528 824138 824450 828081 231260 335993 38857 828451 810096 397365 528322 29295 814765 533715 534419 577315 672821 695544 698882 714316 719028 663281 687307 696914 552754 588334 779495 795612 793944 770107 738325 747308 742457 761247 639127 710337 716119 777659 567248 576686 592810 814309 718878 792002 791455 756522 606040 432518 400524 442463 424043 563409 603359 592994 34104 514001 509673 13428 424238 450046 529340 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (1.00%) |
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 13428 29295 34104 38857 182340 231260 335993 386990 396029 397365 398928 400050 400524 402425 412551 413702 418013 424043 424238 424528 426647 432374 432518 441928 442463 450046 458662 460319 463403 472624 473113 475956 476799 505135 509673 511314 514001 515621 520850 526831 528322 529340 533715 534419 537097 544024 552754 560957 563409 567248 574768 576686 577315 580329 585550 588334 588600 592810 592994 595762 603359 606040 606087 610697 613304 622416 635615 639127 650749 663281 672821 675085 687307 695544 696914 698882 706640 710337 714316 716119 718054 718878 719028 731544 738325 742457 747308 750195 751321 752842 754303 754756 755897 756522 759160 761247 769467 770107 777659 779495 780771 784510 785327 789259 791029 791455 792002 793944 795612 806596 807582 810096 814309 814438 814765 824138 824450 828451 828819 ] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.55%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.53%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чулк нижн бел леопардов трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в чулках и леопардовых трусах"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.47%) |
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.