Query Metrics
7
Database Queries
7
Different statements
161.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.64 ms (82.01%) |
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 69950 327170 384416 388543 392790 393865 395699 400166 405485 405507 410177 415584 417008 417018 421139 421861 425998 427536 428124 428828 428857 429306 430245 430833 431376 431691 432834 446022 446277 450786 453453 456736 458725 460658 462490 473954 478835 480553 484615 486023 486252 490456 492333 493121 496991 507916 509503 517278 519934 520687 523352 524651 525469 531039 531049 531842 533959 536296 539552 540055 542908 548848 556511 559008 566014 566300 569394 571494 573224 579284 581893 585724 590284 600588 601234 605021 611330 611345 622710 641924 644705 666612 691821 716916 720580 723261 726891 729166 730085 734847 742918 745558 749049 751485 755396 769547 771606 777025 777791 779587 789727 799941 800450 802427 803548 815918 816092 816985 818467 818739 818766 819249 819766 821679 822896 824779 824901 827356 827400 ] |
||||||||||||||||||||||||||||||
|
17.65 ms (10.91%) |
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 421139 421861 519934 490456 484615 520687 611345 327170 492333 405485 480553 559008 601234 585724 478835 600588 392790 417018 428857 410177 524651 473954 428828 824901 542908 571494 579284 611330 799941 769547 446022 462490 427536 431691 509503 517278 525469 581893 726891 388543 777791 742918 734847 751485 716916 400166 548848 430833 531049 536296 531039 723261 590284 802427 779587 573224 496991 395699 430245 446277 569394 556511 566014 417008 415584 429306 540055 566300 666612 777025 749049 69950 644705 405507 432834 428124 450786 456736 622710 393865 453453 523352 486252 533959 486023 507916 691821 720580 641924 800450 771606 730085 803548 384416 827356 821958 605021 729166 745558 755396 789727 458725 460658 431376 493121 425998 816092 818467 818739 818766 822896 816985 824779 827400 819249 821679 815918 819766 531842 539552 ] |
||||||||||||||||||||||||||||||
|
3.78 ms (2.34%) |
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 69950 327170 384416 388543 392790 393865 395699 400166 405485 405507 410177 415584 417008 417018 421139 421861 425998 427536 428124 428828 428857 429306 430245 430833 431376 431691 432834 446022 446277 450786 453453 456736 458725 460658 462490 473954 478835 480553 484615 486023 486252 490456 492333 493121 496991 507916 509503 517278 519934 520687 523352 524651 525469 531039 531049 531842 533959 536296 539552 540055 542908 548848 556511 559008 566014 566300 569394 571494 573224 579284 581893 585724 590284 600588 601234 605021 611330 611345 622710 641924 644705 666612 691821 716916 720580 723261 726891 729166 730085 734847 742918 745558 749049 751485 755396 769547 771606 777025 777791 779587 789727 799941 800450 802427 803548 815918 816092 816985 818467 818739 818766 819249 819766 821679 822896 824779 824901 827356 827400 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom vagina"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom вагин"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom вагин"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.09%) |
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.