Query Metrics
7
Database Queries
7
Different statements
170.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.08 ms (84.38%) |
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 384143 400823 419459 427112 445811 446256 447143 448697 453502 467127 467303 467488 467562 467814 468244 474404 477209 477737 480774 482135 487789 489324 489621 490702 497992 509789 512824 516667 518372 520959 521304 523944 524779 525229 526874 527921 528907 529288 543577 544025 550716 550834 552982 554600 556867 557345 557420 558100 558433 559954 561606 562064 563013 565651 572224 575687 577130 578060 578432 580993 584162 585270 585366 587258 591352 592015 593207 594790 598033 601082 603546 604681 605690 606745 610728 620184 626480 626838 637098 639951 650528 661333 669700 674177 678960 696758 697008 697010 699053 699596 700945 714056 717644 720287 724114 731105 732716 740709 741799 743920 745053 750976 758381 758865 762185 775275 779971 780251 787896 788881 789698 794788 797011 800232 802781 807504 810128 814643 817865 ] |
||||||||||||||||||||||||||||||
|
18.21 ms (10.67%) |
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 604681 639951 789698 787896 794788 762185 745053 697008 775275 427112 523944 524779 561606 661333 714056 800232 740709 468244 419459 445811 489324 518372 554600 556867 558100 575687 544025 578432 580993 717644 696758 700945 572224 585270 593207 807504 743746 743920 603546 780251 467303 528907 400823 527921 467814 543577 674177 592015 601082 797011 810128 669700 637098 447143 606745 384143 482135 526874 699596 610728 802781 817865 446256 467562 520959 563013 565651 699053 594790 587258 598033 620184 626838 724114 509789 474404 562064 577130 585366 605690 732716 750976 814643 448697 516667 480774 578060 557420 650528 720287 559954 779971 788881 731105 741799 758381 467488 490702 497992 512824 477209 477737 525229 529288 487789 550716 552982 584162 678960 550834 557345 558433 626480 591352 758865 697010 467127 453502 521304 489621 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.27%) |
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 384143 400823 419459 427112 445811 446256 447143 448697 453502 467127 467303 467488 467562 467814 468244 474404 477209 477737 480774 482135 487789 489324 489621 490702 497992 509789 512824 516667 518372 520959 521304 523944 524779 525229 526874 527921 528907 529288 543577 544025 550716 550834 552982 554600 556867 557345 557420 558100 558433 559954 561606 562064 563013 565651 572224 575687 577130 578060 578432 580993 584162 585270 585366 587258 591352 592015 593207 594790 598033 601082 603546 604681 605690 606745 610728 620184 626480 626838 637098 639951 650528 661333 669700 674177 678960 696758 697008 697010 699053 699596 700945 714056 717644 720287 724114 731105 732716 740709 741799 743920 745053 750976 758381 758865 762185 775275 779971 780251 787896 788881 789698 794788 797011 800232 802781 807504 810128 814643 817865 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck in front"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс front"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс front"
]
|
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.