Query Metrics
7
Database Queries
7
Different statements
157.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.12 ms (84.49%) |
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 102441 287979 382902 389514 391034 398949 409097 453583 457045 458984 473997 475394 495070 500290 508635 510882 522401 522531 527072 531244 531980 532774 534325 536167 541032 542587 543899 544677 545849 546662 548362 548583 554167 557813 568048 570314 571236 578459 579179 579671 595252 598243 599818 607005 610851 615898 616667 620465 628065 628447 628896 629514 630135 634903 635768 639530 639918 641391 642603 643434 644626 645065 645721 647256 647402 648626 649558 651665 653316 655113 655920 656212 656659 657641 658336 663863 670649 681363 684630 687118 688773 689405 690002 701350 704489 705487 706654 707346 707448 721277 722155 723948 724829 729122 729971 729992 733986 742284 748065 749475 752042 753121 753238 754229 762348 763803 786465 794731 810855 811419 817953 819210 819757 819758 827311 828208 828847 ] |
||||||||||||||||||||||||||||||
|
12.91 ms (8.19%) |
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 748065 742284 620465 639918 794731 382902 287979 389514 817953 828847 473997 536167 508635 543899 544677 570314 557813 579671 645065 653316 663863 670649 707448 647256 648626 684630 647402 655920 657641 689405 704489 705487 554167 568048 629514 786465 729971 733986 753121 724829 729992 754229 762348 729122 753238 607005 634903 721277 391034 457045 475394 458984 531244 495070 510882 527072 500290 534325 548583 579179 545849 571236 542587 578459 628065 628447 598243 644626 615898 595252 630135 409097 398949 453583 102441 819210 827311 819758 824210 819757 828208 827843 522531 531980 522401 532774 546662 541032 548362 645721 649558 651665 655113 656659 687118 690002 701350 706654 707346 722155 656212 658336 681363 688773 616667 635768 642603 643434 610851 628896 599818 639530 641391 811419 723948 749475 752042 763803 763882 810855 ] |
||||||||||||||||||||||||||||||
|
3.92 ms (2.49%) |
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 102441 287979 382902 389514 391034 398949 409097 453583 457045 458984 473997 475394 495070 500290 508635 510882 522401 522531 527072 531244 531980 532774 534325 536167 541032 542587 543899 544677 545849 546662 548362 548583 554167 557813 568048 570314 571236 578459 579179 579671 595252 598243 599818 607005 610851 615898 616667 620465 628065 628447 628896 629514 630135 634903 635768 639530 639918 641391 642603 643434 644626 645065 645721 647256 647402 648626 649558 651665 653316 655113 655920 656212 656659 657641 658336 663863 670649 681363 684630 687118 688773 689405 690002 701350 704489 705487 706654 707346 707448 721277 722155 723948 724829 729122 729971 729992 733986 742284 748065 749475 752042 753121 753238 754229 762348 763803 786465 794731 810855 811419 817953 819210 819757 819758 827311 828208 828847 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"riding cock"
]
|
||||||||||||||||||||||||||||||
|
2.17 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"riding on cock"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"riding 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.