Query Metrics
7
Database Queries
7
Different statements
193.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.55 ms (87.20%) |
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 4073 7170 152882 213692 233333 365871 382172 383429 388200 389587 394670 396563 397847 421743 446643 447335 469503 470923 480392 491913 499457 501406 514957 547239 547400 581470 584164 599350 608058 610911 612832 619187 619668 626930 632573 633300 634291 640407 649859 651636 660340 661652 662061 669961 682642 698513 703973 710686 714329 717235 717553 717853 720098 721746 723566 724373 725547 727049 728305 730346 739947 740578 743378 745472 747324 747956 748323 748965 750697 751205 754481 756073 758906 759623 760688 760917 766837 767289 767798 771353 772449 772635 772783 775484 777033 777056 780526 782625 787513 787887 790245 790869 791758 792139 793673 794938 795858 797625 799898 799995 800496 800569 800620 801260 802054 805654 808401 809018 809816 810125 810450 811121 811510 815306 815939 816623 817869 824075 824938 ] |
||||||||||||||||||||||||||||||
|
14.88 ms (7.70%) |
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 772783 501406 213692 396563 824075 661652 792139 780526 728305 480392 723566 581470 649859 710686 599350 619668 640407 724373 743378 365871 389587 470923 547239 634291 797625 794938 745472 754481 669961 799995 811121 730346 748323 815939 717553 793673 725547 750697 787513 767289 447335 791758 388200 584164 660340 682642 717235 610911 619187 632573 800496 777056 805654 766050 800569 810125 811510 747956 727049 748965 739947 747324 756073 608058 787887 790245 799898 809816 4073 152882 233333 446643 491913 721746 815306 816623 698513 703973 633300 612832 775484 777033 809018 810450 751205 759623 771353 758906 740578 760688 767798 772635 802054 394670 382172 7170 795858 760917 790869 772449 824938 817869 626930 808401 782625 801260 766837 800620 397847 383429 421743 469503 514957 499457 547400 714329 717853 720098 651636 662061 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.58%) |
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 4073 7170 152882 213692 233333 365871 382172 383429 388200 389587 394670 396563 397847 421743 446643 447335 469503 470923 480392 491913 499457 501406 514957 547239 547400 581470 584164 599350 608058 610911 612832 619187 619668 626930 632573 633300 634291 640407 649859 651636 660340 661652 662061 669961 682642 698513 703973 710686 714329 717235 717553 717853 720098 721746 723566 724373 725547 727049 728305 730346 739947 740578 743378 745472 747324 747956 748323 748965 750697 751205 754481 756073 758906 759623 760688 760917 766837 767289 767798 771353 772449 772635 772783 775484 777033 777056 780526 782625 787513 787887 790245 790869 791758 792139 793673 794938 795858 797625 799898 799995 800496 800569 800620 801260 802054 805654 808401 809018 809816 810125 810450 811121 811510 815306 815939 816623 817869 824075 824938 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pantyhose anal"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pantyhose анал"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pantyhose анал"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.