Query Metrics
7
Database Queries
7
Different statements
337.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.46 ms (61.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature tattoo solo"
]
|
||||||||||||||||||||||||||||||
|
108.24 ms (32.11%) |
1 |
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 401948 416025 417980 419824 420129 432289 432296 432936 442064 443257 444544 444548 444851 445409 448464 449073 452304 455217 457063 457294 458768 458770 462840 463795 466477 468142 468146 468165 468220 468642 468661 472188 473453 473743 477021 478215 481794 483735 485546 486240 486761 486784 493249 493837 499726 500342 500734 500799 501228 502467 505344 508891 513183 513986 515435 517703 520138 520797 520911 521798 526908 528348 532118 541836 541851 553194 565628 568379 568481 569133 572259 575973 576604 577398 583033 583577 585007 586007 587142 587866 596324 598649 600406 601134 601175 602249 603414 604933 605183 607530 607694 607709 617032 624341 697000 718678 752661 763724 791489 805139 805144 805146 810831 820656 823695 ] |
||||||||||||||||||||||||||||||
|
15.16 ms (4.50%) |
1 |
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 419824 444851 515435 541851 572259 607694 444544 493837 401948 532118 596324 603414 820656 420129 500342 513986 575973 600406 417980 468165 455217 500799 520797 541836 568379 486240 520911 416025 432289 449073 466477 473453 448464 458768 458770 477021 486784 452304 457294 463795 468142 508891 468220 473743 718678 576604 617032 752661 763724 791489 805139 444548 457063 478215 468146 483735 502467 517703 553194 601134 823695 604933 432296 468661 468642 513183 569133 602249 586007 697000 805144 805146 462840 442064 472188 486761 505344 528348 583577 568481 601175 605183 624341 810831 443257 432936 521798 481794 577398 587866 607530 607709 485546 445409 583033 587142 499726 500734 501228 526908 585007 565628 598649 493249 520138 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (0.74%) |
1 |
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 401948 416025 417980 419824 420129 432289 432296 432936 442064 443257 444544 444548 444851 445409 448464 449073 452304 455217 457063 457294 458768 458770 462840 463795 466477 468142 468146 468165 468220 468642 468661 472188 473453 473743 477021 478215 481794 483735 485546 486240 486761 486784 493249 493837 499726 500342 500734 500799 501228 502467 505344 508891 513183 513986 515435 517703 520138 520797 520911 521798 526908 528348 532118 541836 541851 553194 565628 568379 568481 569133 572259 575973 576604 577398 583033 583577 585007 586007 587142 587866 596324 598649 600406 601134 601175 602249 603414 604933 605183 607530 607694 607709 617032 624341 697000 718678 752661 763724 791489 805139 805144 805146 810831 820656 823695 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature татуированные соло"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature татуированные соло"
]
|
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.