Query Metrics
7
Database Queries
7
Different statements
207.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
184.13 ms (88.55%) |
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 192760 382794 383433 394446 395752 400718 424468 426194 429321 433699 434017 443921 452130 454370 457682 459947 460392 460458 462524 468752 471054 476375 477984 485611 491665 503978 509816 510017 514767 516114 516824 517273 518356 521135 528365 532049 534190 546494 546947 552307 555888 556507 558583 560210 563428 563667 563873 564855 565159 565991 565995 571044 574328 574990 576413 576641 580301 583858 585728 595578 598086 605412 606755 620025 620905 629810 631632 636066 637737 645011 652601 654124 665506 675628 676979 678008 682261 687441 697296 698959 700303 700849 708519 714756 719279 719310 722850 724638 725584 727650 730642 735610 735806 741904 749172 756614 761222 766036 766679 767235 769102 771180 775764 780833 784223 795717 796214 801261 802510 802648 805773 810102 810880 811903 812785 814141 824316 824496 824571 825689 ] |
||||||||||||||||||||||||||||||
|
13.35 ms (6.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 462524 574990 424468 434017 514767 766679 528365 580301 682261 714756 697296 730642 802648 382794 560210 605412 395752 645011 565991 801261 564855 460392 476375 509816 708519 518356 824316 468752 534190 510017 571044 546494 400718 460458 394446 563428 565159 576641 636066 805773 766036 477984 443921 556507 583858 687441 652601 678008 675628 629810 620905 811903 812785 749172 767235 769102 796214 724638 735610 735806 700303 784223 516114 452130 459947 555888 598086 631632 771180 457682 454370 546947 552307 576413 491665 426194 814141 532049 558583 700849 719279 722850 795717 810102 741904 725584 727650 756614 471054 620025 637737 192760 383433 565995 521135 429321 433699 824571 824496 825689 485611 516824 517273 503978 563667 563873 574328 654124 676979 698959 719310 665506 585728 595578 606755 780833 775764 810880 761222 802510 ] |
||||||||||||||||||||||||||||||
|
3.68 ms (1.77%) |
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 192760 382794 383433 394446 395752 400718 424468 426194 429321 433699 434017 443921 452130 454370 457682 459947 460392 460458 462524 468752 471054 476375 477984 485611 491665 503978 509816 510017 514767 516114 516824 517273 518356 521135 528365 532049 534190 546494 546947 552307 555888 556507 558583 560210 563428 563667 563873 564855 565159 565991 565995 571044 574328 574990 576413 576641 580301 583858 585728 595578 598086 605412 606755 620025 620905 629810 631632 636066 637737 645011 652601 654124 665506 675628 676979 678008 682261 687441 697296 698959 700303 700849 708519 714756 719279 719310 722850 724638 725584 727650 730642 735610 735806 741904 749172 756614 761222 766036 766679 767235 769102 771180 775764 780833 784223 795717 796214 801261 802510 802648 805773 810102 810880 811903 812785 814141 824316 824496 824571 825689 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sleep blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"спящ минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.67%) |
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.