Query Metrics
7
Database Queries
7
Different statements
203.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.95 ms (84.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 383272 385318 386378 404451 411926 413084 414368 415112 416675 438417 444806 445327 446125 451469 452895 455502 456226 457422 459357 467364 474139 474509 474875 475080 475174 479003 480731 482454 486516 488032 489168 490795 491418 494037 494778 495700 498038 499712 502740 502778 503051 503304 503845 506454 509879 510839 512369 513550 515678 515846 516787 517868 519819 520005 520817 521310 523108 523128 523323 526288 527040 527267 527732 527742 529243 531230 534579 536918 546005 546124 552977 553927 554292 554880 555582 555866 563431 564407 565506 567304 568038 568596 569070 570137 570759 576352 577356 582480 582722 584006 584516 587921 596630 597208 599598 601347 603835 609794 610035 612698 612964 614966 619199 620203 621340 622067 622714 623364 633892 636535 637689 641732 643125 672361 676016 676101 748210 770897 791048 820482 ] |
||||||||||||||||||||||||||||||
|
21.38 ms (10.49%) |
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 489168 527732 411926 499712 519819 536918 552977 672361 770897 444806 490795 582722 570137 637689 467364 480731 526288 517868 488032 385318 576352 599598 623364 475174 446125 502778 513550 515846 515678 523128 527267 555582 633892 748210 416675 459357 451469 503845 523323 404451 534579 563431 506454 486516 503304 614966 456226 820482 474875 569070 619199 568038 475080 555866 438417 554292 596630 791048 516787 520817 457422 512369 510839 546005 570759 612964 609794 527040 643125 529243 531230 413084 479003 414368 445327 553927 676101 567304 503051 455502 527742 622714 386378 482454 603835 491418 383272 521310 474509 498038 546124 495700 584516 415112 502740 509879 452895 554880 582480 584006 641732 523108 564407 601347 577356 494778 620203 587921 520005 612698 676016 636535 568596 565506 494037 597208 610035 474139 622067 621340 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.42%) |
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 383272 385318 386378 404451 411926 413084 414368 415112 416675 438417 444806 445327 446125 451469 452895 455502 456226 457422 459357 467364 474139 474509 474875 475080 475174 479003 480731 482454 486516 488032 489168 490795 491418 494037 494778 495700 498038 499712 502740 502778 503051 503304 503845 506454 509879 510839 512369 513550 515678 515846 516787 517868 519819 520005 520817 521310 523108 523128 523323 526288 527040 527267 527732 527742 529243 531230 534579 536918 546005 546124 552977 553927 554292 554880 555582 555866 563431 564407 565506 567304 568038 568596 569070 570137 570759 576352 577356 582480 582722 584006 584516 587921 596630 597208 599598 601347 603835 609794 610035 612698 612964 614966 619199 620203 621340 622067 622714 623364 633892 636535 637689 641732 643125 672361 676016 676101 748210 770897 791048 820482 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hungry for sex"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hungry секс"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hungry секс"
]
|
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.