Query Metrics
7
Database Queries
7
Different statements
153.69 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.18 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.49 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen interracial gangbang"
]
|
||||||||||||||||||||||||||||||
| 3 | 26.42 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 551223 696582 650198 674962 674988 704523 647355 674975 545393 628334 637093 637422 591695 604528 632707 637008 637101 637729 643067 601595 605449 745384 632283 632635 633446 633775 639292 418363 451256 421093 520775 521829 517743 637074 624270 531247 467608 543858 648560 676638 667748 676636 557676 623196 630550 634115 642706 614308 615717 632595 634769 632269 632616 632978 507880 540437 545389 545409 545488 553272 675006 677777 678522 695181 707391 650316 666880 675000 680176 635243 634198 617427 630869 621612 628371 638967 633449 406381 516684 531105 541643 545418 675012 628333 483550 530369 585716 617420 ] |
||||||||||||||||||||||||||||||
| 4 | 4.07 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 406381 418363 421093 451256 467608 483550 507880 516684 517743 520775 521829 530369 531105 531247 540437 541643 543858 545389 545393 545409 545418 545488 551223 553272 557676 585716 591695 601595 604528 605449 614308 615717 617420 617427 621612 623196 624270 628333 628334 628371 630550 630869 632269 632283 632595 632616 632635 632707 632978 633446 633449 633775 634115 634198 634769 635243 637008 637074 637093 637101 637422 637729 638967 639292 642706 643067 647355 648560 650198 650316 666880 667748 674962 674975 674988 675000 675006 675012 676636 676638 677777 678522 680176 695181 696582 704523 707391 745384 ] |
||||||||||||||||||||||||||||||
| 5 | 113.14 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 406381 418363 421093 451256 467608 483550 507880 516684 517743 520775 521829 530369 531105 531247 540437 541643 543858 545389 545393 545409 545418 545488 551223 553272 557676 585716 591695 601595 604528 605449 614308 615717 617420 617427 621612 623196 624270 628333 628334 628371 630550 630869 632269 632283 632595 632616 632635 632707 632978 633446 633449 633775 634115 634198 634769 635243 637008 637074 637093 637101 637422 637729 638967 639292 642706 643067 647355 648560 650198 650316 666880 667748 674962 674975 674988 675000 675006 675012 676636 676638 677777 678522 680176 695181 696582 704523 707391 745384 ] |
||||||||||||||||||||||||||||||
| 6 | 2.85 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen межрасов gangbang"
]
|
||||||||||||||||||||||||||||||
| 7 | 2.55 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen межрасов 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.