Query Metrics
7
Database Queries
7
Different statements
173.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.72 ms (83.86%) |
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 384275 410851 415878 419664 426796 428799 443516 447600 448140 448641 448896 449404 450549 454006 454744 454905 456226 458124 458942 459657 461013 466394 466439 466700 468222 468992 469167 469171 469519 482698 484241 484533 488757 489377 498539 507340 511039 512031 513816 513820 515372 516747 524796 525373 526444 526534 537777 539438 541723 542097 547807 550175 550367 552373 552707 553134 554049 554528 559216 559356 562386 564144 567054 568107 568134 575402 577834 577875 579604 580023 580206 580629 582336 583245 589970 594048 596306 596632 596657 601672 604634 604785 604803 607509 607959 611523 615693 617445 618687 621742 625633 626037 629851 642331 646167 661915 664660 669907 708517 709024 735910 738532 741756 750453 752661 752670 757436 760859 763739 774699 777688 785110 800497 804281 807599 809076 810103 812749 813227 825751 ] |
||||||||||||||||||||||||||||||
|
18.10 ms (10.42%) |
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 468992 542097 559356 575402 601672 604634 807599 804281 448896 458124 469171 513816 604803 507340 580629 552707 580023 580206 596657 466439 513820 498539 618687 760859 468222 469167 456226 410851 415878 825751 482698 454006 454905 469519 484533 450549 466700 459657 526444 539438 537777 559216 567054 568107 562386 579604 577875 646167 669907 664660 708517 661915 550367 582336 596632 611523 617445 626037 607509 629851 642331 607959 777688 785110 809076 810103 774699 741756 812749 738532 735910 750453 757436 763739 615693 621742 813227 419664 426796 428799 458942 461013 466394 525373 526534 484241 524796 515372 512031 550175 554528 564144 568134 583245 552373 554049 709024 553134 577834 594048 596306 604785 589970 625633 800497 752670 448641 384275 454744 516747 488757 541723 489377 752661 443516 447600 448140 449404 511039 547807 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.48%) |
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 384275 410851 415878 419664 426796 428799 443516 447600 448140 448641 448896 449404 450549 454006 454744 454905 456226 458124 458942 459657 461013 466394 466439 466700 468222 468992 469167 469171 469519 482698 484241 484533 488757 489377 498539 507340 511039 512031 513816 513820 515372 516747 524796 525373 526444 526534 537777 539438 541723 542097 547807 550175 550367 552373 552707 553134 554049 554528 559216 559356 562386 564144 567054 568107 568134 575402 577834 577875 579604 580023 580206 580629 582336 583245 589970 594048 596306 596632 596657 601672 604634 604785 604803 607509 607959 611523 615693 617445 618687 621742 625633 626037 629851 642331 646167 661915 664660 669907 708517 709024 735910 738532 741756 750453 752661 752670 757436 760859 763739 774699 777688 785110 800497 804281 807599 809076 810103 812749 813227 825751 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot solo ass"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot соло жоп"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.99%) |
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.