Query Metrics
7
Database Queries
7
Different statements
196.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.08 ms (85.34%) |
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 400148 414256 416094 416172 432782 437346 443644 445016 445028 445029 446258 448706 448926 451796 453844 463764 463768 467972 471446 472114 474147 475072 476974 482039 483614 484438 484843 488735 491400 492163 492384 492396 496820 497590 500446 503002 504069 511803 515331 515374 517547 517554 520954 523437 524886 528181 528439 530062 538237 538708 538774 544505 547959 548311 548614 548694 548696 550011 550138 550634 551087 551904 554040 557204 558991 559123 559837 559959 560652 561056 563316 563362 564082 565283 570046 572031 572738 572834 575155 575716 576338 576730 577435 580978 585603 586600 586805 587172 587185 587211 589651 594109 594125 594151 594173 594224 594239 597284 597545 598604 600403 600819 601016 603364 603703 604909 604917 607477 607966 613177 615060 618442 623623 625279 660582 666920 688664 706676 717199 814072 ] |
||||||||||||||||||||||||||||||
|
18.19 ms (9.24%) |
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 414256 445028 491400 538708 547959 548614 554040 666920 717199 550138 572738 575155 576730 597545 604909 594109 594224 597284 607477 607966 448706 445016 453844 445029 476974 416094 483614 484438 503002 504069 416172 492396 544505 550634 572834 557204 660582 550011 560652 564082 587172 585603 586600 623623 587211 594125 594151 594173 600819 601016 625279 482039 523437 484843 497590 500446 496820 538237 538774 443644 432782 530062 517554 565283 580978 548694 559123 551904 563316 576338 570046 589651 706676 400148 446258 472114 515331 492384 524886 488735 517547 561056 559837 572031 586805 437346 448926 471446 515374 511803 814072 475072 528439 563362 688664 575716 615060 467972 528181 463764 451796 548311 604917 594239 600403 613177 492163 463768 520954 577435 618442 603703 474147 551087 558991 559959 548696 587185 598604 603364 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (1.63%) |
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 400148 414256 416094 416172 432782 437346 443644 445016 445028 445029 446258 448706 448926 451796 453844 463764 463768 467972 471446 472114 474147 475072 476974 482039 483614 484438 484843 488735 491400 492163 492384 492396 496820 497590 500446 503002 504069 511803 515331 515374 517547 517554 520954 523437 524886 528181 528439 530062 538237 538708 538774 544505 547959 548311 548614 548694 548696 550011 550138 550634 551087 551904 554040 557204 558991 559123 559837 559959 560652 561056 563316 563362 564082 565283 570046 572031 572738 572834 575155 575716 576338 576730 577435 580978 585603 586600 586805 587172 587185 587211 589651 594109 594125 594151 594173 594224 594239 597284 597545 598604 600403 600819 601016 603364 603703 604909 604917 607477 607966 613177 615060 618442 623623 625279 660582 666920 688664 706676 717199 814072 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"busty skinny"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"busty худые"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"busty худые"
]
|
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.