Query Metrics
7
Database Queries
7
Different statements
174.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.82 ms (86.85%) |
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 358453 397076 400614 493424 493561 506371 529810 530305 535311 549550 563947 579872 587908 598360 617778 620431 639089 639355 640617 646307 648679 654359 656107 656530 660455 660701 662839 668905 675041 675746 686091 693492 695093 695467 699415 701541 707608 707819 715004 717726 717812 720231 720793 721830 721959 722001 723934 724921 726989 728412 730069 730333 731327 731349 731354 731860 732903 740726 741909 742951 744746 745451 745808 745912 747749 750139 750278 750358 753479 756094 756847 757180 758087 758871 759796 760971 761009 761765 762253 764130 765412 765679 765735 767054 767193 768392 768730 769046 769073 774678 775715 777337 778084 778962 780061 780503 780968 784622 789450 790538 791411 791412 792720 794732 794889 795528 795680 796532 797521 799868 800509 801309 803699 805545 807038 809339 810307 812829 814502 ] |
||||||||||||||||||||||||||||||
|
13.00 ms (7.44%) |
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 721830 780968 675746 764130 639355 732903 686091 814502 620431 778084 800509 794889 795680 758871 769073 758087 535311 654359 731349 765412 656107 724921 784622 715004 397076 790538 794732 731860 810307 695093 695467 549550 587908 598360 803699 796532 740726 759796 726989 731327 699415 493561 717726 812829 797521 723934 741909 775715 358453 662839 701541 720793 707819 579872 805545 795528 801309 809339 791411 728412 753479 768730 750139 767054 765735 750278 761765 765679 617778 720231 791412 675041 563947 639089 807038 780061 750358 742951 762253 769046 757180 646307 756847 656530 780503 789450 745808 747749 730333 400614 493424 529810 506371 648679 660701 693492 707608 717812 722001 640617 777337 778962 756094 730069 731354 761009 744746 745451 745912 767193 768392 760971 721959 769740 530305 660455 668905 774678 792720 799868 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.31%) |
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 358453 397076 400614 493424 493561 506371 529810 530305 535311 549550 563947 579872 587908 598360 617778 620431 639089 639355 640617 646307 648679 654359 656107 656530 660455 660701 662839 668905 675041 675746 686091 693492 695093 695467 699415 701541 707608 707819 715004 717726 717812 720231 720793 721830 721959 722001 723934 724921 726989 728412 730069 730333 731327 731349 731354 731860 732903 740726 741909 742951 744746 745451 745808 745912 747749 750139 750278 750358 753479 756094 756847 757180 758087 758871 759796 760971 761009 761765 762253 764130 765412 765679 765735 767054 767193 768392 768730 769046 769073 774678 775715 777337 778084 778962 780061 780503 780968 784622 789450 790538 791411 791412 792720 794732 794889 795528 795680 796532 797521 799868 800509 801309 803699 805545 807038 809339 810307 812829 814502 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"горячий анальный секс…"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"горяч анал"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.01%) |
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.