Query Metrics
7
Database Queries
7
Different statements
228.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
195.71 ms (85.62%) |
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 282218 401976 413827 415134 422513 422652 422658 422958 428481 443513 446740 454627 461620 463938 470782 472431 473739 475799 487858 491704 497422 498119 501641 502844 508199 513576 518992 524213 529035 529855 530269 530757 533471 534028 537916 539210 545393 545604 545610 545614 545698 551226 556017 557197 562373 562491 565191 565254 565262 566052 568579 571847 576399 579389 584492 586695 589484 597244 599856 606508 609880 612399 613832 614867 619592 622402 623198 624175 627809 627814 628117 628366 628380 628384 628387 628391 628396 628398 628406 629359 630524 630526 630540 631202 631965 632001 632979 633114 633718 633788 634153 634482 637004 637080 637089 637093 637422 641672 642043 642750 642751 645997 646838 647906 649525 666535 666878 679810 680116 680118 680159 680185 680186 680255 699627 702168 704523 719391 733840 752563 ] |
||||||||||||||||||||||||||||||
|
21.02 ms (9.20%) |
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 470782 491704 502844 551226 422958 443513 422652 446740 530269 529035 530757 533471 571847 545610 562373 565191 565254 576399 562491 568579 679810 680185 680255 646838 680116 680118 556017 599856 606508 619592 627809 630540 631965 614867 633788 628366 628387 628406 632979 642751 622402 623198 624175 628391 630526 632001 637004 637080 733840 629359 633114 642043 413827 422513 498119 513576 487858 680186 628380 401976 529855 539210 534028 501641 524213 545614 609880 428481 422658 461620 475799 518992 472431 557197 699627 719391 566052 637089 642750 586695 597244 641672 282218 463938 454627 415134 497422 537916 508199 473739 545604 579389 584492 649525 666535 645997 666878 702168 704523 647906 680159 545393 545698 565262 589484 633718 634482 637093 637422 612399 628384 630524 634153 627814 628396 628398 631202 613832 628117 752563 ] |
||||||||||||||||||||||||||||||
|
3.88 ms (1.70%) |
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 282218 401976 413827 415134 422513 422652 422658 422958 428481 443513 446740 454627 461620 463938 470782 472431 473739 475799 487858 491704 497422 498119 501641 502844 508199 513576 518992 524213 529035 529855 530269 530757 533471 534028 537916 539210 545393 545604 545610 545614 545698 551226 556017 557197 562373 562491 565191 565254 565262 566052 568579 571847 576399 579389 584492 586695 589484 597244 599856 606508 609880 612399 613832 614867 619592 622402 623198 624175 627809 627814 628117 628366 628380 628384 628387 628391 628396 628398 628406 629359 630524 630526 630540 631202 631965 632001 632979 633114 633718 633788 634153 634482 637004 637080 637089 637093 637422 641672 642043 642750 642751 645997 646838 647906 649525 666535 666878 679810 680116 680118 680159 680185 680186 680255 699627 702168 704523 719391 733840 752563 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young-teen-casting"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young teen кастинг"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young teen кастинг"
]
|
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.