Query Metrics
7
Database Queries
7
Different statements
274.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
252.25 ms (91.89%) |
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 120998 181569 187450 387026 413277 414077 428231 429867 439797 443171 452250 453394 455132 456377 457541 460446 465985 466911 467029 468514 469164 469393 473439 476311 484241 499365 499383 499549 500292 510950 513531 516718 516807 518201 518598 519760 524612 529370 529943 529988 533281 533884 540118 545971 545982 548483 553224 555055 555174 556338 558179 560456 573168 587781 588414 588429 591476 596913 604426 604823 604883 605742 607690 613576 614182 614827 617812 628112 630068 636651 639071 643084 643542 657782 662876 668701 669046 681237 704907 709654 710415 714378 728469 733582 741688 742358 742410 742417 744170 744201 744208 744797 748504 752703 752767 758348 760549 766415 770123 770157 770207 770244 776404 776831 780653 781849 782806 785972 796816 796843 799049 799638 800307 800341 804234 811242 812564 816169 819238 825751 ] |
||||||||||||||||||||||||||||||
|
12.99 ms (4.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 770157 710415 811242 187450 545982 613576 457541 558179 500292 518598 516718 456377 516807 499383 519760 465985 518201 556338 605742 467029 413277 455132 524612 439797 529943 533884 469164 681237 657782 587781 555055 825751 758348 387026 499549 662876 428231 588414 414077 429867 604426 453394 604883 466911 668701 604823 639071 643084 643542 782806 785972 799049 800307 804234 796843 812564 733582 766415 742417 770123 728469 752767 704907 781849 484241 513531 510950 819238 452250 476311 545971 669046 714378 553224 617812 780653 796816 748504 752703 741688 742410 742358 709654 468514 469393 460446 555174 614827 473439 499365 443171 529370 529988 120998 181569 816169 533281 548483 560456 573168 614182 588429 596913 607690 630068 636651 591476 799638 776404 776831 744170 744201 744208 744797 770207 770244 760549 628112 800341 540118 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (0.91%) |
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 120998 181569 187450 387026 413277 414077 428231 429867 439797 443171 452250 453394 455132 456377 457541 460446 465985 466911 467029 468514 469164 469393 473439 476311 484241 499365 499383 499549 500292 510950 513531 516718 516807 518201 518598 519760 524612 529370 529943 529988 533281 533884 540118 545971 545982 548483 553224 555055 555174 556338 558179 560456 573168 587781 588414 588429 591476 596913 604426 604823 604883 605742 607690 613576 614182 614827 617812 628112 630068 636651 639071 643084 643542 657782 662876 668701 669046 681237 704907 709654 710415 714378 728469 733582 741688 742358 742410 742417 744170 744201 744208 744797 748504 752703 752767 758348 760549 766415 770123 770157 770207 770244 776404 776831 780653 781849 782806 785972 796816 796843 799049 799638 800307 800341 804234 811242 812564 816169 819238 825751 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stockings mature solo"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"чулк нижн бел mature соло"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.57%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чулк нижн бел mature соло"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.54%) |
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.