Query Metrics
7
Database Queries
7
Different statements
103.10 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.44 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.86 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature anal italian"
]
|
||||||||||||||||||||||||||||||
| 3 | 12.57 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 526066 561032 766690 802036 485755 382444 396287 162000 487352 469565 519089 511391 458790 681085 641684 583882 544323 560909 810975 615726 789659 803645 464302 576644 614347 415780 620147 516333 442665 456819 456822 641686 577355 592461 470834 441789 587763 531133 538895 698457 442629 452383 474034 415784 576678 427191 493159 576709 680646 576712 577386 641687 790218 502278 534161 496872 472312 576715 620135 622981 476577 546744 493182 456824 576628 571241 615735 590943 426521 474035 519251 486456 641683 576645 576711 641678 566782 621722 541886 574258 513025 ] |
||||||||||||||||||||||||||||||
| 4 | 2.11 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 162000 382444 396287 415780 415784 426521 427191 441789 442629 442665 452383 456819 456822 456824 458790 464302 469565 470834 472312 474034 474035 476577 485755 486456 487352 493159 493182 496872 502278 511391 513025 516333 519089 519251 526066 531133 534161 538895 541886 544323 546744 560909 561032 566782 571241 574258 576628 576644 576645 576678 576709 576711 576712 576715 577355 577386 583882 587763 590943 592461 614347 615726 615735 620135 620147 621722 622981 641678 641683 641684 641686 641687 680646 681085 698457 766690 789659 790218 802036 803645 810975 ] |
||||||||||||||||||||||||||||||
| 5 | 81.76 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 162000 382444 396287 415780 415784 426521 427191 441789 442629 442665 452383 456819 456822 456824 458790 464302 469565 470834 472312 474034 474035 476577 485755 486456 487352 493159 493182 496872 502278 511391 513025 516333 519089 519251 526066 531133 534161 538895 541886 544323 546744 560909 561032 566782 571241 574258 576628 576644 576645 576678 576709 576711 576712 576715 577355 577386 583882 587763 590943 592461 614347 615726 615735 620135 620147 621722 622981 641678 641683 641684 641686 641687 680646 681085 698457 766690 789659 790218 802036 803645 810975 ] |
||||||||||||||||||||||||||||||
| 6 | 1.68 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature анал italian"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.67 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature анал italian"
]
|
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.