Query Metrics
7
Database Queries
7
Different statements
160.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.92 ms (84.95%) |
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 103758 239808 382888 387492 397564 400019 400418 401757 402312 402434 403348 404696 408798 414256 414498 415200 417952 419432 426024 428655 429323 451699 465986 469055 470048 472353 478490 480945 483615 484483 494342 514383 518942 521964 523100 523985 527550 528275 533724 539210 548723 552514 560641 560642 565964 568359 568485 572028 573780 574523 574896 575127 575160 575475 575495 579253 596619 596645 597057 597226 597815 598042 598571 598580 598674 598806 600050 604342 620901 632302 633518 633737 633746 642097 649920 652192 652831 652923 654086 654198 655633 655745 659414 663232 666732 672686 680167 683454 684189 684690 693484 702162 718668 720754 722864 722883 727807 728384 730692 731998 732116 733905 740807 741548 743341 744723 745075 745353 753277 753369 774155 775909 780608 795554 795690 806883 812150 814139 818377 826672 ] |
||||||||||||||||||||||||||||||
|
14.63 ms (9.14%) |
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 775909 753277 753369 239808 400418 568359 666732 560642 597226 806883 732116 633518 795554 402312 402434 470048 528275 518942 560641 604342 598806 539210 680167 598042 596645 415200 480945 484483 523985 521964 575495 575160 693484 731998 642097 633746 514383 382888 428655 417952 429323 826672 818377 814139 533724 572028 575127 565964 552514 568485 574523 575475 654086 659414 663232 649920 652831 683454 684189 684690 702162 720754 652192 652923 672686 722883 548723 573780 574896 597057 598571 598674 633737 596619 598580 597815 620901 600050 795690 727807 730692 743341 728384 741548 744723 745353 733905 745075 632302 718668 722864 780608 401757 414498 478490 414256 404696 426024 400019 419432 465986 472353 483615 494342 103758 408798 579253 740807 812150 774155 451699 387492 397564 469055 527550 403348 523100 655633 654198 655745 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.79%) |
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 103758 239808 382888 387492 397564 400019 400418 401757 402312 402434 403348 404696 408798 414256 414498 415200 417952 419432 426024 428655 429323 451699 465986 469055 470048 472353 478490 480945 483615 484483 494342 514383 518942 521964 523100 523985 527550 528275 533724 539210 548723 552514 560641 560642 565964 568359 568485 572028 573780 574523 574896 575127 575160 575475 575495 579253 596619 596645 597057 597226 597815 598042 598571 598580 598674 598806 600050 604342 620901 632302 633518 633737 633746 642097 649920 652192 652831 652923 654086 654198 655633 655745 659414 663232 666732 672686 680167 683454 684189 684690 693484 702162 718668 720754 722864 722883 727807 728384 730692 731998 732116 733905 740807 741548 743341 744723 745075 745353 753277 753369 774155 775909 780608 795554 795690 806883 812150 814139 818377 826672 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful teen 18"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая teen 18"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая teen 18"
]
|
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.