Query Metrics
7
Database Queries
7
Different statements
173.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.05 ms (83.56%) |
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 384016 396079 397639 398002 405139 412911 414164 416215 417074 419217 419413 419740 420399 421328 425385 426019 426085 427898 428871 433287 435477 435745 435916 444046 444062 444440 447878 448838 449425 450645 450835 452135 452213 453755 454050 454433 454540 454662 454765 454958 459581 459857 459879 461036 461302 461608 462862 462897 464202 464381 464410 465496 468741 468849 469373 472521 472985 474743 477766 479811 484087 488464 488663 488669 488776 490539 491177 497470 507200 507217 508146 514130 514819 515935 517922 518635 519252 519621 521090 523072 523091 523387 525620 526086 526387 536728 544670 557853 580522 593542 595741 606684 610005 632112 635197 640909 680258 682534 684961 709508 718130 737427 753089 756400 773403 784753 784819 789617 795451 795782 803078 806153 807732 813608 814521 820148 824152 824178 824250 825155 ] |
||||||||||||||||||||||||||||||
|
17.18 ms (9.90%) |
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 414164 444440 416215 420399 435745 435916 435477 433287 447878 448838 488464 488663 491177 459581 469373 452135 453755 454540 454662 454958 461036 461608 464202 465496 468741 477766 479811 490539 525620 519621 472521 472985 544670 557853 580522 806153 452213 462862 464381 468849 417074 454433 454765 426085 428871 444046 444062 474743 397639 405139 412911 419217 459879 462897 421328 427898 450645 508146 518635 517922 519252 523387 536728 488669 488776 497470 507217 514130 515935 523091 484087 507200 521090 419740 449425 514819 384016 459857 396079 398002 425385 426019 419413 824178 824250 813608 814521 820148 824152 825155 450835 454050 461302 464410 523072 526086 526387 709508 680258 682534 684961 718130 595741 606684 610005 635197 640909 593542 632112 789617 795451 795782 784819 803078 807732 737427 753089 756400 773403 784753 ] |
||||||||||||||||||||||||||||||
|
4.22 ms (2.43%) |
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 384016 396079 397639 398002 405139 412911 414164 416215 417074 419217 419413 419740 420399 421328 425385 426019 426085 427898 428871 433287 435477 435745 435916 444046 444062 444440 447878 448838 449425 450645 450835 452135 452213 453755 454050 454433 454540 454662 454765 454958 459581 459857 459879 461036 461302 461608 462862 462897 464202 464381 464410 465496 468741 468849 469373 472521 472985 474743 477766 479811 484087 488464 488663 488669 488776 490539 491177 497470 507200 507217 508146 514130 514819 515935 517922 518635 519252 519621 521090 523072 523091 523387 525620 526086 526387 536728 544670 557853 580522 593542 595741 606684 610005 632112 635197 640909 680258 682534 684961 709508 718130 737427 753089 756400 773403 784753 784819 789617 795451 795782 803078 806153 807732 813608 814521 820148 824152 824178 824250 825155 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina boy"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская парен"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"латинская парен"
]
|
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.