Query Metrics
7
Database Queries
7
Different statements
197.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.63 ms (88.12%) |
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 12405 68945 73571 129246 140007 209941 233112 380621 381749 382606 383111 384796 386206 386514 386871 400348 404211 420303 426784 437363 502043 561775 592428 593832 599595 606260 613055 617377 625208 626520 651617 663415 672092 681246 695638 700921 719047 719108 721775 728506 729013 729253 729587 733126 734283 734417 736999 737371 741143 742938 744225 744821 747133 753278 753299 753303 753381 753405 753861 755289 757284 759880 765444 770464 772430 772560 774077 775587 775627 775647 777036 779509 780316 780627 781971 782773 784258 788688 788877 788957 791841 792003 792245 792657 793546 793808 794459 794488 795004 797962 798109 799728 800008 800758 802349 804130 804233 805315 807954 808038 808642 810586 811004 811460 811989 812119 812316 813475 819143 819823 820041 820141 823487 823598 823842 824125 825125 825227 825803 826987 ] |
||||||||||||||||||||||||||||||
|
12.84 ms (6.52%) |
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 721775 626520 775627 799728 808642 812119 788688 800758 808038 741143 788957 792003 797962 804130 811989 759880 744225 765444 729253 736999 775647 502043 593832 613055 380621 400348 420303 819823 663415 672092 681246 592428 792657 805315 777036 782773 737371 757284 794459 795004 811004 812316 729013 729587 734283 744821 728506 733126 772430 770464 426784 233112 140007 381749 12405 437363 820141 820041 561775 606260 788877 775587 794488 804233 734417 772560 792245 798109 811460 625208 780316 800008 209941 382606 753861 383111 384796 129246 807954 753278 774077 747133 386871 386514 68945 823487 695638 651617 700921 719108 617377 599595 780627 779509 784258 793808 813475 742938 753381 793546 802349 810586 753299 753303 755289 753405 719047 781971 791841 73571 404211 386206 823598 823842 825125 825227 825803 826987 819143 824125 ] |
||||||||||||||||||||||||||||||
|
3.23 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 12405 68945 73571 129246 140007 209941 233112 380621 381749 382606 383111 384796 386206 386514 386871 400348 404211 420303 426784 437363 502043 561775 592428 593832 599595 606260 613055 617377 625208 626520 651617 663415 672092 681246 695638 700921 719047 719108 721775 728506 729013 729253 729587 733126 734283 734417 736999 737371 741143 742938 744225 744821 747133 753278 753299 753303 753381 753405 753861 755289 757284 759880 765444 770464 772430 772560 774077 775587 775627 775647 777036 779509 780316 780627 781971 782773 784258 788688 788877 788957 791841 792003 792245 792657 793546 793808 794459 794488 795004 797962 798109 799728 800008 800758 802349 804130 804233 805315 807954 808038 808642 810586 811004 811460 811989 812119 812316 813475 819143 819823 820041 820141 823487 823598 823842 824125 825125 825227 825803 826987 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck licking"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс лиза"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.69%) |
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.