Query Metrics
7
Database Queries
7
Different statements
165.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.54 ms (83.32%) |
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 86309 195768 382207 382670 383500 383920 387661 387941 393047 397197 397973 398097 401367 401769 401861 410217 429900 443090 443251 444490 450357 457816 468733 470412 471129 476053 500680 515419 515423 516640 516843 521139 526179 529296 529599 530451 530679 531580 534545 537771 545337 547502 564255 564285 572022 573183 574377 584183 589408 599477 601194 607487 607683 607685 612091 618259 622025 624399 624833 631740 639024 640353 644386 653028 660369 662026 662049 666854 668305 671002 671038 672952 678816 698405 705507 707571 710434 713503 713506 716086 718772 718835 718987 720206 722330 735535 738476 745092 745111 745874 751609 752592 752649 753244 760689 769364 770261 774908 777052 788863 788908 789234 792726 796071 799695 802071 803582 806657 806834 807170 808068 809122 812409 813205 813793 819218 819223 821359 822969 826237 ] |
||||||||||||||||||||||||||||||
|
15.55 ms (9.42%) |
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 745874 387941 401769 398097 826237 640353 806657 735535 769364 86309 521139 662049 707571 644386 799695 813205 803582 738476 589408 476053 545337 639024 751609 788863 788908 443090 429900 515419 612091 774908 720206 821359 822969 716086 760689 819223 819218 515423 584183 401861 622025 529599 530451 564255 713503 678816 713506 607487 789234 718835 387661 698405 383920 397197 397973 547502 599477 382207 468733 718987 401367 534545 574377 718772 660369 672952 666854 671038 624399 382670 444490 516843 457816 531580 671002 662026 668305 796071 777052 809122 745092 792726 745111 806834 383500 410217 653028 607683 753244 812409 722330 450357 443251 516640 526179 471129 470412 537771 624833 572022 631740 607685 601194 808068 770261 500680 813793 802071 573183 393047 710434 618259 807170 752592 752649 705507 195768 529296 530679 564285 ] |
||||||||||||||||||||||||||||||
|
4.43 ms (2.69%) |
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 86309 195768 382207 382670 383500 383920 387661 387941 393047 397197 397973 398097 401367 401769 401861 410217 429900 443090 443251 444490 450357 457816 468733 470412 471129 476053 500680 515419 515423 516640 516843 521139 526179 529296 529599 530451 530679 531580 534545 537771 545337 547502 564255 564285 572022 573183 574377 584183 589408 599477 601194 607487 607683 607685 612091 618259 622025 624399 624833 631740 639024 640353 644386 653028 660369 662026 662049 666854 668305 671002 671038 672952 678816 698405 705507 707571 710434 713503 713506 716086 718772 718835 718987 720206 722330 735535 738476 745092 745111 745874 751609 752592 752649 753244 760689 769364 770261 774908 777052 788863 788908 789234 792726 796071 799695 802071 803582 806657 806834 807170 808068 809122 812409 813205 813793 819218 819223 821359 822969 826237 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные большие дилд"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge big dildo"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"огромные большие дилд"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.