Query Metrics
7
Database Queries
7
Different statements
235.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.42 ms (87.80%) |
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 232978 341041 389779 391600 396186 398387 398774 402458 402859 409670 409759 420853 421181 421207 423751 432737 434549 437610 439777 440923 442336 443503 443514 444069 444109 444888 445228 447052 452475 452636 452680 454848 456254 456322 459651 460062 461103 461651 465790 468404 468779 471307 471475 472882 473703 476597 478184 479568 480720 481419 482690 484878 492459 495665 496437 500299 501958 502191 502615 505407 505998 507008 508607 508974 513560 518619 520627 524194 524752 527218 527942 529556 531163 532848 533370 536841 544827 545678 551223 554298 555797 555821 556670 560197 565934 570711 581242 581916 584779 585154 586033 586118 586899 590460 591783 597282 599966 601659 606285 608471 609639 616025 616869 621271 624131 630280 630550 633793 634780 635249 641955 650016 654465 667748 675405 704229 707889 771918 802067 820762 ] |
||||||||||||||||||||||||||||||
|
17.03 ms (7.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 420853 468404 505407 437610 452475 456322 444888 461651 704229 635249 601659 802067 389779 452680 454848 442336 478184 545678 471307 606285 585154 447052 484878 402458 432737 465790 581916 675405 707889 581242 608471 771918 456254 480720 524194 502615 471475 591783 527942 616025 584779 524752 402859 476597 650016 555821 616869 461103 472882 531163 633793 445228 482690 492459 554298 586033 443514 391600 459651 502191 500299 440923 508974 495665 507008 597282 586118 444069 409670 421181 544827 439777 468779 481419 513560 496437 520627 396186 434549 555797 609639 630550 527218 398774 532848 479568 421207 536841 501958 590460 443503 529556 621271 460062 560197 634780 398387 423751 654465 556670 409759 624131 533370 551223 586899 641955 232978 341041 518619 820762 667748 599966 444109 505998 473703 565934 570711 452636 508607 630280 ] |
||||||||||||||||||||||||||||||
|
5.81 ms (2.47%) |
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 232978 341041 389779 391600 396186 398387 398774 402458 402859 409670 409759 420853 421181 421207 423751 432737 434549 437610 439777 440923 442336 443503 443514 444069 444109 444888 445228 447052 452475 452636 452680 454848 456254 456322 459651 460062 461103 461651 465790 468404 468779 471307 471475 472882 473703 476597 478184 479568 480720 481419 482690 484878 492459 495665 496437 500299 501958 502191 502615 505407 505998 507008 508607 508974 513560 518619 520627 524194 524752 527218 527942 529556 531163 532848 533370 536841 544827 545678 551223 554298 555797 555821 556670 560197 565934 570711 581242 581916 584779 585154 586033 586118 586899 590460 591783 597282 599966 601659 606285 608471 609639 616025 616869 621271 624131 630280 630550 633793 634780 635249 641955 650016 654465 667748 675405 704229 707889 771918 802067 820762 ] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen panties creampie"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.62%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen трусик нижн бел creampie"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.57%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen трусик нижн бел creampie"
]
|
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.