Query Metrics
8
Database Queries
8
Different statements
171.79 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.59 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.10 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum on pussy"
]
|
||||||||||||||||||||||||||||||
| 3 | 2.06 ms |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01”Pñö¬pY¨2f4k~p¹"
]
|
||||||||||||||||||||||||||||||
| 4 | 18.35 ms |
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 725227 725519 727893 744165 750646 770951 773187 803566 732884 733946 734620 746054 749762 723889 730153 736446 745535 761305 743037 768291 770965 697593 785454 797665 802333 459083 468853 590459 793830 568741 596823 818465 519846 665770 684201 795257 736285 716941 783839 817048 816113 824531 814248 479576 483503 527690 539371 508696 546040 699277 716418 648167 659200 677589 692099 592261 613774 619363 627658 630136 627756 605564 777963 796564 779365 780133 781913 796027 803591 743350 790084 730312 737662 749878 736379 735902 770367 635313 635415 783145 791600 413431 485382 452697 452756 417547 455573 436526 818009 825686 462057 508210 495106 565880 583534 564069 583363 684492 702275 705715 653688 678807 696231 699237 705834 680432 693755 576210 602988 619559 607246 622701 782761 786986 799740 805189 724913 735528 784978 793825 ] |
||||||||||||||||||||||||||||||
| 5 | 2.89 ms |
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 413431 417547 436526 452697 452756 455573 459083 462057 468853 479576 483503 485382 495106 508210 508696 519846 527690 539371 546040 564069 565880 568741 576210 583363 583534 590459 592261 596823 602988 605564 607246 613774 619363 619559 622701 627658 627756 630136 635313 635415 648167 653688 659200 665770 677589 678807 680432 684201 684492 692099 693755 696231 697593 699237 699277 702275 705715 705834 716418 716941 723889 724913 725227 725519 727893 730153 730312 732884 733946 734620 735528 735902 736285 736379 736446 737662 743037 743350 744165 745535 746054 749762 749878 750646 761305 768291 770367 770951 770965 773187 777963 779365 780133 781913 782761 783145 783839 784978 785454 786986 790084 791600 793825 793830 795257 796027 796564 797665 799740 802333 803566 803591 805189 814248 816113 817048 818009 818465 824531 825686 ] |
||||||||||||||||||||||||||||||
| 6 | 141.54 ms |
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 413431 417547 436526 452697 452756 455573 459083 462057 468853 479576 483503 485382 495106 508210 508696 519846 527690 539371 546040 564069 565880 568741 576210 583363 583534 590459 592261 596823 602988 605564 607246 613774 619363 619559 622701 627658 627756 630136 635313 635415 648167 653688 659200 665770 677589 678807 680432 684201 684492 692099 693755 696231 697593 699237 699277 702275 705715 705834 716418 716941 723889 724913 725227 725519 727893 730153 730312 732884 733946 734620 735528 735902 736285 736379 736446 737662 743037 743350 744165 745535 746054 749762 749878 750646 761305 768291 770367 770951 770965 773187 777963 779365 780133 781913 782761 783145 783839 784978 785454 786986 790084 791600 793825 793830 795257 796027 796564 797665 799740 802333 803566 803591 805189 814248 816113 817048 818009 818465 824531 825686 ] |
||||||||||||||||||||||||||||||
| 7 | 1.66 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum pussy"
]
|
||||||||||||||||||||||||||||||
| 8 | 1.59 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum pussy"
]
|
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.