Query Metrics
7
Database Queries
7
Different statements
148.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.36 ms (82.94%) |
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 287540 319463 382188 382480 399689 400438 403240 404576 413183 416019 416082 416371 419091 420912 425294 425579 430285 430999 435962 447358 447364 451892 453081 456899 457213 457757 460653 462579 464095 465766 465981 467138 469558 470311 470788 473108 477870 479923 485091 485307 485885 486425 486837 491587 497130 498875 502701 502791 504056 505501 509457 511815 512893 513258 516104 522171 522409 522830 524330 525158 529054 529488 530465 530928 539570 540256 542982 543045 544259 550044 550306 552045 553876 556315 560341 567002 568153 576607 583853 586543 586546 587479 590787 592395 593750 596232 597604 601524 614769 620145 620393 633527 639853 649507 651075 653513 666395 669258 676895 677738 682134 683850 684251 702862 708292 718985 722142 722294 787297 814036 815225 817058 817789 820472 821013 823322 823516 823517 824403 825664 ] |
||||||||||||||||||||||||||||||
|
15.37 ms (10.34%) |
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 460653 465766 485885 556315 560341 567002 576607 669258 708292 649507 653513 676895 550306 552045 620145 633527 586543 592395 620393 639853 586546 590787 593750 601524 614769 787297 287540 319463 382188 425294 430285 453081 456899 470788 473108 404576 413183 425579 435962 451892 457213 465981 469558 477870 399689 420912 457757 470311 479923 400438 403240 416371 462579 416019 416082 430999 502791 511815 522830 524330 485091 491587 502701 504056 516104 522171 486425 486837 497130 505501 509457 512893 513258 522409 485307 498875 525158 529054 529488 382480 419091 814036 820472 824403 815225 817789 817058 821013 823322 823516 823517 825664 464095 447358 447364 530928 540256 530465 539570 467138 544259 568153 542982 550044 553876 543045 651075 677738 702862 722142 666395 682134 683850 684251 718985 722294 583853 587479 596232 597604 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.87%) |
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 287540 319463 382188 382480 399689 400438 403240 404576 413183 416019 416082 416371 419091 420912 425294 425579 430285 430999 435962 447358 447364 451892 453081 456899 457213 457757 460653 462579 464095 465766 465981 467138 469558 470311 470788 473108 477870 479923 485091 485307 485885 486425 486837 491587 497130 498875 502701 502791 504056 505501 509457 511815 512893 513258 516104 522171 522409 522830 524330 525158 529054 529488 530465 530928 539570 540256 542982 543045 544259 550044 550306 552045 553876 556315 560341 567002 568153 576607 583853 586543 586546 587479 590787 592395 593750 596232 597604 601524 614769 620145 620393 633527 639853 649507 651075 653513 666395 669258 676895 677738 682134 683850 684251 702862 708292 718985 722142 722294 787297 814036 815225 817058 817789 820472 821013 823322 823516 823517 824403 825664 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful hairy"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая волосатая"
]
|
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.