Query Metrics
7
Database Queries
7
Different statements
174.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.04 ms (84.15%) |
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 6710 392687 401114 401274 404308 404459 409861 411189 411971 414769 420178 426043 426416 426616 430481 432637 432699 433038 433302 433316 435245 437663 445891 446964 449024 452000 452128 454668 454979 464201 465256 469470 475273 475629 477069 479785 482192 482679 483731 487708 494333 495561 503118 503241 506034 506281 507512 514912 517779 522405 524318 531557 532444 533791 534554 535417 545470 547556 547865 549815 550337 550672 551817 558720 560804 582767 583607 587854 588144 589718 591357 597646 616915 621524 627316 628681 633815 634770 638557 642742 684048 696426 696513 707856 714543 726839 733317 737181 750747 761028 766623 767183 767271 769310 770192 789690 790879 792560 793340 797447 797562 801240 801327 802182 809414 809479 810669 813391 814399 815442 815520 815559 815714 815865 816115 817213 817256 818387 826130 ] |
||||||||||||||||||||||||||||||
|
16.98 ms (9.72%) |
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 495561 482192 550672 696513 634770 642742 589718 628681 797447 801240 809414 809479 726839 494333 454979 558720 545470 588144 433302 426416 507512 822998 714543 6710 815442 815714 816115 818387 826130 814399 815520 815559 815865 817213 449024 464201 477069 483731 454668 533791 532444 547865 549815 696426 583607 638557 591357 597646 633815 627316 802182 810669 793340 769310 792560 767183 770192 733317 761028 766623 790879 797562 475273 404459 433316 452000 547556 551817 587854 401114 426043 465256 487708 531557 707856 621524 750747 560804 430481 404308 411189 409861 801327 517779 535417 401274 426616 411971 435245 452128 514912 506281 503241 506034 475629 582767 550337 684048 616915 813391 737181 767271 392687 420178 524318 522405 503118 817256 534554 414769 789690 446964 433038 432637 432699 437663 482679 479785 469470 445891 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (1.81%) |
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 6710 392687 401114 401274 404308 404459 409861 411189 411971 414769 420178 426043 426416 426616 430481 432637 432699 433038 433302 433316 435245 437663 445891 446964 449024 452000 452128 454668 454979 464201 465256 469470 475273 475629 477069 479785 482192 482679 483731 487708 494333 495561 503118 503241 506034 506281 507512 514912 517779 522405 524318 531557 532444 533791 534554 535417 545470 547556 547865 549815 550337 550672 551817 558720 560804 582767 583607 587854 588144 589718 591357 597646 616915 621524 627316 628681 633815 634770 638557 642742 684048 696426 696513 707856 714543 726839 733317 737181 750747 761028 766623 767183 767271 769310 770192 789690 790879 792560 793340 797447 797562 801240 801327 802182 809414 809479 810669 813391 814399 815442 815520 815559 815714 815865 816115 817213 817256 818387 826130 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina milf anal"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская milf анал"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"латинская milf анал"
]
|
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.