Query Metrics
7
Database Queries
7
Different statements
151.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.92 ms (82.43%) |
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 194687 415496 417719 420426 420836 422509 422961 423352 429247 429266 429279 429473 433555 437347 437939 444134 449558 451606 452218 453022 456369 459123 459844 462308 464018 465991 467143 467165 467208 467303 469637 470226 474105 476809 479800 480867 482474 482664 482684 482992 487146 491698 492386 495367 495908 495915 496051 497656 501279 501280 504136 504595 504644 508828 509487 511703 511730 512694 513884 520249 522588 523086 523990 524706 525640 527044 527187 527456 527807 540391 543243 544446 547065 552124 553037 556310 560156 560174 560473 560607 564445 564734 566905 568168 570723 572314 573358 574894 575203 575454 575777 575805 575817 576004 578050 578059 578066 578121 578129 591090 594826 594868 594956 596729 598821 605515 606059 612026 612039 612687 612819 621246 623446 623841 638233 682136 731722 731723 787548 796469 ] |
||||||||||||||||||||||||||||||
|
16.20 ms (10.69%) |
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 573358 606059 623841 731722 540391 504595 525640 527807 433555 420426 449558 451606 509487 575805 566905 574894 575454 594956 787548 476809 423352 491698 194687 437347 474105 578050 543243 594826 621246 605515 731723 638233 527044 508828 437939 482474 501280 598821 796469 467303 480867 422961 511730 527187 523086 420836 552124 429473 570723 572314 522588 482664 495908 544446 429279 417719 560607 575777 560174 591090 612026 459844 479800 464018 495367 429266 452218 497656 527456 575203 560156 612687 422509 501279 492386 429247 453022 459123 470226 467165 578129 612819 444134 511703 524706 482992 512694 467208 513884 560473 596729 465991 556310 462308 504136 467143 456369 495915 496051 523990 594868 504644 520249 482684 564445 623446 612039 487146 415496 578066 564734 578059 578121 469637 568168 575817 576004 547065 553037 682136 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.66%) |
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 194687 415496 417719 420426 420836 422509 422961 423352 429247 429266 429279 429473 433555 437347 437939 444134 449558 451606 452218 453022 456369 459123 459844 462308 464018 465991 467143 467165 467208 467303 469637 470226 474105 476809 479800 480867 482474 482664 482684 482992 487146 491698 492386 495367 495908 495915 496051 497656 501279 501280 504136 504595 504644 508828 509487 511703 511730 512694 513884 520249 522588 523086 523990 524706 525640 527044 527187 527456 527807 540391 543243 544446 547065 552124 553037 556310 560156 560174 560473 560607 564445 564734 566905 568168 570723 572314 573358 574894 575203 575454 575777 575805 575817 576004 578050 578059 578066 578121 578129 591090 594826 594868 594956 596729 598821 605515 606059 612026 612039 612687 612819 621246 623446 623841 638233 682136 731722 731723 787548 796469 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.56%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck for cash"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс cash"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс cash"
]
|
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.