Query Metrics
7
Database Queries
7
Different statements
224.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
200.42 ms (89.43%) |
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 45868 75626 85303 148408 338809 382731 385285 387080 395949 399965 407421 423772 423956 426647 432458 432477 432486 432507 432509 433596 437587 458662 466560 473059 475374 476799 478570 479379 480332 482068 485065 485869 485878 492905 495129 505135 506379 508407 514001 515053 515614 515621 515736 519796 528529 534974 541823 553685 555640 560234 563330 575552 576131 576833 588600 588887 589601 590148 595358 600824 601487 602811 606663 607583 608253 608787 610697 614857 622892 631481 641043 657788 660054 663780 675871 677861 679204 686323 686391 695801 696376 696774 711749 712094 715065 716201 724483 726166 734343 740175 740875 743891 754537 759362 761517 765411 773924 780788 781251 781857 781875 785916 786776 789100 790462 791314 792701 797275 800474 800799 806476 813104 814154 823171 823706 828446 828660 828769 828789 828804 ] |
||||||||||||||||||||||||||||||
|
13.75 ms (6.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 715065 781251 806476 560234 576833 590148 423772 602811 614857 631481 433596 466560 608253 519796 712094 686391 75626 423956 657788 563330 479379 338809 407421 555640 740875 148408 475374 515614 399965 695801 485065 492905 528529 553685 716201 677861 679204 696376 696774 601487 595358 785916 813104 780788 786776 800474 743891 781875 724483 726166 761517 773924 781857 800799 432486 432507 485878 506379 828446 610697 828789 828804 828660 607583 606663 395949 85303 663780 675871 686323 576131 600824 641043 790462 791314 734343 792701 797275 759362 740175 754537 765411 711749 382731 482068 814154 828769 823171 823706 622892 789100 660054 514001 515053 588887 437587 505135 485869 541823 588600 432458 432477 458662 426647 476799 515621 515736 387080 385285 534974 480332 432509 473059 608787 575552 45868 495129 478570 589601 508407 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.30%) |
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 45868 75626 85303 148408 338809 382731 385285 387080 395949 399965 407421 423772 423956 426647 432458 432477 432486 432507 432509 433596 437587 458662 466560 473059 475374 476799 478570 479379 480332 482068 485065 485869 485878 492905 495129 505135 506379 508407 514001 515053 515614 515621 515736 519796 528529 534974 541823 553685 555640 560234 563330 575552 576131 576833 588600 588887 589601 590148 595358 600824 601487 602811 606663 607583 608253 608787 610697 614857 622892 631481 641043 657788 660054 663780 675871 677861 679204 686323 686391 695801 696376 696774 711749 712094 715065 716201 724483 726166 734343 740175 740875 743891 754537 759362 761517 765411 773924 780788 781251 781857 781875 785916 786776 789100 790462 791314 792701 797275 800474 800799 806476 813104 814154 823171 823706 828446 828660 828769 828789 828804 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife stockings"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.73%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.