Query Metrics
7
Database Queries
7
Different statements
269.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
246.92 ms (91.60%) |
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 130105 383211 395137 400965 403641 405050 419773 429793 431105 455851 466552 472550 478572 484392 522134 530019 530380 530484 530630 531172 531175 531230 532741 532837 532960 534386 534627 536285 536290 536339 536562 536579 536616 536651 537590 537908 539239 543598 543614 543615 543627 544797 544803 544812 545076 550307 551034 554462 559061 559214 567134 581711 584001 589462 596462 597225 598024 599479 599890 600251 600332 600354 606501 610577 621482 622925 622990 630915 633747 634131 634185 636311 636564 637416 637438 639735 639762 639793 639802 640534 641130 642706 644982 645952 647663 647885 647914 648815 649595 650175 650762 651079 651188 651609 653447 666866 667017 670117 673570 674978 675019 676092 676622 676623 678121 678517 678533 679721 679728 680127 684019 694058 716222 716882 723620 733842 748244 756386 776022 815413 ] |
||||||||||||||||||||||||||||||
|
14.26 ms (5.29%) |
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 776022 429793 530630 676623 599890 610577 130105 581711 567134 598024 642706 383211 395137 403641 644982 815413 478572 455851 531175 537590 530019 530484 530380 534386 559214 551034 543598 545076 667017 670117 679721 684019 716222 673570 676622 680127 694058 651609 589462 597225 621482 622990 636564 637438 639735 599479 600251 622925 630915 640534 733842 748244 756386 641130 405050 466552 484392 522134 400965 419773 431105 723620 472550 531230 534627 536285 536290 536562 536651 537908 539239 532741 532960 536339 536579 531172 532837 536616 543614 554462 559061 543615 543627 544803 544812 647663 650175 666866 674978 678517 679728 650762 651079 653447 678121 678533 716882 645952 647885 647914 648815 649595 651188 675019 676092 544797 550307 584001 600332 633747 634131 634185 636311 596462 606501 637416 639762 639793 639802 600354 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.00%) |
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 130105 383211 395137 400965 403641 405050 419773 429793 431105 455851 466552 472550 478572 484392 522134 530019 530380 530484 530630 531172 531175 531230 532741 532837 532960 534386 534627 536285 536290 536339 536562 536579 536616 536651 537590 537908 539239 543598 543614 543615 543627 544797 544803 544812 545076 550307 551034 554462 559061 559214 567134 581711 584001 589462 596462 597225 598024 599479 599890 600251 600332 600354 606501 610577 621482 622925 622990 630915 633747 634131 634185 636311 636564 637416 637438 639735 639762 639793 639802 640534 641130 642706 644982 645952 647663 647885 647914 648815 649595 650175 650762 651079 651188 651609 653447 666866 667017 670117 673570 674978 675019 676092 676622 676623 678121 678517 678533 679721 679728 680127 684019 694058 716222 716882 723620 733842 748244 756386 776022 815413 ] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.54%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп gangbang"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.52%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.28 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие жоп gangbang"
]
|
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.