Query Metrics
7
Database Queries
7
Different statements
161.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.89 ms (81.73%) |
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 387856 391505 391930 392037 392213 397410 400923 429550 439621 439641 439686 439721 439735 439792 440593 443761 443772 448409 457460 462321 465334 465347 466023 466109 466307 469372 470768 471402 472676 474097 474479 474483 476284 477961 477970 478378 479082 483646 483655 484394 484439 484626 484629 484683 484704 485948 485970 486577 486578 489105 489178 492062 493119 496009 496862 497209 506142 506768 509044 513499 516480 516485 518828 519751 522508 523834 523836 528573 533779 534083 535604 536457 538006 543714 545535 546663 552286 555093 555096 555101 555103 563640 579510 590331 619513 619518 619987 620226 626994 666361 667011 668824 706889 712553 712580 719929 728170 735992 736307 741702 741716 741742 741770 742390 742407 742409 742706 742729 745952 746713 758446 761147 762272 792643 802151 817293 818045 825434 827934 827973 ] |
||||||||||||||||||||||||||||||
|
18.42 ms (11.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 465334 516485 484394 485970 489105 519751 523836 484683 486578 516480 484439 489178 497209 506768 518828 523834 528573 533779 535604 477970 543714 762272 474479 387856 476284 443761 443772 439641 391505 429550 534083 552286 563640 465347 470768 439721 466109 457460 469372 477961 478378 536457 538006 483655 492062 522508 483646 484626 513499 471402 486577 462321 391930 818045 493119 590331 626994 746713 758446 792643 736307 742409 742706 745952 742407 761147 619518 392213 509044 668824 546663 545535 392037 466023 825434 735992 827973 555096 555093 555103 619987 802151 719929 474483 619513 439621 448409 479082 439735 440593 439686 466307 484629 484704 496862 400923 817293 827934 472676 485948 579510 555101 666361 706889 667011 712580 620226 741716 741742 741770 742729 741702 742390 728170 712553 496009 397410 439792 506142 474097 ] |
||||||||||||||||||||||||||||||
|
3.72 ms (2.31%) |
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 387856 391505 391930 392037 392213 397410 400923 429550 439621 439641 439686 439721 439735 439792 440593 443761 443772 448409 457460 462321 465334 465347 466023 466109 466307 469372 470768 471402 472676 474097 474479 474483 476284 477961 477970 478378 479082 483646 483655 484394 484439 484626 484629 484683 484704 485948 485970 486577 486578 489105 489178 492062 493119 496009 496862 497209 506142 506768 509044 513499 516480 516485 518828 519751 522508 523834 523836 528573 533779 534083 535604 536457 538006 543714 545535 546663 552286 555093 555096 555101 555103 563640 579510 590331 619513 619518 619987 620226 626994 666361 667011 668824 706889 712553 712580 719929 728170 735992 736307 741702 741716 741742 741770 742390 742407 742409 742706 742729 745952 746713 758446 761147 762272 792643 802151 817293 818045 825434 827934 827973 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian mature amateur"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск mature любительск"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск mature любительск"
]
|
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.