Query Metrics
7
Database Queries
7
Different statements
186.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.53 ms (82.33%) |
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 74135 385379 387428 403418 403755 405975 416007 418225 426104 445245 449112 450125 450128 450193 453233 456575 468357 483194 488393 491875 495553 501678 502726 507631 511383 511611 511835 515443 515961 521157 525366 534768 537273 538790 538996 539309 541737 543640 544570 556009 556169 556250 557367 557471 560680 560703 561518 561917 575174 576124 583375 585258 585365 588578 588973 590538 595739 598926 602862 604153 608714 618447 620547 620808 623714 626577 630834 636207 636255 644160 650282 650911 659360 662776 662783 664498 671172 672701 672843 675079 676769 677748 689061 689989 693257 696449 703419 707833 707974 709148 709523 710354 714324 716527 716534 716825 717187 719464 720165 721805 778117 778987 785967 787053 789444 794423 796147 798822 804300 804649 806854 806865 808562 809002 809706 810624 810799 811435 811869 812488 ] |
||||||||||||||||||||||||||||||
|
15.64 ms (8.39%) |
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 806854 806865 809706 810624 810799 812488 385379 426104 387428 456575 403418 450128 495553 502726 515443 483194 507631 511835 556009 604153 74135 405975 403755 418225 416007 445245 453233 491875 450193 488393 449112 450125 511383 537273 538790 539309 511611 521157 538996 515961 534768 501678 525366 468357 556250 561518 557471 575174 576124 541737 543640 544570 557367 560680 560703 561917 583375 650911 662776 672701 672843 677748 693257 709523 716527 716825 717187 650282 662783 664498 676769 689061 689989 696449 703419 707974 710354 719464 720165 721805 659360 671172 675079 707833 709148 714324 716534 556169 588973 595739 620547 630834 636207 585365 588578 598926 602862 618447 644160 585258 590538 620808 623714 626577 636255 608714 785967 789444 794423 796147 798822 804300 808562 809002 811435 811869 778117 778987 787053 804649 ] |
||||||||||||||||||||||||||||||
|
10.07 ms (5.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.37%) |
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 74135 385379 387428 403418 403755 405975 416007 418225 426104 445245 449112 450125 450128 450193 453233 456575 468357 483194 488393 491875 495553 501678 502726 507631 511383 511611 511835 515443 515961 521157 525366 534768 537273 538790 538996 539309 541737 543640 544570 556009 556169 556250 557367 557471 560680 560703 561518 561917 575174 576124 583375 585258 585365 588578 588973 590538 595739 598926 602862 604153 608714 618447 620547 620808 623714 626577 630834 636207 636255 644160 650282 650911 659360 662776 662783 664498 671172 672701 672843 675079 676769 677748 689061 689989 693257 696449 703419 707833 707974 709148 709523 710354 714324 716527 716534 716825 717187 719464 720165 721805 778117 778987 785967 787053 789444 794423 796147 798822 804300 804649 806854 806865 808562 809002 809706 810624 810799 811435 811869 812488 ] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер sexy"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam sexy"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер sexy"
]
|
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.