Query Metrics
7
Database Queries
7
Different statements
388.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.34 ms (53.31%) |
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 13118 382117 384423 387742 390303 390761 396656 396759 401617 403690 404192 405485 407570 410687 410955 411199 418084 421058 422167 422725 424379 424407 426816 429609 432663 433302 434350 437983 440753 442144 445736 445930 447740 448874 449713 450297 454350 462019 464180 464798 465858 466499 467614 468637 468750 472525 472592 475258 475489 478408 482981 483147 484876 487368 491837 493221 493679 493754 496340 497879 502713 504668 506069 512137 515511 518582 519465 519949 524257 532746 534990 535533 544292 545718 550035 550363 550366 555992 557522 560917 569149 583449 598370 598387 601792 605144 605337 619199 619645 626293 642346 646279 649108 655295 656266 666196 666869 705277 708468 712940 717677 718945 721715 756383 756509 757350 757393 761590 765517 775473 775858 777017 778195 779744 806060 806327 816158 820068 820070 825831 ] |
||||||||||||||||||||||||||||||
|
153.49 ms (39.47%) |
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 13118 382117 384423 387742 390303 390761 396656 396759 401617 403690 404192 405485 407570 410687 410955 411199 418084 421058 422167 422725 424379 424407 426816 429609 432663 433302 434350 437983 440753 442144 445736 445930 447740 448874 449713 450297 454350 462019 464180 464798 465858 466499 467614 468637 468750 472525 472592 475258 475489 478408 482981 483147 484876 487368 491837 493221 493679 493754 496340 497879 502713 504668 506069 512137 515511 518582 519465 519949 524257 532746 534990 535533 544292 545718 550035 550363 550366 555992 557522 560917 569149 583449 598370 598387 601792 605144 605337 619199 619645 626293 642346 646279 649108 655295 656266 666196 666869 705277 708468 712940 717677 718945 721715 756383 756509 757350 757393 761590 765517 775473 775858 777017 778195 779744 806060 806327 816158 820068 820070 825831 ] |
||||||||||||||||||||||||||||||
|
20.35 ms (5.23%) |
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 410687 429609 820068 820070 825831 816158 445930 466499 493679 445736 464180 493754 502713 506069 544292 550366 583449 666196 717677 718945 598387 626293 605144 779744 761590 756383 756509 765517 757350 757393 721715 777017 390761 418084 449713 382117 424407 454350 384423 390303 396759 401617 410955 437983 13118 403690 404192 442144 411199 422167 462019 487368 491837 497879 496340 555992 405485 468637 545718 550035 619199 601792 421058 475258 422725 519949 524257 512137 518582 655295 467614 483147 433302 493221 387742 396656 407570 440753 424379 432663 434350 426816 468750 478408 450297 464798 482981 484876 447740 448874 472525 475489 532746 535533 515511 504668 519465 534990 465858 472592 550363 557522 569149 646279 649108 666869 705277 712940 656266 708468 560917 598370 619645 605337 642346 806060 775473 775858 778195 806327 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (0.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful milf anal"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая milf анал"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая milf анал"
]
|
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.