Query Metrics
7
Database Queries
7
Different statements
206.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.94 ms (83.85%) |
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 75735 242127 397142 398444 403939 417801 418934 420291 420925 421062 427259 428103 429572 429875 430404 431352 432131 437868 440625 442318 444003 445436 448816 448839 449115 449778 451951 452034 452061 452082 453113 466643 467611 469616 471357 471380 473204 475828 477210 477890 479020 480340 482527 484684 484727 486589 486944 487717 488734 489082 491790 492602 492916 494985 496794 498551 501242 504481 506801 510286 516291 516744 516769 517008 519727 525359 525864 527008 527669 528089 528452 529213 531513 531981 532661 534377 535460 541651 541888 550571 552306 556535 558788 560190 560433 562885 569558 573309 581112 586440 586497 588244 591637 599160 600138 600349 600979 601053 601669 603703 608358 608376 612256 613171 622398 623818 639824 643364 646176 647854 647948 650380 650806 651601 688586 696964 715710 759036 823990 827724 ] |
||||||||||||||||||||||||||||||
|
22.52 ms (10.92%) |
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 452082 480340 449115 477890 492916 486589 491790 516291 516769 531513 504481 525359 496794 501242 469616 558788 573309 688586 560190 586497 601053 639824 601669 420925 432131 449778 471357 479020 442318 427259 431352 452061 527669 528452 484684 488734 498551 516744 535460 541651 489082 519727 525864 823990 560433 715710 759036 612256 75735 397142 827724 600138 420291 444003 418934 452034 451951 527008 529213 534377 581112 550571 552306 647854 646176 562885 591637 622398 599160 600979 603703 608358 623818 475828 429572 473204 421062 471380 484727 486944 242127 398444 453113 696964 569558 466643 417801 440625 428103 437868 445436 477210 482527 531981 506801 510286 532661 467611 541888 647948 650380 650806 651601 556535 588244 600349 586440 608376 643364 613171 448816 403939 430404 448839 487717 492602 517008 528089 494985 429875 ] |
||||||||||||||||||||||||||||||
|
3.60 ms (1.74%) |
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 75735 242127 397142 398444 403939 417801 418934 420291 420925 421062 427259 428103 429572 429875 430404 431352 432131 437868 440625 442318 444003 445436 448816 448839 449115 449778 451951 452034 452061 452082 453113 466643 467611 469616 471357 471380 473204 475828 477210 477890 479020 480340 482527 484684 484727 486589 486944 487717 488734 489082 491790 492602 492916 494985 496794 498551 501242 504481 506801 510286 516291 516744 516769 517008 519727 525359 525864 527008 527669 528089 528452 529213 531513 531981 532661 534377 535460 541651 541888 550571 552306 556535 558788 560190 560433 562885 569558 573309 581112 586440 586497 588244 591637 599160 600138 600349 600979 601053 601669 603703 608358 608376 612256 613171 622398 623818 639824 643364 646176 647854 647948 650380 650806 651601 688586 696964 715710 759036 823990 827724 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"shaving hairy"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"shaving волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"shaving волосатая"
]
|
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.