Query Metrics
7
Database Queries
7
Different statements
158.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.42 ms (84.34%) |
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 41433 96259 233443 382281 393480 397265 398099 400942 411183 414050 414062 416583 417366 422180 428305 432181 436639 439292 440710 446562 448642 452827 455918 457137 467982 480211 487429 493271 494156 500338 505328 505459 505798 506371 510544 511375 516588 516597 536236 536388 546262 549020 551556 558736 560982 577381 584260 590799 599134 602233 604171 608262 618859 620974 625624 627049 628053 628205 648671 650305 652874 655281 656931 657527 658774 658803 658850 661455 661987 662194 664717 669370 681787 681805 687399 692095 697671 706133 722403 723934 724854 725608 733798 734966 740820 741301 745457 749118 750358 750449 750917 752619 756825 758977 762253 764817 764820 765221 765593 768261 770400 770419 771593 780526 781326 782443 782511 783084 787755 788321 793281 794155 796232 796917 799683 802029 804306 819862 ] |
||||||||||||||||||||||||||||||
|
14.71 ms (9.30%) |
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 723934 734966 758977 725608 233443 650305 781326 628205 536388 782443 627049 604171 764820 764817 400942 417366 819862 411183 493271 505328 439292 494156 802029 422180 467982 625624 724854 397265 661987 771593 505459 560982 618859 620974 608262 455918 558736 436639 505798 382281 656931 590799 756825 768261 487429 414062 551556 584260 657527 658850 658774 661455 662194 706133 648671 652874 655281 664717 793281 741301 750917 765593 770400 770419 782511 794155 752619 799683 398099 416583 500338 446562 823492 536236 516597 546262 681787 681805 733798 750358 757736 749118 762253 740820 41433 658803 687399 722403 787755 788321 780526 796917 783084 628053 796232 440710 452827 577381 804306 414050 432181 428305 448642 516588 510544 750449 96259 599134 745457 602233 457137 393480 511375 765221 669370 480211 506371 549020 692095 697671 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (1.96%) |
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 41433 96259 233443 382281 393480 397265 398099 400942 411183 414050 414062 416583 417366 422180 428305 432181 436639 439292 440710 446562 448642 452827 455918 457137 467982 480211 487429 493271 494156 500338 505328 505459 505798 506371 510544 511375 516588 516597 536236 536388 546262 549020 551556 558736 560982 577381 584260 590799 599134 602233 604171 608262 618859 620974 625624 627049 628053 628205 648671 650305 652874 655281 656931 657527 658774 658803 658850 661455 661987 662194 664717 669370 681787 681805 687399 692095 697671 706133 722403 723934 724854 725608 733798 734966 740820 741301 745457 749118 750358 750449 750917 752619 756825 758977 762253 764817 764820 765221 765593 768261 770400 770419 771593 780526 781326 782443 782511 783084 787755 788321 793281 794155 796232 796917 799683 802029 804306 819862 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl masturbation anal"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк мастурбац анал"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.98%) |
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.