Query Metrics
7
Database Queries
7
Different statements
219.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
196.72 ms (89.66%) |
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 38261 187990 396258 402137 403660 407656 430424 435747 443692 448722 448972 449608 449623 452391 460660 466709 472536 504951 505771 506127 514394 515372 515652 516032 521997 526742 531949 539219 539464 554907 572605 576176 578291 581600 584176 584249 591317 591587 592457 593068 601147 602591 604614 605403 612854 620055 629481 633200 637705 639221 669206 677825 678855 680702 683330 687163 697143 698983 699370 714029 716279 718767 719112 727653 745394 746662 748251 758601 758910 761343 763729 768028 770920 771792 773105 774785 775064 775101 775793 779565 781022 784306 785078 785435 785899 785920 786040 786368 786468 789689 793368 795511 797178 797675 800032 800708 802671 802691 803295 803415 803767 805154 807579 808701 811277 813767 814660 814851 815094 815189 815848 816728 817526 817920 820061 820417 821284 823903 824011 824258 ] |
||||||||||||||||||||||||||||||
|
11.81 ms (5.39%) |
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 443692 521997 504951 515372 430424 814851 816728 820061 821284 813767 815848 817920 815094 815189 817526 824011 814660 820417 539219 539464 576176 554907 578291 581600 669206 683330 698983 677825 716279 612854 602591 605403 639221 774785 775064 786468 807579 779565 786040 786368 800708 808701 811277 727653 758601 761343 785078 785435 785899 797178 803767 768028 773105 746662 763729 771792 637705 699370 718767 781022 795511 802671 803295 805154 403660 505771 187990 38261 396258 402137 435747 680702 823903 448722 449608 452391 448972 466709 572605 584249 678855 697143 714029 584176 591317 604614 629481 591587 789689 793368 803415 775793 800032 770920 745394 758910 633200 719112 775101 785920 797675 460660 449623 514394 516032 515652 601147 407656 824258 531949 506127 526742 472536 687163 592457 593068 620055 802691 748251 784306 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.26%) |
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 38261 187990 396258 402137 403660 407656 430424 435747 443692 448722 448972 449608 449623 452391 460660 466709 472536 504951 505771 506127 514394 515372 515652 516032 521997 526742 531949 539219 539464 554907 572605 576176 578291 581600 584176 584249 591317 591587 592457 593068 601147 602591 604614 605403 612854 620055 629481 633200 637705 639221 669206 677825 678855 680702 683330 687163 697143 698983 699370 714029 716279 718767 719112 727653 745394 746662 748251 758601 758910 761343 763729 768028 770920 771792 773105 774785 775064 775101 775793 779565 781022 784306 785078 785435 785899 785920 786040 786368 786468 789689 793368 795511 797178 797675 800032 800708 802671 802691 803295 803415 803767 805154 807579 808701 811277 813767 814660 814851 815094 815189 815848 816728 817526 817920 820061 820417 821284 823903 824011 824258 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hot сиськ mom"
]
|
||||||||||||||||||||||||||||||
|
2.17 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot tits mom"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot сиськ mom"
]
|
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.