Query Metrics
7
Database Queries
7
Different statements
167.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.49 ms (87.01%) |
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 335462 392184 397932 461123 468914 525062 530280 530441 533711 535616 536050 536053 536079 540165 540705 542722 544956 545071 549781 550911 551891 552519 554684 555319 555677 555979 561511 562157 575663 591876 596549 598424 600778 605225 607025 608096 616728 616839 617789 621230 623352 628623 632086 633182 634329 634362 638947 640870 644850 651328 666708 669857 669899 669903 669905 677920 685523 685525 685527 689868 698819 707812 708010 718764 721922 722952 723971 734386 734429 736535 738976 744810 751490 752622 752765 758176 758878 759155 760751 761159 764419 764993 765577 765802 765893 767391 768606 769019 769094 773584 777327 777636 780230 780509 786388 791318 791497 792058 792769 798837 798848 802023 802913 804263 804389 809767 810621 811857 811987 814298 814715 818621 818950 819083 819455 820186 828138 828175 828425 ] |
||||||||||||||||||||||||||||||
|
11.83 ms (7.07%) |
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 634329 638947 828175 525062 536050 810621 804263 598424 685527 530441 818621 591876 759155 554684 644850 814715 540705 533711 549781 544956 546559 575663 555677 685523 685525 669857 669899 698819 669905 628623 616839 617789 623352 780230 792058 786388 791497 804389 723971 769094 798837 798848 769019 765577 758176 605225 621230 633182 708010 777327 811987 468914 802023 392184 550911 677920 607025 765893 767391 736535 545071 555979 335462 397932 818950 819083 814298 819455 820186 828425 828138 530280 536053 540165 536079 561511 542722 552519 562157 651328 666708 718764 689868 721922 551891 555319 600778 596549 640870 608096 802913 780509 760751 752622 758878 764419 765802 768606 744810 751490 738976 761159 632086 722952 777636 792769 811857 669903 616728 634362 734386 734429 773584 791318 809767 764993 752765 707812 461123 535616 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.64%) |
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 335462 392184 397932 461123 468914 525062 530280 530441 533711 535616 536050 536053 536079 540165 540705 542722 544956 545071 549781 550911 551891 552519 554684 555319 555677 555979 561511 562157 575663 591876 596549 598424 600778 605225 607025 608096 616728 616839 617789 621230 623352 628623 632086 633182 634329 634362 638947 640870 644850 651328 666708 669857 669899 669903 669905 677920 685523 685525 685527 689868 698819 707812 708010 718764 721922 722952 723971 734386 734429 736535 738976 744810 751490 752622 752765 758176 758878 759155 760751 761159 764419 764993 765577 765802 765893 767391 768606 769019 769094 773584 777327 777636 780230 780509 786388 791318 791497 792058 792769 798837 798848 802023 802913 804263 804389 809767 810621 811857 811987 814298 814715 818621 818950 819083 819455 820186 828138 828175 828425 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife public stranger"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен на stranger улиц"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен на stranger улиц"
]
|
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.