Query Metrics
7
Database Queries
7
Different statements
162.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.46 ms (83.76%) |
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 170 69128 74588 111756 133698 154707 160352 191093 197451 219349 256447 300296 330564 382839 383470 383823 389697 390968 391580 394109 397648 398747 400706 400811 402551 410212 415876 424160 424766 429280 432789 434089 444144 446977 450664 453140 454072 456493 462789 483681 490180 507123 516896 525182 533190 533820 536490 536753 539555 547205 584484 586705 591496 613294 617372 618660 629334 630567 634444 645388 645538 645829 650067 660976 663358 663468 664314 665313 665878 667234 667311 667832 667836 669751 669774 672354 672741 675230 675253 677036 690329 690480 693299 695097 707519 715118 718412 724503 726756 729124 734015 734726 736028 737624 740159 750005 754620 754680 759306 759586 760123 768570 768660 773513 774627 776745 781381 781973 788518 788520 790855 795158 797266 798607 799316 800214 800663 810742 828528 828708 ] |
||||||||||||||||||||||||||||||
|
15.27 ms (9.37%) |
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 394109 74588 219349 715118 774627 507123 410212 424160 450664 453140 444144 490180 516896 400706 645829 665313 690329 547205 799316 810742 800663 584484 69128 669751 645388 667234 675230 586705 634444 781381 795158 759586 797266 737624 736028 754680 768570 773513 718412 133698 760123 382839 391580 383823 191093 415876 434089 533820 536490 672354 629334 740159 402551 256447 400811 462789 690480 330564 536753 665878 800214 724503 667311 768660 828528 456493 432789 630567 397648 483681 154707 424766 383470 618660 160352 429280 197451 300296 170 525182 533190 664314 672741 660976 663358 663468 645538 650067 667832 675253 707519 591496 613294 776745 788520 798607 734726 726756 734015 750005 754620 759306 781973 788518 790855 454072 446977 111756 389697 390968 539555 677036 695097 617372 729124 398747 828708 667836 669774 693299 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (1.96%) |
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 170 69128 74588 111756 133698 154707 160352 191093 197451 219349 256447 300296 330564 382839 383470 383823 389697 390968 391580 394109 397648 398747 400706 400811 402551 410212 415876 424160 424766 429280 432789 434089 444144 446977 450664 453140 454072 456493 462789 483681 490180 507123 516896 525182 533190 533820 536490 536753 539555 547205 584484 586705 591496 613294 617372 618660 629334 630567 634444 645388 645538 645829 650067 660976 663358 663468 664314 665313 665878 667234 667311 667832 667836 669751 669774 672354 672741 675230 675253 677036 690329 690480 693299 695097 707519 715118 718412 724503 726756 729124 734015 734726 736028 737624 740159 750005 754620 754680 759306 759586 760123 768570 768660 773513 774627 776745 781381 781973 788518 788520 790855 795158 797266 798607 799316 800214 800663 810742 828528 828708 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.39%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde natural tits"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая натуральная натуральные сиськ без силикон"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.02%) |
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.