Query Metrics
7
Database Queries
7
Different statements
186.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.92 ms (85.56%) |
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 417858 423649 425275 427469 429950 437582 438714 439540 444288 444352 444869 447709 448434 452585 464486 467879 475624 476487 478220 478557 480331 482910 483182 487140 488959 490273 492740 503085 503088 506339 512738 515707 515757 516546 516670 516780 517885 518401 519452 519459 519610 522458 522517 523017 523160 523539 525713 539544 542744 551649 552119 552359 561470 564805 565007 570842 574562 576409 582589 594532 594554 594577 594957 597154 599642 599766 603426 605698 607026 608172 619891 621582 622707 625896 651296 659173 665865 668139 677921 682686 687362 697196 701267 710914 715397 721496 721867 727076 739778 739782 740095 742757 743030 746093 751920 752831 752965 755723 756245 757638 761022 761293 761692 779913 780520 787027 787052 787056 789141 794005 796143 796804 799772 804854 804860 807504 818039 823269 ] |
||||||||||||||||||||||||||||||
|
16.51 ms (8.83%) |
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 697196 752831 756245 739778 739782 603426 710914 668139 582589 599106 687362 761022 746093 619891 476487 516670 522458 515707 517885 565007 475624 480331 478220 519452 682686 721867 779913 752965 742757 438714 519459 522517 755723 757845 818039 539544 574562 789141 804854 787052 794005 743030 740095 425275 483182 594532 607026 608172 488959 552359 807504 804860 444352 437582 490273 796143 761293 761692 518401 506339 799772 594957 823269 651296 665865 677921 625896 780520 787027 622707 787056 487140 448434 444288 417858 525713 429950 503088 444869 659173 594577 523160 542744 599642 757638 576409 701267 721496 599766 751920 452585 516780 552119 492740 594554 796804 519610 523017 523539 467879 423649 427469 597154 439540 447709 715397 727076 621582 570842 512738 515757 464486 478557 503085 551649 564805 516546 482910 561470 605698 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (1.65%) |
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 417858 423649 425275 427469 429950 437582 438714 439540 444288 444352 444869 447709 448434 452585 464486 467879 475624 476487 478220 478557 480331 482910 483182 487140 488959 490273 492740 503085 503088 506339 512738 515707 515757 516546 516670 516780 517885 518401 519452 519459 519610 522458 522517 523017 523160 523539 525713 539544 542744 551649 552119 552359 561470 564805 565007 570842 574562 576409 582589 594532 594554 594577 594957 597154 599642 599766 603426 605698 607026 608172 619891 621582 622707 625896 651296 659173 665865 668139 677921 682686 687362 697196 701267 710914 715397 721496 721867 727076 739778 739782 740095 742757 743030 746093 751920 752831 752965 755723 756245 757638 761022 761293 761692 779913 780520 787027 787052 787056 789141 794005 796143 796804 799772 804854 804860 807504 818039 823269 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск жен cheating"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian wife cheating"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск жен cheating"
]
|
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.