Query Metrics
7
Database Queries
7
Different statements
144.61 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:
[
"mature riding me"
]
|
||||||||||||||||||||||||||||||
| 3 | 11.87 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 625175 794747 788557 776993 766658 726879 741177 774690 531323 762288 732809 733504 765250 828788 693087 790336 736740 790328 496312 575904 788057 790334 795230 736620 761774 791783 810717 154015 539643 636651 800520 730391 800914 540248 441570 457912 761162 765729 388783 571781 728548 767604 798852 800891 445361 500417 776204 801361 761743 795233 428709 526709 554559 588559 620108 768031 763876 426550 517766 555377 692314 737850 724698 766624 467939 418966 511346 669202 591928 784528 531431 419319 445869 531496 785500 457034 512528 523768 590759 615711 479425 441099 522976 382071 588068 584720 ] |
||||||||||||||||||||||||||||||
| 4 | 3.15 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 154015 382071 388783 418966 419319 426550 428709 441099 441570 445361 445869 457034 457912 467939 479425 496312 500417 511346 512528 517766 522976 523768 526709 531323 531431 531496 539643 540248 554559 555377 571781 575904 584720 588068 588559 590759 591928 615711 620108 625175 636651 669202 692314 693087 724698 726879 728548 730391 732809 733504 736620 736740 737850 741177 761162 761743 761774 762288 763876 765250 765729 766624 766658 767604 768031 774690 776204 776993 784528 785500 788057 788557 790328 790334 790336 791783 794747 795230 795233 798852 800520 800891 800914 801361 810717 828788 ] |
||||||||||||||||||||||||||||||
| 5 | 121.89 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 154015 382071 388783 418966 419319 426550 428709 441099 441570 445361 445869 457034 457912 467939 479425 496312 500417 511346 512528 517766 522976 523768 526709 531323 531431 531496 539643 540248 554559 555377 571781 575904 584720 588068 588559 590759 591928 615711 620108 625175 636651 669202 692314 693087 724698 726879 728548 730391 732809 733504 736620 736740 737850 741177 761162 761743 761774 762288 763876 765250 765729 766624 766658 767604 768031 774690 776204 776993 784528 785500 788057 788557 790328 790334 790336 791783 794747 795230 795233 798852 800520 800891 800914 801361 810717 828788 ] |
||||||||||||||||||||||||||||||
| 6 | 2.01 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature riding me"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.99 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature riding me"
]
|
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.