Query Metrics
7
Database Queries
7
Different statements
103.79 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.77 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.90 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian mature gangbang"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.59 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 428412 534143 474648 443761 731775 443387 474629 474694 474685 474659 443334 506051 474693 484387 474695 443777 474678 470617 484563 474686 474702 474654 474689 476015 484693 470047 522610 535593 534034 805143 544181 580263 358596 485703 535620 443786 559061 617652 458555 474680 597018 484392 422342 474696 559060 484389 534631 667017 510750 546993 425181 683301 536290 552938 775960 775967 423940 644971 606467 775866 775848 775963 531172 533697 567581 590560 600354 775958 477097 543652 620098 683261 590411 662137 555805 730798 601584 599964 597963 671863 583500 521453 ] |
||||||||||||||||||||||||||||||
| 4 | 2.29 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 358596 422342 423940 425181 428412 443334 443387 443761 443777 443786 458555 470047 470617 474629 474648 474654 474659 474678 474680 474685 474686 474689 474693 474694 474695 474696 474702 476015 477097 484387 484389 484392 484563 484693 485703 506051 510750 521453 522610 531172 533697 534034 534143 534631 535593 535620 536290 543652 544181 546993 552938 555805 559060 559061 567581 580263 583500 590411 590560 597018 597963 599964 600354 601584 606467 617652 620098 644971 662137 667017 671863 683261 683301 730798 731775 775848 775866 775958 775960 775963 775967 805143 ] |
||||||||||||||||||||||||||||||
| 5 | 78.75 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 358596 422342 423940 425181 428412 443334 443387 443761 443777 443786 458555 470047 470617 474629 474648 474654 474659 474678 474680 474685 474686 474689 474693 474694 474695 474696 474702 476015 477097 484387 484389 484392 484563 484693 485703 506051 510750 521453 522610 531172 533697 534034 534143 534631 535593 535620 536290 543652 544181 546993 552938 555805 559060 559061 567581 580263 583500 590411 590560 597018 597963 599964 600354 601584 606467 617652 620098 644971 662137 667017 671863 683261 683301 730798 731775 775848 775866 775958 775960 775963 775967 805143 ] |
||||||||||||||||||||||||||||||
| 6 | 1.86 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск mature gangbang"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.63 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск mature 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.