Query Metrics
7
Database Queries
7
Different statements
190.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.20 ms (85.54%) |
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 3381 53305 194687 233737 341802 365933 382519 386276 388813 395974 396102 396243 396681 397307 398425 402235 402659 404370 411257 413518 413816 417448 419991 420289 421520 426346 428571 442631 442987 443164 443919 444338 445279 445545 447553 447569 447628 447629 450385 451439 453793 461615 461713 463922 465195 465868 466441 466688 469760 471142 471990 471994 472353 472581 473190 474605 475472 475478 475507 477535 478482 480075 480934 482083 484058 485363 486221 488719 490106 491929 492286 497420 497731 497742 498634 498988 500798 502164 502295 505043 510063 511265 511267 511270 511689 511812 515476 519772 522824 523645 523994 533747 535637 537810 538204 538275 538870 540846 541248 545475 554809 556181 566789 567129 579024 595329 695894 709627 728230 733857 736101 741537 743052 743342 747153 747430 752727 753155 823245 ] |
||||||||||||||||||||||||||||||
|
16.81 ms (8.81%) |
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 497742 498988 538870 466441 695894 554809 595329 397307 511270 421520 533747 556181 386276 396243 396102 396681 402659 461615 465868 447628 466688 471142 447569 465195 474605 475472 523994 497731 511265 502164 488719 492286 545475 733857 747153 747430 752727 728230 736101 741537 709627 789776 382519 398425 419991 445545 388813 451439 365933 447553 480075 482083 463922 480934 417448 472353 478482 511689 515476 505043 538204 485363 491929 484058 486221 490106 519772 523645 395974 443164 471994 472581 579024 3381 194687 233737 411257 502295 522824 540846 511267 537810 541248 444338 510063 500798 823245 535637 538275 567129 743342 743052 753155 475507 53305 402235 469760 566789 511812 341802 404370 413518 420289 426346 442631 445279 413816 442987 428571 443919 447629 453793 471990 473190 475478 450385 461713 477535 497420 498634 ] |
||||||||||||||||||||||||||||||
|
3.37 ms (1.77%) |
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 3381 53305 194687 233737 341802 365933 382519 386276 388813 395974 396102 396243 396681 397307 398425 402235 402659 404370 411257 413518 413816 417448 419991 420289 421520 426346 428571 442631 442987 443164 443919 444338 445279 445545 447553 447569 447628 447629 450385 451439 453793 461615 461713 463922 465195 465868 466441 466688 469760 471142 471990 471994 472353 472581 473190 474605 475472 475478 475507 477535 478482 480075 480934 482083 484058 485363 486221 488719 490106 491929 492286 497420 497731 497742 498634 498988 500798 502164 502295 505043 510063 511265 511267 511270 511689 511812 515476 519772 522824 523645 523994 533747 535637 537810 538204 538275 538870 540846 541248 545475 554809 556181 566789 567129 579024 595329 695894 709627 728230 733857 736101 741537 743052 743342 747153 747430 752727 753155 823245 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny white anal"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые white анал"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые white анал"
]
|
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.