Query Metrics
7
Database Queries
7
Different statements
173.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.74 ms (85.56%) |
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 81574 383153 402244 418713 422639 423270 425484 427553 442137 445726 445971 446267 449261 450889 451536 470381 471774 488925 497219 501931 507312 509818 517086 517768 521210 522110 522975 527519 527531 536208 537959 539350 540776 542461 542601 544301 545685 549341 552790 552917 553692 556850 558317 559013 559296 559476 561382 563488 563691 564794 565161 565491 566440 566748 569781 578139 578179 579881 580190 582587 582915 584740 591133 592514 593342 597056 598251 601621 603134 610379 621005 645840 651198 655096 659277 659833 659836 660897 663981 671819 672340 672676 674098 677940 678555 678570 682421 685515 689121 691451 717688 719134 730319 740476 746578 751220 758111 758304 762694 769988 774588 775475 782951 789582 790999 793101 795585 795847 796224 796231 797198 801624 804795 806226 806498 812239 814800 816835 818372 821602 ] |
||||||||||||||||||||||||||||||
|
14.67 ms (8.44%) |
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 578139 584740 542601 559013 682421 565491 580190 422639 442137 517086 497219 501931 578179 451536 418713 522110 446267 445971 507312 509818 561382 579881 592514 450889 522975 517768 565161 423270 427553 527531 527519 552917 582587 556850 552790 677940 545685 603134 425484 470381 449261 471774 601621 445726 81574 383153 818372 540776 816835 821602 488925 521210 536208 537959 539350 563691 564794 553692 558317 559476 542461 544301 563488 659836 672676 678555 689121 659277 660897 663981 674098 691451 717688 645840 651198 655096 659833 671819 672340 678570 685515 549341 559296 566440 569781 593342 621005 591133 597056 598251 795585 795847 797198 774588 775475 789582 793101 801624 806226 812239 730319 740476 769988 758111 746578 751220 758304 762694 610379 719134 782951 790999 796224 796231 804795 806498 582915 566748 402244 814800 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (1.79%) |
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 81574 383153 402244 418713 422639 423270 425484 427553 442137 445726 445971 446267 449261 450889 451536 470381 471774 488925 497219 501931 507312 509818 517086 517768 521210 522110 522975 527519 527531 536208 537959 539350 540776 542461 542601 544301 545685 549341 552790 552917 553692 556850 558317 559013 559296 559476 561382 563488 563691 564794 565161 565491 566440 566748 569781 578139 578179 579881 580190 582587 582915 584740 591133 592514 593342 597056 598251 601621 603134 610379 621005 645840 651198 655096 659277 659833 659836 660897 663981 671819 672340 672676 674098 677940 678555 678570 682421 685515 689121 691451 717688 719134 730319 740476 746578 751220 758111 758304 762694 769988 774588 775475 782951 789582 790999 793101 795585 795847 796224 796231 797198 801624 804795 806226 806498 812239 814800 816835 818372 821602 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny stockings"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.97%) |
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.