Query Metrics
7
Database Queries
7
Different statements
166.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.78 ms (81.63%) |
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 390497 393865 394376 400872 401230 401235 401902 402342 403600 403900 404313 404664 405485 405507 407154 408293 409105 409258 412394 413091 413110 416408 416791 417339 418195 420540 421139 421887 428826 428846 428892 430377 431691 432834 437583 438219 439709 442783 446286 450779 450786 450797 450803 451086 453453 456736 460179 460184 462490 464404 464407 466429 466435 468629 469061 472465 476904 477114 478107 478835 480553 481794 482248 490031 492096 509503 512895 513116 515031 516209 516886 517278 520021 523352 523762 523779 524330 524654 524783 524874 525469 527151 531917 533959 535010 535820 547927 548489 554899 556662 557958 569394 573990 586680 591155 605261 610235 616049 622710 645917 698224 703144 705298 713262 717677 731464 743396 748212 757114 763845 781306 788610 801323 813913 816012 828188 828530 828860 ] |
||||||||||||||||||||||||||||||
|
18.61 ms (11.19%) |
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 748212 403900 438219 464407 404313 450797 460179 428826 428892 431691 450803 451086 509503 520021 512895 516886 517278 492096 513116 516209 525469 390497 404664 413091 490031 524783 510295 476904 547927 645917 610235 788610 781306 763845 697939 402342 413110 420540 400872 401230 412394 416791 460184 401902 418195 430377 421139 472465 405507 456736 556662 477114 524654 569394 717677 698224 548489 605261 586680 743396 757114 428846 439709 450779 524330 813913 481794 524874 554899 573990 703144 616049 591155 801323 731464 713262 417339 409105 462490 421887 442783 409258 464404 523762 515031 828860 531917 816012 450786 446286 523779 469061 393865 466435 478835 523352 533959 535010 828188 535820 705298 828530 394376 403600 405485 432834 468629 480553 527151 557958 622710 408293 401235 466429 478107 416408 437583 453453 407154 482248 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.80%) |
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 390497 393865 394376 400872 401230 401235 401902 402342 403600 403900 404313 404664 405485 405507 407154 408293 409105 409258 412394 413091 413110 416408 416791 417339 418195 420540 421139 421887 428826 428846 428892 430377 431691 432834 437583 438219 439709 442783 446286 450779 450786 450797 450803 451086 453453 456736 460179 460184 462490 464404 464407 466429 466435 468629 469061 472465 476904 477114 478107 478835 480553 481794 482248 490031 492096 509503 512895 513116 515031 516209 516886 517278 520021 523352 523762 523779 524330 524654 524783 524874 525469 527151 531917 533959 535010 535820 547927 548489 554899 556662 557958 569394 573990 586680 591155 605261 610235 616049 622710 645917 698224 703144 705298 713262 717677 731464 743396 748212 757114 763845 781306 788610 801323 813913 816012 828188 828530 828860 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.55%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие mom"
]
|
||||||||||||||||||||||||||||||
|
2.15 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big as mom"
]
|
||||||||||||||||||||||||||||||
|
2.12 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие mom"
]
|
||||||||||||||||||||||||||||||
|
2.11 ms (1.27%) |
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.