Query Metrics
7
Database Queries
7
Different statements
159.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.35 ms (82.52%) |
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 386671 404101 410328 468914 480552 504101 516061 520472 523044 530397 533711 540705 541184 541194 541996 542460 546164 549781 552497 553707 554704 554706 554734 555677 556093 560166 561203 562032 565382 575663 616839 617789 618662 618955 621004 621230 623352 626411 628623 631136 632224 633182 633408 635519 644850 647126 648485 649913 661347 661577 663836 663893 667820 669857 669899 680954 681234 685523 685525 690441 691231 692436 695674 696004 696052 696701 697934 700906 701628 702350 702372 705736 708010 708090 713145 718600 720474 723971 730499 736514 744933 747535 748346 748643 758176 761069 768770 769019 769094 769118 773275 774084 777327 778523 779614 780230 782133 783656 784050 785930 790395 791497 792058 792757 793973 798837 798848 798938 798959 801649 802803 804389 809948 809966 810208 811987 812228 813338 814715 828402 ] |
||||||||||||||||||||||||||||||
|
17.07 ms (10.72%) |
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 541194 542460 561203 702350 702372 708090 635519 790395 798938 812228 783656 813338 774084 730499 618662 798959 633408 530397 565382 552497 553707 556093 661577 626411 801649 793973 802803 768770 769118 778523 792757 644850 814715 540705 504101 523044 560166 562032 555677 685523 695674 649913 663836 663893 696004 696052 701628 718600 616839 631136 623352 780230 723971 736514 748346 696701 708010 777327 386671 404101 533711 549781 575663 546164 685525 669857 669899 700906 713145 720474 697934 628623 617789 618955 779614 792058 810208 785930 791497 804389 769094 798837 798848 809948 744933 769019 758176 748643 621230 633182 782133 809966 811987 468914 681234 691231 648485 647126 690441 692436 632224 747535 761069 480552 554734 554704 828402 410328 516061 520472 541996 554706 541184 705736 661347 667820 680954 621004 784050 773275 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.87%) |
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 386671 404101 410328 468914 480552 504101 516061 520472 523044 530397 533711 540705 541184 541194 541996 542460 546164 549781 552497 553707 554704 554706 554734 555677 556093 560166 561203 562032 565382 575663 616839 617789 618662 618955 621004 621230 623352 626411 628623 631136 632224 633182 633408 635519 644850 647126 648485 649913 661347 661577 663836 663893 667820 669857 669899 680954 681234 685523 685525 690441 691231 692436 695674 696004 696052 696701 697934 700906 701628 702350 702372 705736 708010 708090 713145 718600 720474 723971 730499 736514 744933 747535 748346 748643 758176 761069 768770 769019 769094 769118 773275 774084 777327 778523 779614 780230 782133 783656 784050 785930 790395 791497 792058 792757 793973 798837 798848 798938 798959 801649 802803 804389 809948 809966 810208 811987 812228 813338 814715 828402 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public cock"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на cock улиц"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на cock улиц"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.08%) |
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.