Query Metrics
7
Database Queries
7
Different statements
160.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.86 ms (85.45%) |
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 72802 145502 382549 383171 386545 395661 411628 426719 446821 453145 464339 465834 465949 466893 474076 474784 475867 476287 477955 477961 481820 484768 485216 485978 487315 494849 504101 519268 520916 521207 523051 524389 531960 532270 534244 534636 535365 535508 544504 544573 544587 546121 560397 561333 562534 562590 562961 563001 566800 570795 570803 573918 576622 576702 579902 591288 603190 614514 617677 624469 645826 645937 659079 663982 665102 673649 681126 682206 684106 695618 696599 699708 699728 715443 716787 718560 719175 720099 726144 726289 726476 726492 727339 727395 727697 727837 727935 728481 733416 739585 741047 744352 756021 756057 770161 770909 772327 776584 781486 782213 789599 794640 797309 800234 801592 801617 801884 804128 804170 804216 805012 813777 816261 816802 817165 820142 820375 820683 820732 827421 ] |
||||||||||||||||||||||||||||||
|
14.12 ms (8.81%) |
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 494849 521207 531960 566800 544573 544587 562590 570795 682206 696599 715443 645826 659079 684106 695618 699728 681126 579902 603190 624469 617677 776584 789599 801592 805012 781486 782213 801617 801884 804216 726289 727395 800234 727339 727697 756057 728481 699708 719175 804128 804170 576622 466893 465949 426719 645937 145502 382549 524389 487315 475867 673649 726144 727935 485978 827421 820142 820375 820732 794640 744352 739585 770161 797309 820683 464339 534636 563001 573918 665102 716787 576702 395661 477955 477961 465834 481820 484768 519268 520916 534244 411628 816261 446821 453145 476287 532270 544504 546121 562534 720099 663982 591288 614514 772327 523051 474784 562961 386545 72802 535508 504101 535365 560397 561333 741047 726476 726492 770909 756021 727837 733416 485216 570803 718560 474076 383171 816802 817165 813777 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (1.98%) |
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 72802 145502 382549 383171 386545 395661 411628 426719 446821 453145 464339 465834 465949 466893 474076 474784 475867 476287 477955 477961 481820 484768 485216 485978 487315 494849 504101 519268 520916 521207 523051 524389 531960 532270 534244 534636 535365 535508 544504 544573 544587 546121 560397 561333 562534 562590 562961 563001 566800 570795 570803 573918 576622 576702 579902 591288 603190 614514 617677 624469 645826 645937 659079 663982 665102 673649 681126 682206 684106 695618 696599 699708 699728 715443 716787 718560 719175 720099 726144 726289 726476 726492 727339 727395 727697 727837 727935 728481 733416 739585 741047 744352 756021 756057 770161 770909 772327 776584 781486 782213 789599 794640 797309 800234 801592 801617 801884 804128 804170 804216 805012 813777 816261 816802 817165 820142 820375 820683 820732 827421 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"kissing mature woman"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"kissing зрелая женщин"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"kissing зрелая женщин"
]
|
||||||||||||||||||||||||||||||
|
1.26 ms (0.79%) |
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.