Query Metrics
7
Database Queries
7
Different statements
392.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.64 ms (54.14%) |
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 88286 154463 182135 182232 340635 381812 384397 386156 386858 392004 393313 398100 401204 403896 412814 414259 415879 415965 416230 416525 416583 416611 416644 416649 416659 416686 416699 416712 419819 424765 428174 432613 432936 439195 439993 445413 451336 453788 455080 456190 465470 465618 466427 467112 467872 469615 470471 471455 476054 477506 477761 483736 500290 500340 500341 506516 524346 524678 526905 532778 532847 534777 540572 541836 542524 544404 545305 546129 548157 550916 563992 578484 584301 590263 604228 620891 620901 632678 632887 634100 636948 642022 647838 658802 658819 662072 662448 662856 665958 666528 672925 672938 674968 675375 680249 680252 696593 713501 713507 723461 728269 738822 739558 740932 742363 745128 749067 749221 752633 752681 756233 766943 770262 770397 784775 788192 789028 791012 794307 803134 ] |
||||||||||||||||||||||||||||||
|
155.20 ms (39.52%) |
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 88286 154463 182135 182232 340635 381812 384397 386156 386858 392004 393313 398100 401204 403896 412814 414259 415879 415965 416230 416525 416583 416611 416644 416649 416659 416686 416699 416712 419819 424765 428174 432613 432936 439195 439993 445413 451336 453788 455080 456190 465470 465618 466427 467112 467872 469615 470471 471455 476054 477506 477761 483736 500290 500340 500341 506516 524346 524678 526905 532778 532847 534777 540572 541836 542524 544404 545305 546129 548157 550916 563992 578484 584301 590263 604228 620891 620901 632678 632887 634100 636948 642022 647838 658802 658819 662072 662448 662856 665958 666528 672925 672938 674968 675375 680249 680252 696593 713501 713507 723461 728269 738822 739558 740932 742363 745128 749067 749221 752633 752681 756233 766943 770262 770397 784775 788192 789028 791012 794307 803134 ] |
||||||||||||||||||||||||||||||
|
17.46 ms (4.45%) |
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 723461 658819 662072 696593 632887 634100 739558 154463 415879 662448 477761 432936 500290 428174 532778 563992 467872 381812 412814 416230 416611 416659 432613 416649 416699 524678 534777 483736 680249 620891 752633 476054 386858 416686 419819 451336 445413 384397 403896 467112 526905 340635 541836 182232 548157 675375 416525 415965 465470 469615 439993 500340 500341 590263 471455 416583 770397 620901 789028 584301 791012 794307 532847 545305 647838 666528 506516 540572 674968 632678 398100 453788 524346 672925 546129 604228 636948 756233 182135 393313 466427 550916 658802 662856 665958 672938 680252 713501 713507 784775 788192 740932 752681 728269 749067 749221 766943 770262 738822 742363 745128 803134 477506 642022 542524 578484 416712 424765 455080 88286 414259 386156 401204 439195 465618 470471 544404 456190 392004 416644 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.53%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал дилд фистинг"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal dildo fisting"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.43%) |
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.