Query Metrics
7
Database Queries
7
Different statements
221.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
188.99 ms (85.43%) |
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 387287 401640 405050 405961 409652 421058 423654 429764 483550 514594 515568 531117 531155 532245 532737 532789 536582 540572 540573 541780 542549 542583 542590 543771 543860 543918 545410 545424 545773 552267 556797 557449 559161 562068 562374 565096 565243 565247 565249 565255 565267 568177 583132 583921 591804 598057 599902 599908 599945 600251 600295 600352 600363 601101 601517 601637 601641 603269 606577 606578 608431 614308 617410 627812 628086 628093 628332 628376 628379 628388 630552 632585 632616 632623 632654 632673 632678 632697 632975 633444 633445 635215 636033 636306 636985 637001 638967 639334 641667 642705 643103 644986 645284 647879 649578 649579 651147 666527 666906 667748 673570 674983 675000 675006 675022 676020 676107 676636 676638 677777 678028 678153 680112 694058 695122 695181 704526 733895 733908 820762 ] |
||||||||||||||||||||||||||||||
|
20.16 ms (9.11%) |
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 591804 599908 601637 601641 733895 632623 423654 559161 542583 649579 678028 704526 676107 545424 401640 820762 531117 562068 676638 678153 695122 545773 556797 608431 636033 632616 642705 409652 515568 674983 387287 676020 532789 677777 628332 638967 601101 540572 532245 536582 542549 543860 543771 666906 645284 667748 676636 606577 633445 637001 614308 643103 632585 632678 635215 603269 421058 405961 565267 600363 562374 649578 617410 532737 552267 568177 542590 557449 565243 565249 583132 565255 647879 680112 651147 565096 565247 583921 599945 632673 632975 598057 628376 632654 632697 600352 628086 628093 628379 628388 599902 600295 601517 641667 733908 606578 633444 483550 541780 675000 636306 639334 636985 627812 630552 429764 673570 694058 600251 405050 644986 540573 531155 514594 543918 545410 675006 695181 666527 675022 ] |
||||||||||||||||||||||||||||||
|
3.90 ms (1.76%) |
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 387287 401640 405050 405961 409652 421058 423654 429764 483550 514594 515568 531117 531155 532245 532737 532789 536582 540572 540573 541780 542549 542583 542590 543771 543860 543918 545410 545424 545773 552267 556797 557449 559161 562068 562374 565096 565243 565247 565249 565255 565267 568177 583132 583921 591804 598057 599902 599908 599945 600251 600295 600352 600363 601101 601517 601637 601641 603269 606577 606578 608431 614308 617410 627812 628086 628093 628332 628376 628379 628388 630552 632585 632616 632623 632654 632673 632678 632697 632975 633444 633445 635215 636033 636306 636985 637001 638967 639334 641667 642705 643103 644986 645284 647879 649578 649579 651147 666527 666906 667748 673570 674983 675000 675006 675022 676020 676107 676636 676638 677777 678028 678153 680112 694058 695122 695181 704526 733895 733908 820762 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"gape ass gangbang"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие дырк жоп gangbang"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие дырк жоп gangbang"
]
|
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.