Query Metrics
7
Database Queries
7
Different statements
165.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.54 ms (81.34%) |
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 3398 34486 132148 361978 382562 383940 387415 389611 389858 390769 390918 391155 396403 396971 397870 401201 408518 411953 445920 455973 457994 457996 466990 471411 497701 498629 500795 504059 512531 515078 538957 563730 566535 567412 567415 583514 584104 589576 589771 591257 591281 591877 591910 593856 600384 606044 606384 606595 614292 614733 644706 692049 707283 707284 710588 712310 715497 715521 719897 720470 721818 726731 729017 732580 732852 734394 735484 735893 740890 742032 745516 745993 746025 746052 746739 750878 753246 753707 758151 758397 761275 761538 765632 765640 766606 766610 775024 775054 775826 779348 789619 794670 795141 796450 799631 800035 801402 806084 808506 811088 811118 817070 817315 817710 817714 817954 818624 818663 819044 819075 819480 819490 820142 820373 825114 826759 827314 827421 827514 827533 ] |
||||||||||||||||||||||||||||||
|
21.71 ms (13.13%) |
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 735484 589576 593856 591257 397870 606044 515078 765632 389611 391155 794670 801402 818663 715521 726731 789619 719897 746739 827314 390769 827514 745516 758151 707284 761538 408518 799631 808506 750878 382562 819480 818624 497701 732852 826759 563730 390918 819490 3398 504059 746025 746052 820373 817954 819075 817710 827421 817315 753246 734394 132148 820142 396971 819044 692049 765640 566535 795141 800035 811088 729017 745993 387415 817070 361978 732580 796450 811118 500795 567415 591877 766606 825114 779348 758397 583514 720470 644706 589771 742032 753707 715497 411953 457994 538957 606595 735893 445920 591910 396403 466990 584104 710588 567412 383940 455973 600384 721818 34486 498629 606384 775024 766610 775826 512531 591281 614292 401201 457996 817714 827533 471411 707283 712310 740890 806084 761275 389858 614733 775054 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.48%) |
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 3398 34486 132148 361978 382562 383940 387415 389611 389858 390769 390918 391155 396403 396971 397870 401201 408518 411953 445920 455973 457994 457996 466990 471411 497701 498629 500795 504059 512531 515078 538957 563730 566535 567412 567415 583514 584104 589576 589771 591257 591281 591877 591910 593856 600384 606044 606384 606595 614292 614733 644706 692049 707283 707284 710588 712310 715497 715521 719897 720470 721818 726731 729017 732580 732852 734394 735484 735893 740890 742032 745516 745993 746025 746052 746739 750878 753246 753707 758151 758397 761275 761538 765632 765640 766606 766610 775024 775054 775826 779348 789619 794670 795141 796450 799631 800035 801402 806084 808506 811088 811118 817070 817315 817710 817714 817954 818624 818663 819044 819075 819480 819490 820142 820373 825114 826759 827314 827421 827514 827533 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"german mature sex"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"german mature секс"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"german mature секс"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.85%) |
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.