Query Metrics
7
Database Queries
7
Different statements
150.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.40 ms (83.13%) |
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 2926 6643 145956 181096 184943 185332 370905 384348 386740 388161 390810 397510 397997 399413 400977 406071 408694 411729 413254 415518 424407 425510 429341 433684 434167 446734 447806 448403 456867 457119 458028 459472 462818 468301 475023 476146 476156 478897 479919 484221 489448 489924 490595 500700 516077 519753 519818 525778 532103 536496 544898 554459 560828 575360 577666 577692 578762 580824 586271 586950 587961 588674 591288 591536 592690 592945 593510 596792 599354 603814 605687 606515 609623 610209 612313 618662 628563 628633 629799 630664 631459 634758 643201 650431 662876 666021 670220 674741 680530 685526 686088 696587 702609 710268 712234 718408 720264 724467 724514 726348 735871 740912 748478 756494 758919 759731 760175 770038 773840 780588 781792 810014 811125 817694 823989 824735 825063 825170 825396 825892 ] |
||||||||||||||||||||||||||||||
|
16.00 ms (10.61%) |
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 718408 666021 685526 720264 560828 577692 578762 580824 586950 591288 592690 612313 591536 603814 592945 593510 596792 605687 643201 781792 811125 724467 726348 758919 735871 748478 609623 630664 434167 459472 388161 525778 575360 628563 631459 740912 606515 415518 519753 587961 628633 629799 399413 489448 408694 386740 2926 400977 6643 184943 462818 825396 425510 825170 696587 618662 650431 670220 448403 588674 490595 817694 532103 446734 424407 479919 476146 476156 519818 544898 554459 577666 662876 599354 759731 702609 710268 413254 406071 484221 457119 478897 468301 185332 429341 370905 181096 825892 397997 824735 447806 489924 456867 458028 475023 433684 397510 516077 500700 680530 823989 825063 536496 686088 712234 674741 634758 586271 780588 810014 770038 724514 760175 756494 773840 145956 390810 411729 610209 384348 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.65%) |
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 2926 6643 145956 181096 184943 185332 370905 384348 386740 388161 390810 397510 397997 399413 400977 406071 408694 411729 413254 415518 424407 425510 429341 433684 434167 446734 447806 448403 456867 457119 458028 459472 462818 468301 475023 476146 476156 478897 479919 484221 489448 489924 490595 500700 516077 519753 519818 525778 532103 536496 544898 554459 560828 575360 577666 577692 578762 580824 586271 586950 587961 588674 591288 591536 592690 592945 593510 596792 599354 603814 605687 606515 609623 610209 612313 618662 628563 628633 629799 630664 631459 634758 643201 650431 662876 666021 670220 674741 680530 685526 686088 696587 702609 710268 712234 718408 720264 724467 724514 726348 735871 740912 748478 756494 758919 759731 760175 770038 773840 780588 781792 810014 811125 817694 823989 824735 825063 825170 825396 825892 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits natural hairy"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ натуральная натуральные волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.