Query Metrics
7
Database Queries
7
Different statements
138.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
115.43 ms (83.64%) |
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 364242 395731 401802 424240 463700 539464 589629 590284 592428 592907 604525 609177 614321 617687 626135 641358 710419 717037 718769 724699 725199 727394 731369 732824 732989 733553 733608 734016 736485 736487 736522 736527 740983 741620 742911 744281 746262 746851 747540 748190 750890 750922 751232 752604 754852 755394 756930 757342 757379 757382 759993 761245 762194 762250 762551 764142 766179 766968 767624 768207 769950 770088 771320 772188 772675 772694 773041 773073 773408 774364 774511 775107 775401 775626 775767 777195 777450 779173 779453 779557 780399 781244 781449 783264 786094 786175 786376 786387 786418 786784 787147 788371 788603 788804 788988 789041 789725 789992 790830 791414 793599 795141 796451 797350 797456 797875 799259 799597 800871 802207 802748 804383 804752 805158 806575 808133 809208 811948 812065 813314 ] |
||||||||||||||||||||||||||||||
|
12.51 ms (9.07%) |
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 592428 614321 617687 626135 641358 589629 775401 779173 779453 779557 786784 788371 788603 789725 790830 802748 804383 805158 806575 809208 774511 775626 777195 777450 780399 786376 786387 786418 789041 793599 795141 804752 808133 811948 725199 727394 732824 733608 734016 740983 742911 746851 747540 750922 752604 757342 757379 767624 772694 781449 783264 786175 791414 796451 797875 800871 802207 724699 732989 733553 748190 750890 755394 762250 762551 768207 769950 771320 736485 736487 736527 741620 762194 764142 773073 774364 736522 746262 754852 757382 759993 761245 766179 766968 772188 773408 731369 744281 751232 756930 772675 773041 604525 609177 710419 717037 718769 781244 786094 787147 788804 788988 789992 797350 797456 799259 799597 812065 813314 401802 364242 395731 590284 775767 770088 775107 592907 424240 463700 539464 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.85%) |
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 364242 395731 401802 424240 463700 539464 589629 590284 592428 592907 604525 609177 614321 617687 626135 641358 710419 717037 718769 724699 725199 727394 731369 732824 732989 733553 733608 734016 736485 736487 736522 736527 740983 741620 742911 744281 746262 746851 747540 748190 750890 750922 751232 752604 754852 755394 756930 757342 757379 757382 759993 761245 762194 762250 762551 764142 766179 766968 767624 768207 769950 770088 771320 772188 772675 772694 773041 773073 773408 774364 774511 775107 775401 775626 775767 777195 777450 779173 779453 779557 780399 781244 781449 783264 786094 786175 786376 786387 786418 786784 787147 788371 788603 788804 788988 789041 789725 789992 790830 791414 793599 795141 796451 797350 797456 797875 799259 799597 800871 802207 802748 804383 804752 805158 806575 808133 809208 811948 812065 813314 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom sperm"
]
|
||||||||||||||||||||||||||||||
|
2.10 ms (1.52%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom сперм"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom сперм"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.96%) |
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.