Query Metrics
7
Database Queries
7
Different statements
181.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.24 ms (86.07%) |
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 45985 98871 382363 385832 385953 389806 397432 412571 412578 415823 416437 419281 420021 422296 423773 423956 424042 428732 439484 447869 455364 456052 457593 457870 458514 459949 460558 462422 463593 465700 467924 468372 473445 478897 479462 479891 480111 480541 482441 482467 484008 484701 485492 487443 489347 493937 499748 508327 508801 508802 515627 516100 521024 522178 527644 534824 535408 537313 538274 545237 545261 547781 554174 554901 556788 562736 565645 571374 572228 576503 584888 598985 600389 600467 604969 605011 605030 605033 605215 605244 605281 605284 605285 608202 614842 618069 625282 628527 637503 639637 639670 639674 650721 664226 668677 669023 669026 693423 707812 721060 728101 751262 751676 761141 765810 778828 783154 788816 791858 792736 803374 804847 808574 810635 811071 811961 812743 814404 816629 825672 ] |
||||||||||||||||||||||||||||||
|
15.92 ms (8.77%) |
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 751262 761141 765810 605011 614842 707812 778828 791858 810635 811961 423956 455364 457593 415823 423773 412578 457870 487443 508327 382363 98871 397432 428732 825672 468372 489347 538274 515627 460558 467924 482441 554174 545261 572228 554901 584888 650721 664226 668677 669026 693423 669023 562736 565645 571374 600467 605281 608202 598985 605284 605285 625282 605215 639674 600389 605244 628527 639637 639670 812743 803374 788816 792736 808574 811071 728101 751676 604969 605030 605033 618069 637503 721060 783154 804847 419281 420021 45985 389806 479891 385832 424042 385953 465700 478897 412571 535408 508801 508802 516100 521024 416437 422296 439484 816629 814404 482467 447869 459949 479462 456052 458514 473445 480541 484008 484701 462422 463593 480111 534824 537313 499748 522178 527644 485492 493937 556788 576503 545237 547781 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.40%) |
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 45985 98871 382363 385832 385953 389806 397432 412571 412578 415823 416437 419281 420021 422296 423773 423956 424042 428732 439484 447869 455364 456052 457593 457870 458514 459949 460558 462422 463593 465700 467924 468372 473445 478897 479462 479891 480111 480541 482441 482467 484008 484701 485492 487443 489347 493937 499748 508327 508801 508802 515627 516100 521024 522178 527644 534824 535408 537313 538274 545237 545261 547781 554174 554901 556788 562736 565645 571374 572228 576503 584888 598985 600389 600467 604969 605011 605030 605033 605215 605244 605281 605284 605285 608202 614842 618069 625282 628527 637503 639637 639670 639674 650721 664226 668677 669023 669026 693423 707812 721060 728101 751262 751676 761141 765810 778828 783154 788816 791858 792736 803374 804847 808574 810635 811071 811961 812743 814404 816629 825672 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"in dress"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"dress"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.32 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"dress"
]
|
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.