Query Metrics
8
Database Queries
8
Different statements
177.57 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.53 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.47 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum on pussy"
]
|
||||||||||||||||||||||||||||||
| 3 | 1.85 ms |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01”Pñö¬pY¨2f4k~p¹"
]
|
||||||||||||||||||||||||||||||
| 4 | 16.54 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 455112 826238 514590 715070 650669 651716 617968 791324 763033 771389 791322 425195 725221 819387 448011 461762 529467 512547 528249 493079 551662 541013 546892 554121 569595 701228 717288 648176 686079 700819 592066 604287 620533 600814 778724 801943 783194 768691 746418 764004 730606 745327 761890 758765 617780 787356 794840 813291 477067 431595 446510 449699 450448 763955 387006 796307 445694 713735 747756 710966 457091 629665 728874 518173 432501 461676 489924 450141 469625 514064 480108 481129 549656 556078 659349 663834 684672 705101 706475 647089 550788 556669 578731 632750 585193 588958 595666 599487 639150 643582 782737 792420 810306 812997 742011 724023 739504 751471 709435 797095 442586 423552 432386 437444 447334 469693 448089 552792 751498 454589 469819 508708 574978 666674 605280 742839 744184 793827 802364 447609 ] |
||||||||||||||||||||||||||||||
| 5 | 2.55 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 387006 423552 425195 431595 432386 432501 437444 442586 445694 446510 447334 447609 448011 448089 449699 450141 450448 454589 455112 457091 461676 461762 469625 469693 469819 477067 480108 481129 489924 493079 508708 512547 514064 514590 518173 528249 529467 541013 546892 549656 550788 551662 552792 554121 556078 556669 569595 574978 578731 585193 588958 592066 595666 599487 600814 604287 605280 617780 617968 620533 629665 632750 639150 643582 647089 648176 650669 651716 659349 663834 666674 684672 686079 700819 701228 705101 706475 709435 710966 713735 715070 717288 724023 725221 728874 730606 739504 742011 742839 744184 745327 746418 747756 751471 751498 758765 761890 763033 763955 764004 768691 771389 778724 782737 783194 787356 791322 791324 792420 793827 794840 796307 797095 801943 802364 810306 812997 813291 819387 826238 ] |
||||||||||||||||||||||||||||||
| 6 | 150.81 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 387006 423552 425195 431595 432386 432501 437444 442586 445694 446510 447334 447609 448011 448089 449699 450141 450448 454589 455112 457091 461676 461762 469625 469693 469819 477067 480108 481129 489924 493079 508708 512547 514064 514590 518173 528249 529467 541013 546892 549656 550788 551662 552792 554121 556078 556669 569595 574978 578731 585193 588958 592066 595666 599487 600814 604287 605280 617780 617968 620533 629665 632750 639150 643582 647089 648176 650669 651716 659349 663834 666674 684672 686079 700819 701228 705101 706475 709435 710966 713735 715070 717288 724023 725221 728874 730606 739504 742011 742839 744184 745327 746418 747756 751471 751498 758765 761890 763033 763955 764004 768691 771389 778724 782737 783194 787356 791322 791324 792420 793827 794840 796307 797095 801943 802364 810306 812997 813291 819387 826238 ] |
||||||||||||||||||||||||||||||
| 7 | 1.57 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum pussy"
]
|
||||||||||||||||||||||||||||||
| 8 | 1.26 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.