Query Metrics
7
Database Queries
7
Different statements
176.78 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.80 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.84 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"piss in shower"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.96 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 650139 662796 680937 697555 670266 670853 699562 545337 548879 589337 595605 615053 794240 796919 811270 794669 741441 729256 612553 640859 707391 666894 599987 584539 814757 555186 557634 560218 566325 551535 551894 555360 677892 651627 666472 668628 672311 681251 712311 551903 552134 586926 592890 630850 636111 614865 789799 809909 737857 706286 618177 585050 549763 565571 565997 567493 570735 548422 548559 672424 578642 590730 597234 600438 620395 809292 738785 623135 776940 425148 518581 554826 561488 562067 579495 585331 608541 558622 579707 567277 618622 615714 666904 647635 633819 600995 598105 541699 557676 674994 ] |
||||||||||||||||||||||||||||||
| 4 | 3.87 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 425148 518581 541699 545337 548422 548559 548879 549763 551535 551894 551903 552134 554826 555186 555360 557634 557676 558622 560218 561488 562067 565571 565997 566325 567277 567493 570735 578642 579495 579707 584539 585050 585331 586926 589337 590730 592890 595605 597234 598105 599987 600438 600995 608541 612553 614865 615053 615714 618177 618622 620395 623135 630850 633819 636111 640859 647635 650139 651627 662796 666472 666894 666904 668628 670266 670853 672311 672424 674994 677892 680937 681251 697555 699562 706286 707391 712311 729256 737857 738785 741441 776940 789799 794240 794669 796919 809292 809909 811270 814757 ] |
||||||||||||||||||||||||||||||
| 5 | 148.41 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 425148 518581 541699 545337 548422 548559 548879 549763 551535 551894 551903 552134 554826 555186 555360 557634 557676 558622 560218 561488 562067 565571 565997 566325 567277 567493 570735 578642 579495 579707 584539 585050 585331 586926 589337 590730 592890 595605 597234 598105 599987 600438 600995 608541 612553 614865 615053 615714 618177 618622 620395 623135 630850 633819 636111 640859 647635 650139 651627 662796 666472 666894 666904 668628 670266 670853 672311 672424 674994 677892 680937 681251 697555 699562 706286 707391 712311 729256 737857 738785 741441 776940 789799 794240 794669 796919 809292 809909 811270 814757 ] |
||||||||||||||||||||||||||||||
| 6 | 1.87 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"писсинг shower"
]
|
||||||||||||||||||||||||||||||
| 7 | 2.02 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"писсинг shower"
]
|
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.