Query Metrics
7
Database Queries
7
Different statements
342.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
324.72 ms (94.68%) |
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 423460 449000 454833 456167 463334 470144 483249 493870 495707 519615 521946 538459 541529 542417 544927 556174 556670 559096 562424 562751 562785 569588 569652 574096 577688 599307 600945 604724 605221 610298 610816 616008 618350 619711 622127 622795 624295 625189 628690 629004 631120 633483 638873 639720 641548 641854 650053 657127 661616 670576 671116 674572 678018 679687 685823 692425 696916 703662 712517 713557 716596 716653 716708 719752 724555 726196 728489 728795 729465 734476 739552 740053 741013 742987 751732 756958 763538 763541 764468 764500 768558 769667 771516 772258 776479 777090 777608 778413 779803 779806 782979 783385 784208 784667 784910 786665 789229 790477 790798 790889 790950 791974 792403 794923 795632 796616 797394 797425 797643 799397 799476 799584 805919 809168 809310 809676 809678 814007 814274 814516 ] |
||||||||||||||||||||||||||||||
|
8.53 ms (2.49%) |
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 764468 786665 790798 657127 713557 556670 618350 790889 791974 641548 423460 631120 541529 679687 519615 562424 622127 638873 799584 796616 740053 742987 779803 789229 814274 544927 671116 633483 639720 629004 809310 696916 619711 779806 729465 772258 771516 703662 777090 454833 562785 692425 716596 678018 605221 625189 599307 616008 776479 799397 805919 794923 797643 784208 734476 768558 741013 756958 763538 769667 712517 783385 814516 814007 456167 470144 521946 574096 542417 559096 650053 719752 622795 628690 600945 604724 610298 790950 809168 728489 763541 764500 777608 790477 809676 463334 483249 493870 661616 674572 577688 624295 778413 795632 784667 792403 797394 739552 782979 751732 728795 716653 716708 809678 495707 538459 562751 569588 569652 685823 784910 799476 797425 449000 556174 724555 610816 641854 726196 670576 ] |
||||||||||||||||||||||||||||||
|
3.69 ms (1.08%) |
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 423460 449000 454833 456167 463334 470144 483249 493870 495707 519615 521946 538459 541529 542417 544927 556174 556670 559096 562424 562751 562785 569588 569652 574096 577688 599307 600945 604724 605221 610298 610816 616008 618350 619711 622127 622795 624295 625189 628690 629004 631120 633483 638873 639720 641548 641854 650053 657127 661616 670576 671116 674572 678018 679687 685823 692425 696916 703662 712517 713557 716596 716653 716708 719752 724555 726196 728489 728795 729465 734476 739552 740053 741013 742987 751732 756958 763538 763541 764468 764500 768558 769667 771516 772258 776479 777090 777608 778413 779803 779806 782979 783385 784208 784667 784910 786665 789229 790477 790798 790889 790950 791974 792403 794923 795632 796616 797394 797425 797643 799397 799476 799584 805919 809168 809310 809676 809678 814007 814274 814516 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"горло трах"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"горл секс"
]
|
||||||||||||||||||||||||||||||
|
1.20 ms (0.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.