Query Metrics
7
Database Queries
7
Different statements
179.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.49 ms (85.65%) |
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 233416 233710 404193 411392 411398 436832 436868 442989 443673 443680 447083 453475 453483 453586 455274 455364 456671 456724 458693 459600 459627 460463 461411 461484 462099 464543 464547 465899 467814 469685 470694 471529 471938 471997 473255 474052 477719 477958 479138 481247 482362 484053 484400 485005 485604 485846 492542 492960 497647 500024 501519 502928 504154 505853 507332 508603 508650 509502 512553 512643 512650 524653 528936 534040 543977 546939 550238 551576 557119 557982 557998 558101 558646 562181 563987 567423 573997 577418 581470 590335 590945 591420 598206 598616 605967 619097 649480 655082 659220 660531 671189 673858 674872 677049 714623 732119 756915 758174 781689 782126 788377 788457 802102 807359 810582 810727 814427 816112 816143 816708 818833 820225 820309 824304 824585 825362 825429 826086 ] |
||||||||||||||||||||||||||||||
|
15.11 ms (8.43%) |
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 802102 810582 810727 233416 459627 456724 470694 619097 471997 507332 485846 551576 558101 655082 577418 590945 591420 233710 436832 464543 482362 404193 455364 458693 461411 459600 471529 471938 453586 465899 481247 447083 461484 469685 528936 502928 524653 509502 492960 508650 512553 512643 512650 484053 497647 534040 467814 543977 557998 673858 714623 546939 550238 567423 590335 598616 605967 781689 788457 779905 807359 756915 782126 788377 731666 732119 758174 473255 477958 464547 411398 443680 456671 460463 462099 474052 477719 442989 411392 436868 443673 453475 453483 501519 505853 484400 485604 500024 598206 479138 557119 814427 816112 818833 825429 820225 820309 825362 816143 816708 824304 824585 826086 485005 492542 455274 504154 508603 562181 563987 581470 557982 558646 573997 649480 659220 660531 671189 674872 677049 ] |
||||||||||||||||||||||||||||||
|
3.35 ms (1.87%) |
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 233416 233710 404193 411392 411398 436832 436868 442989 443673 443680 447083 453475 453483 453586 455274 455364 456671 456724 458693 459600 459627 460463 461411 461484 462099 464543 464547 465899 467814 469685 470694 471529 471938 471997 473255 474052 477719 477958 479138 481247 482362 484053 484400 485005 485604 485846 492542 492960 497647 500024 501519 502928 504154 505853 507332 508603 508650 509502 512553 512643 512650 524653 528936 534040 543977 546939 550238 551576 557119 557982 557998 558101 558646 562181 563987 567423 573997 577418 581470 590335 590945 591420 598206 598616 605967 619097 649480 655082 659220 660531 671189 673858 674872 677049 714623 732119 756915 758174 781689 782126 788377 788457 802102 807359 810582 810727 814427 816112 816143 816708 818833 820225 820309 824304 824585 825362 825429 826086 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"maid russian"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"горничн русск"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.86%) |
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.