Query Metrics
7
Database Queries
7
Different statements
201.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.45 ms (85.78%) |
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 124144 382154 397372 397853 398968 398969 400842 400859 403363 405977 406899 407769 407867 408157 411697 411698 411717 411738 411912 413074 413090 414014 422288 426607 427467 428472 428512 428853 429550 433658 439570 439630 439636 439721 443147 443407 443688 443702 444107 446020 450306 453062 453681 454234 457189 459907 460600 460906 461071 462106 462572 462690 462694 464339 464341 464386 465592 465825 466072 466087 466109 466117 466143 466893 467279 469336 469911 474077 474793 476282 476284 476341 477720 477962 478793 478801 479108 479112 480375 481933 482322 482325 482999 483135 483365 483382 484421 484686 486255 486958 488959 489016 490910 492062 493896 496871 497620 502811 504837 506829 510363 512536 513833 516808 517953 518834 519154 526735 546119 547605 547622 559064 563066 563431 563444 573741 578011 581692 590503 629762 ] |
||||||||||||||||||||||||||||||
|
20.45 ms (10.17%) |
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 460600 465592 474077 480375 476282 563066 546119 547605 573741 578011 629762 407867 428853 439630 462694 464341 464386 400859 408157 413090 460906 466117 397853 478793 481933 400842 428472 429550 443688 443702 465825 466143 477962 422288 517953 483382 496871 513833 484686 506829 406899 411738 446020 457189 462690 469336 483365 464339 502811 478801 559064 454234 462106 466072 466893 439721 462572 466109 476284 482325 398969 411697 411912 450306 453062 476341 433658 444107 466087 489016 497620 516808 483135 484421 504837 439636 482999 453681 547622 563431 467279 398968 479112 477720 486958 490910 492062 488959 519154 124144 439570 474793 482322 405977 407769 443407 493896 397372 411717 581692 427467 459907 510363 426607 469911 486255 443147 414014 461071 512536 563444 590503 479108 526735 518834 382154 403363 411698 413074 428512 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.13%) |
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 124144 382154 397372 397853 398968 398969 400842 400859 403363 405977 406899 407769 407867 408157 411697 411698 411717 411738 411912 413074 413090 414014 422288 426607 427467 428472 428512 428853 429550 433658 439570 439630 439636 439721 443147 443407 443688 443702 444107 446020 450306 453062 453681 454234 457189 459907 460600 460906 461071 462106 462572 462690 462694 464339 464341 464386 465592 465825 466072 466087 466109 466117 466143 466893 467279 469336 469911 474077 474793 476282 476284 476341 477720 477962 478793 478801 479108 479112 480375 481933 482322 482325 482999 483135 483365 483382 484421 484686 486255 486958 488959 489016 490910 492062 493896 496871 497620 502811 504837 506829 510363 512536 513833 516808 517953 518834 519154 526735 546119 547605 547622 559064 563066 563431 563444 573741 578011 581692 590503 629762 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ебля старые с молодым%…"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.68%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс старые молодым"
]
|
||||||||||||||||||||||||||||||
|
1.17 ms (0.58%) |
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.