Query Metrics
7
Database Queries
7
Different statements
170.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.17 ms (84.96%) |
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 16559 29148 232978 384050 385297 388346 400685 401390 401589 402700 402771 403187 403419 405707 409811 417989 420001 424242 429590 429706 437617 455113 457134 458357 461474 462044 470042 471916 473977 476388 485364 492824 493484 494398 504581 506602 508117 509500 511193 512641 512653 513603 521192 524707 535934 537982 549999 568351 570466 576165 580986 596620 597085 598783 611521 631358 640469 652865 654825 655428 655662 655663 656957 657416 658690 660523 663247 663250 669414 669642 675817 689212 695097 709501 718768 721367 721433 721595 722833 723234 736908 739622 740705 744860 751603 751627 753456 753459 753462 753467 755891 756672 763079 765270 765803 765840 765859 766537 770637 777893 778638 778752 779607 785377 785382 787410 787923 788901 797809 799802 802596 803230 803581 807324 807594 808468 810497 814339 825540 825830 ] |
||||||||||||||||||||||||||||||
|
15.49 ms (9.07%) |
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 384050 402771 470042 476388 16559 403187 437617 455113 493484 494398 509500 803230 825540 656957 669642 654825 655428 655662 657416 658690 669414 675817 640469 778638 810497 740705 755891 770637 825830 549999 580986 576165 723234 660523 721433 598783 611521 596620 631358 797809 799802 807324 777893 778752 808468 751603 802596 807594 739622 756672 751627 765270 765859 766537 744860 753459 753462 753467 763079 765840 736908 753456 765803 718768 721367 779607 785377 785382 788901 803581 417989 462044 458357 485364 535934 504581 403419 513603 521192 511193 506602 232978 429706 29148 401390 570466 655663 695097 787410 787923 424242 471916 473977 385297 400685 402700 405707 461474 388346 401589 409811 420001 429590 492824 524707 508117 512641 512653 814339 457134 537982 568351 663250 689212 722833 663247 721595 652865 709501 597085 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.69%) |
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 16559 29148 232978 384050 385297 388346 400685 401390 401589 402700 402771 403187 403419 405707 409811 417989 420001 424242 429590 429706 437617 455113 457134 458357 461474 462044 470042 471916 473977 476388 485364 492824 493484 494398 504581 506602 508117 509500 511193 512641 512653 513603 521192 524707 535934 537982 549999 568351 570466 576165 580986 596620 597085 598783 611521 631358 640469 652865 654825 655428 655662 655663 656957 657416 658690 660523 663247 663250 669414 669642 675817 689212 695097 709501 718768 721367 721433 721595 722833 723234 736908 739622 740705 744860 751603 751627 753456 753459 753462 753467 755891 756672 763079 765270 765803 765840 765859 766537 770637 777893 778638 778752 779607 785377 785382 787410 787923 788901 797809 799802 802596 803230 803581 807324 807594 808468 810497 814339 825540 825830 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"beauty русск"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beauty russian"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"beauty русск"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.98%) |
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.