Query Metrics
7
Database Queries
7
Different statements
394.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.83 ms (53.68%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
147.60 ms (37.40%) |
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 401880 414341 421146 429761 429762 429801 443476 443480 447150 447152 447668 447926 452606 453356 458555 478973 482534 497870 499105 511254 530476 530480 530487 530489 530491 530493 530627 530643 531104 531139 531157 531163 531210 531211 531232 531262 531419 534028 534650 534985 535006 535054 535620 536582 536608 536681 537209 537654 537763 537910 539239 540400 540408 540434 541856 542580 542583 542590 542595 544803 565247 565253 565254 565266 582217 588301 596643 597237 599902 599908 599917 599941 599945 599994 600290 600295 600332 600334 601514 601517 628376 628391 628403 628415 633478 633748 633758 634777 647885 649215 649498 649545 649595 650846 651147 651599 656568 656574 666852 666866 666881 666897 674980 676110 677295 677801 678066 678126 678138 678144 678161 687257 696947 708447 731665 733840 733879 733908 748931 820779 ] |
||||||||||||||||||||||||||||||
|
26.96 ms (6.83%) |
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 666852 588301 536608 452606 414341 531419 708447 582217 666866 401880 499105 531262 530480 599908 748931 530627 531210 534650 540408 531211 530643 565266 677295 599917 601514 596643 628403 429801 531104 537209 599941 733908 731665 674980 656574 678138 429761 443480 530493 447150 453356 536681 540434 534985 542590 542595 565253 733879 421146 511254 535006 656568 649498 597237 678126 447668 651599 633748 633758 535054 820779 531232 530476 531139 458555 429762 447152 531157 537763 539239 530489 540400 542583 666881 678161 649215 677801 651147 666897 678066 565247 599945 628376 600290 599902 599994 600334 601517 633478 482534 530491 535620 537910 544803 676110 647885 649545 649595 650846 600295 696947 443476 634777 497870 447926 531163 537654 534028 530487 541856 565254 542580 687257 628415 628391 733840 478973 536582 678144 600332 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (0.73%) |
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 401880 414341 421146 429761 429762 429801 443476 443480 447150 447152 447668 447926 452606 453356 458555 478973 482534 497870 499105 511254 530476 530480 530487 530489 530491 530493 530627 530643 531104 531139 531157 531163 531210 531211 531232 531262 531419 534028 534650 534985 535006 535054 535620 536582 536608 536681 537209 537654 537763 537910 539239 540400 540408 540434 541856 542580 542583 542590 542595 544803 565247 565253 565254 565266 582217 588301 596643 597237 599902 599908 599917 599941 599945 599994 600290 600295 600332 600334 601514 601517 628376 628391 628403 628415 633478 633748 633758 634777 647885 649215 649498 649545 649595 650846 651147 651599 656568 656574 666852 666866 666881 666897 674980 676110 677295 677801 678066 678126 678138 678144 678161 687257 696947 708447 731665 733840 733879 733908 748931 820779 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dap big tits"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"dap большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"dap большие сиськ"
]
|
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.