Query Metrics
7
Database Queries
7
Different statements
176.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.56 ms (84.73%) |
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 6866 383785 386497 389596 390601 414119 414138 418467 420816 427916 439532 445455 446958 454098 458689 458942 469519 475419 485666 491107 495566 497829 515791 516565 516601 518818 526252 526534 535644 535807 536608 536631 539557 543061 543726 549153 550677 576981 580265 581083 585453 585783 592187 593495 594946 601672 602268 603717 604162 605851 618619 620055 623279 624751 629479 629598 632697 640348 654097 667254 669319 672821 673573 683275 689794 693225 693675 697579 699313 708145 708597 708626 710800 713323 720138 735498 742298 745872 747140 747356 747468 749237 749611 749669 750448 751433 753135 755032 756745 766419 770221 770483 770610 775240 777667 778815 784010 784403 784980 785752 786344 786368 786600 787023 790461 791337 795979 797046 798601 799944 802732 804104 804444 806444 807593 808623 808699 808781 819950 826018 ] |
||||||||||||||||||||||||||||||
|
16.68 ms (9.45%) |
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 745872 543726 819950 654097 713323 669319 708626 640348 603717 784010 699313 420816 581083 804104 683275 778815 623279 389596 592187 458942 390601 576981 491107 516565 535807 708597 710800 775240 784403 750448 799944 755032 516601 383785 485666 747468 689794 585453 777667 791337 807593 735498 697579 790461 458689 602268 543061 6866 446958 414119 469519 580265 601672 618619 475419 526534 673573 667254 787023 550677 427916 539557 624751 804444 770221 439532 535644 747140 786600 786344 756745 749611 749669 454098 495566 526252 536608 594946 605851 414138 708145 629598 784980 785752 786368 806444 797046 632697 445455 418467 549153 593495 620055 798601 747356 515791 497829 770483 808699 826018 585783 604162 795979 802732 753135 770610 742298 766419 629479 720138 808781 518818 672821 693225 693675 808623 749237 751433 386497 536631 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (1.80%) |
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 6866 383785 386497 389596 390601 414119 414138 418467 420816 427916 439532 445455 446958 454098 458689 458942 469519 475419 485666 491107 495566 497829 515791 516565 516601 518818 526252 526534 535644 535807 536608 536631 539557 543061 543726 549153 550677 576981 580265 581083 585453 585783 592187 593495 594946 601672 602268 603717 604162 605851 618619 620055 623279 624751 629479 629598 632697 640348 654097 667254 669319 672821 673573 683275 689794 693225 693675 697579 699313 708145 708597 708626 710800 713323 720138 735498 742298 745872 747140 747356 747468 749237 749611 749669 750448 751433 753135 755032 756745 766419 770221 770483 770610 775240 777667 778815 784010 784403 784980 785752 786344 786368 786600 787023 790461 791337 795979 797046 798601 799944 802732 804104 804444 806444 807593 808623 808699 808781 819950 826018 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo hot girl"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд hot девушк"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд hot девушк"
]
|
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.