Query Metrics
7
Database Queries
7
Different statements
182.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.73 ms (85.75%) |
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 390320 394804 400093 400259 402507 407587 414200 427971 432822 442237 445306 450638 455515 456104 461663 462813 464678 469827 473868 477235 482217 484100 485720 488393 490692 491107 492465 497290 499757 500421 507083 512166 512929 517647 522203 523245 525766 526534 528881 535252 537857 541188 545330 545337 545394 549519 551121 584380 584434 597720 599604 607027 607070 612415 617032 624008 624293 629212 634729 641594 644054 650612 667147 671679 692676 692681 696485 710566 713067 716170 716308 724564 724997 726496 728496 732782 736564 737146 737877 747174 751715 760209 760661 760694 764353 767995 769160 769405 769437 770511 771456 776126 778739 780704 780944 781112 781530 782911 784088 784117 789694 790795 792185 794933 794963 795250 795271 796301 798610 799136 799435 802782 806157 808432 809466 809502 810810 820061 823767 824955 ] |
||||||||||||||||||||||||||||||
|
15.55 ms (8.51%) |
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 799136 795271 461663 473868 795250 462813 545394 692681 716308 624293 747174 820061 824955 469827 488393 525766 667147 599604 724564 781530 784088 737877 769437 780944 545330 770511 612415 584434 456104 716170 808432 769405 492465 634729 713067 624008 737146 696485 394804 771456 482217 507083 528881 671679 692676 794933 732782 490692 537857 549519 545337 641594 790795 802782 781112 796301 769160 726496 751715 767995 517647 491107 523245 784117 799435 810810 760661 760209 724997 764353 778739 485720 464678 400093 450638 644054 776126 760694 629212 402507 477235 499757 823767 500421 535252 584380 780704 390320 526534 512929 792185 809502 710566 650612 400259 484100 442237 782911 789694 728496 512166 427971 541188 551121 597720 607070 806157 736564 798610 455515 522203 607027 414200 617032 407587 432822 497290 445306 794963 809466 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big boobs milk"
]
|
||||||||||||||||||||||||||||||
|
2.40 ms (1.32%) |
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 390320 394804 400093 400259 402507 407587 414200 427971 432822 442237 445306 450638 455515 456104 461663 462813 464678 469827 473868 477235 482217 484100 485720 488393 490692 491107 492465 497290 499757 500421 507083 512166 512929 517647 522203 523245 525766 526534 528881 535252 537857 541188 545330 545337 545394 549519 551121 584380 584434 597720 599604 607027 607070 612415 617032 624008 624293 629212 634729 641594 644054 650612 667147 671679 692676 692681 696485 710566 713067 716170 716308 724564 724997 726496 728496 732782 736564 737146 737877 747174 751715 760209 760661 760694 764353 767995 769160 769405 769437 770511 771456 776126 778739 780704 780944 781112 781530 782911 784088 784117 789694 790795 792185 794933 794963 795250 795271 796301 798610 799136 799435 802782 806157 808432 809466 809502 810810 820061 823767 824955 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие boobs milk"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие boobs milk"
]
|
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.