Query Metrics
7
Database Queries
7
Different statements
194.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.07 ms (89.16%) |
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 21143 32620 81022 116757 233692 304428 382958 383687 384493 388179 389749 400293 441550 458779 461239 477970 487804 494718 524707 526150 528875 536026 536273 541071 541124 544877 551506 559605 579808 583777 605786 608711 616912 632330 632930 655724 657430 663901 665361 665649 675157 677136 677191 688249 689621 691611 692716 699073 699548 702250 702863 704866 705788 713216 717355 720024 721197 723858 729587 729832 733003 733615 735285 741938 746032 748125 749551 762228 764503 766380 766389 770061 773408 774141 777041 777836 777884 779404 779654 779827 780893 781717 782227 786123 787487 788657 788689 789169 789545 792940 795111 795158 795917 796610 796751 801713 803215 806915 808698 809867 810641 812096 816758 817364 817699 817702 817713 817819 817961 818709 818873 819180 819696 821085 821522 822888 826593 826705 827474 827981 ] |
||||||||||||||||||||||||||||||
|
11.33 ms (5.84%) |
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 616912 632330 605786 780893 781717 782227 787487 808698 777041 777836 777884 779404 789169 789545 795158 729832 733003 746032 748125 786123 788657 788689 795917 796751 812096 729587 749551 762228 723858 766389 741938 766380 773408 774141 733615 735285 764503 770061 608711 632930 702863 704866 721197 779654 779827 792940 795111 796610 801713 803215 806915 809867 810641 32620 304428 116757 233692 389749 21143 524707 382958 384493 383687 81022 388179 400293 441550 817699 819696 821085 822888 826705 826593 817713 817819 818873 817702 819180 816758 817364 817961 818709 821522 827981 827474 458779 487804 526150 536026 536273 494718 528875 461239 477970 551506 579808 541071 541124 544877 559605 583777 657430 665361 665649 675157 677136 677191 688249 689621 691611 692716 699073 699548 702250 705788 713216 717355 720024 655724 663901 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.54%) |
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 21143 32620 81022 116757 233692 304428 382958 383687 384493 388179 389749 400293 441550 458779 461239 477970 487804 494718 524707 526150 528875 536026 536273 541071 541124 544877 551506 559605 579808 583777 605786 608711 616912 632330 632930 655724 657430 663901 665361 665649 675157 677136 677191 688249 689621 691611 692716 699073 699548 702250 702863 704866 705788 713216 717355 720024 721197 723858 729587 729832 733003 733615 735285 741938 746032 748125 749551 762228 764503 766380 766389 770061 773408 774141 777041 777836 777884 779404 779654 779827 780893 781717 782227 786123 787487 788657 788689 789169 789545 792940 795111 795158 795917 796610 796751 801713 803215 806915 808698 809867 810641 812096 816758 817364 817699 817702 817713 817819 817961 818709 818873 819180 819696 821085 821522 822888 826593 826705 827474 827981 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"guy and"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"guy"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"guy"
]
|
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.