Query Metrics
7
Database Queries
7
Different statements
391.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.02 ms (54.17%) |
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 388532 391604 408460 418068 419113 425820 426043 439256 440876 444882 450579 464188 479816 479872 487486 494815 498440 499089 500332 501931 501958 502089 508485 510898 512073 516652 516661 516836 517974 525350 527428 528641 531181 531201 531223 531677 533944 545430 546571 556664 559178 565501 566320 572305 573760 582558 595977 599990 600200 600539 605909 615379 617066 618855 619166 620612 623319 629419 630905 631593 633266 633435 639751 639823 640771 641806 641978 643516 647344 651850 676495 676549 677994 679799 688581 695708 697220 703843 706524 710626 713877 714067 714892 715209 715283 715596 715798 720756 722520 726878 728152 729312 732791 733851 735404 742786 742900 744560 748083 750646 753902 756614 758012 761180 769865 770271 772671 778350 801206 810059 810884 813003 813683 815274 815585 816995 818371 818867 820151 826971 ] |
||||||||||||||||||||||||||||||
|
151.05 ms (38.59%) |
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 388532 391604 408460 418068 419113 425820 426043 439256 440876 444882 450579 464188 479816 479872 487486 494815 498440 499089 500332 501931 501958 502089 508485 510898 512073 516652 516661 516836 517974 525350 527428 528641 531181 531201 531223 531677 533944 545430 546571 556664 559178 565501 566320 572305 573760 582558 595977 599990 600200 600539 605909 615379 617066 618855 619166 620612 623319 629419 630905 631593 633266 633435 639751 639823 640771 641806 641978 643516 647344 651850 676495 676549 677994 679799 688581 695708 697220 703843 706524 710626 713877 714067 714892 715209 715283 715596 715798 720756 722520 726878 728152 729312 732791 733851 735404 742786 742900 744560 748083 750646 753902 756614 758012 761180 769865 770271 772671 778350 801206 810059 810884 813003 813683 815274 815585 816995 818371 818867 820151 826971 ] |
||||||||||||||||||||||||||||||
|
20.94 ms (5.35%) |
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 582558 651850 600539 630905 641806 810059 617066 633266 500332 815274 517974 676495 559178 647344 633435 639751 641978 479872 818371 713877 676549 715798 801206 735404 744560 531181 818867 813683 715283 706524 714067 715209 677994 720756 618855 643516 623319 778350 729312 742900 750646 772671 728152 726878 769865 742786 758012 748083 761180 629419 715596 391604 439256 444882 464188 494815 498440 531223 516661 527428 566320 679799 600200 639823 640771 620612 419113 450579 499089 512073 508485 516652 510898 546571 631593 816995 516836 531677 714892 722520 703843 753902 810884 426043 556664 545430 440876 605909 619166 533944 573760 756614 531201 565501 695708 697220 732791 813003 528641 501958 418068 425820 479816 408460 572305 688581 595977 599990 770271 501931 502089 525350 487486 733851 615379 388532 820151 826971 815585 710626 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"squirt big cock"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сквирт оргазм большие cock"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сквирт оргазм большие cock"
]
|
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.