Query Metrics
7
Database Queries
7
Different statements
213.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
184.12 ms (86.41%) |
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 23670 150405 185223 381769 382499 387006 387052 390190 390219 390730 405224 406416 419967 434281 436628 444007 446860 449168 453295 457018 457767 459760 465687 466219 469820 469825 471305 477168 477767 488558 496720 498869 509780 516542 528540 530237 538333 541092 548081 550425 551319 551394 552232 558383 565941 569454 569828 573932 584389 587879 593330 600267 601313 607220 608346 608606 615004 617743 618319 618654 618659 624520 628614 628758 631129 636520 637037 637399 641711 643886 651881 656270 658706 665645 668765 672485 681525 681802 682268 683288 685086 688832 689523 695292 697178 710305 712726 717119 717327 719504 730498 730948 731604 732922 736852 739300 744457 744481 744730 746773 749623 750208 750922 756460 758755 767616 772511 777859 785125 786481 789916 793001 795548 796200 796855 801784 804686 806415 812522 828466 ] |
||||||||||||||||||||||||||||||
|
17.33 ms (8.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 558383 573932 624520 628614 608346 446860 496720 469820 550425 695292 668765 756460 382499 528540 641711 796200 569454 457767 628758 615004 828466 436628 459760 477168 469825 471305 498869 584389 672485 682268 697178 551319 749623 406416 23670 712726 637037 744730 736852 683288 618319 812522 795548 804686 793001 744481 732922 449168 565941 569828 541092 617743 419967 465687 488558 390730 710305 658706 665645 681802 618659 750208 746773 618654 643886 552232 185223 387006 390190 453295 651881 551394 587879 600267 405224 150405 381769 390219 457018 477767 681525 688832 685086 548081 806415 777859 786481 796855 758755 772511 730498 739300 767616 731604 717327 789916 801784 444007 601313 593330 434281 466219 516542 509780 608606 387052 530237 637399 607220 631129 538333 656270 717119 719504 689523 636520 785125 744457 750922 730948 ] |
||||||||||||||||||||||||||||||
|
4.23 ms (1.99%) |
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 23670 150405 185223 381769 382499 387006 387052 390190 390219 390730 405224 406416 419967 434281 436628 444007 446860 449168 453295 457018 457767 459760 465687 466219 469820 469825 471305 477168 477767 488558 496720 498869 509780 516542 528540 530237 538333 541092 548081 550425 551319 551394 552232 558383 565941 569454 569828 573932 584389 587879 593330 600267 601313 607220 608346 608606 615004 617743 618319 618654 618659 624520 628614 628758 631129 636520 637037 637399 641711 643886 651881 656270 658706 665645 668765 672485 681525 681802 682268 683288 685086 688832 689523 695292 697178 710305 712726 717119 717327 719504 730498 730948 731604 732922 736852 739300 744457 744481 744730 746773 749623 750208 750922 756460 758755 767616 772511 777859 785125 786481 789916 793001 795548 796200 796855 801784 804686 806415 812522 828466 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"massage erotic"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"массаж эротик"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"массаж эротик"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.73%) |
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.