Query Metrics
7
Database Queries
7
Different statements
133.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
113.16 ms (84.54%) |
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 72519 81412 281380 311393 330409 337264 350861 383097 383164 386695 387533 390139 395990 398138 401389 410808 412137 415537 418543 419055 432312 461474 506238 510877 513477 522238 523021 529460 535094 535806 537178 537212 542729 550442 552385 552903 553701 556176 563382 566240 584956 586978 590182 591919 596559 599361 614621 618289 624028 630026 655503 663309 678608 697731 710819 710925 718850 719821 723541 724685 724688 726920 728866 730165 731125 733447 733584 734007 734025 736500 740005 740187 742973 746693 755615 760302 761426 763474 764749 765034 766293 766966 767346 767781 767805 771357 772307 772353 772361 772826 775008 777508 779533 779547 779759 780233 780281 782787 783682 783724 783748 783831 784686 786457 787116 787213 787253 787273 788090 790127 790131 790577 793352 793793 796017 800046 805096 809541 ] |
||||||||||||||||||||||||||||||
|
12.13 ms (9.06%) |
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 410808 513477 510877 523021 522238 599361 81412 772353 281380 387533 783724 772307 736500 783748 350861 432312 461474 596559 330409 506238 535806 537178 552385 553701 563382 718850 655503 697731 710925 663309 710819 584956 586978 624028 591919 777508 786457 787116 790577 800046 779533 780281 783682 787273 788090 790127 809541 742973 746693 755615 767805 772826 782787 784686 787213 790131 805096 724688 734007 740187 764749 766966 724685 733584 734025 760302 765378 728866 740005 767346 767781 772361 764819 719821 779759 780233 398138 337264 401389 552903 796017 383097 311393 390139 537212 535094 793793 730165 733447 731125 618289 386695 72519 395990 723541 556176 590182 775008 783831 787253 765034 630026 383164 415537 550442 614621 418543 419055 412137 529460 542729 566240 678608 779547 793352 726920 763474 771357 761426 766293 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.83%) |
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 72519 81412 281380 311393 330409 337264 350861 383097 383164 386695 387533 390139 395990 398138 401389 410808 412137 415537 418543 419055 432312 461474 506238 510877 513477 522238 523021 529460 535094 535806 537178 537212 542729 550442 552385 552903 553701 556176 563382 566240 584956 586978 590182 591919 596559 599361 614621 618289 624028 630026 655503 663309 678608 697731 710819 710925 718850 719821 723541 724685 724688 726920 728866 730165 731125 733447 733584 734007 734025 736500 740005 740187 742973 746693 755615 760302 761426 763474 764749 765034 766293 766966 767346 767781 767805 771357 772307 772353 772361 772826 775008 777508 779533 779547 779759 780233 780281 782787 783682 783724 783748 783831 784686 786457 787116 787213 787253 787273 788090 790127 790131 790577 793352 793793 796017 800046 805096 809541 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в рот кончи"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"в рот сперм"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"в рот сперм"
]
|
||||||||||||||||||||||||||||||
|
1.26 ms (0.94%) |
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.