Query Metrics
7
Database Queries
7
Different statements
388.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.58 ms (54.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"step mom жоп"
]
|
||||||||||||||||||||||||||||||
|
145.88 ms (37.53%) |
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 397916 400179 402342 403031 406041 409374 409682 413890 413908 418520 420540 421139 427536 433070 437835 438199 442301 442452 446022 450319 451880 452335 454043 460184 489102 490031 490456 492268 497104 508450 510299 515031 517280 525354 525557 531568 531974 532058 532133 532135 532807 533469 534221 535258 536333 546883 559083 559678 561990 562013 563182 563433 563452 564173 565631 573749 584106 586150 587693 598225 598999 603383 604561 617677 619775 627181 646525 664660 667593 667660 674743 680833 680846 687940 693256 695760 697221 702283 702904 708960 710549 710578 714169 714216 714340 714344 715270 716262 718969 725635 725639 728259 737315 740457 742321 759826 760549 760733 767672 771683 771737 775129 775640 775771 786455 788319 788961 790596 795368 803145 804218 805679 805945 807394 807409 818802 823274 824247 824585 826160 ] |
||||||||||||||||||||||||||||||
|
22.45 ms (5.78%) |
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 442301 413890 450319 564173 559678 565631 598999 406041 397916 531568 728259 737315 760549 510299 442452 823274 531974 532807 535258 546883 562013 667593 708960 714340 680833 714169 714344 718969 563452 603383 587693 617677 775129 775771 788961 795368 807409 760733 771737 790596 740457 759826 725639 725635 767672 771683 627181 710549 788319 803145 804218 805679 497104 492268 409682 400179 490031 454043 664660 786455 402342 420540 438199 418520 460184 403031 451880 421139 433070 490456 826160 824585 561990 775640 508450 452335 742321 532058 584106 409374 559083 604561 586150 807394 573749 619775 805945 446022 413908 427536 515031 598225 437835 824247 818802 489102 517280 533469 525557 532133 536333 525354 532135 534221 563182 646525 702283 702904 715270 716262 667660 693256 695760 697221 710578 714216 674743 680846 687940 563433 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (0.79%) |
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 397916 400179 402342 403031 406041 409374 409682 413890 413908 418520 420540 421139 427536 433070 437835 438199 442301 442452 446022 450319 451880 452335 454043 460184 489102 490031 490456 492268 497104 508450 510299 515031 517280 525354 525557 531568 531974 532058 532133 532135 532807 533469 534221 535258 536333 546883 559083 559678 561990 562013 563182 563433 563452 564173 565631 573749 584106 586150 587693 598225 598999 603383 604561 617677 619775 627181 646525 664660 667593 667660 674743 680833 680846 687940 693256 695760 697221 702283 702904 708960 710549 710578 714169 714216 714340 714344 715270 716262 718969 725635 725639 728259 737315 740457 742321 759826 760549 760733 767672 771683 771737 775129 775640 775771 786455 788319 788961 790596 795368 803145 804218 805679 805945 807394 807409 818802 823274 824247 824585 826160 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"step mom жоп"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"step mom ass"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.