Query Metrics
7
Database Queries
7
Different statements
232.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.69 ms (88.12%) |
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 154491 382205 386497 397478 402648 408880 414253 415921 419633 420277 420874 427539 427714 428742 428924 429566 430366 431234 432927 437708 439146 443248 444540 444922 445810 447318 447734 451082 452595 452792 452807 452850 452873 452875 452903 452914 452915 452923 453160 453170 453223 455084 456700 457486 459851 462223 466842 467110 469221 469741 473038 473087 477169 477411 478998 481861 482731 487425 493744 497690 498619 499936 500327 500779 502770 505370 510781 512674 514941 522288 522639 523896 525970 530956 532381 535916 536377 536474 538725 541277 541328 548954 549549 550919 553441 557343 559294 560054 561189 562585 568302 568303 572777 575610 576321 576979 579381 583472 594208 652249 655458 660441 664236 669668 674204 679194 686821 691808 696594 712433 713185 783745 784744 785851 813809 814411 814418 814470 814519 819862 ] |
||||||||||||||||||||||||||||||
|
16.94 ms (7.29%) |
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 783745 784744 785851 382205 397478 443248 477411 386497 459851 437708 452792 473087 431234 500779 505370 420277 432927 445810 447318 497690 469221 594208 428924 452923 430366 452875 522288 154491 402648 415921 420874 428742 408880 427714 439146 444540 414253 427539 444922 419633 429566 814418 813809 814519 819862 814411 814470 452595 452914 452915 453223 455084 457486 469741 447734 451082 452873 452903 453160 456700 466842 467110 481861 452807 452850 453170 462223 473038 478998 482731 493744 498619 510781 512674 525970 532381 536474 499936 500327 502770 535916 536377 538725 514941 522639 523896 530956 477169 487425 541277 548954 553441 557343 560054 568303 575610 579381 583472 541328 549549 550919 559294 562585 572777 576979 561189 568302 576321 655458 664236 669668 674204 679194 712433 713185 652249 660441 686821 691808 696594 ] |
||||||||||||||||||||||||||||||
|
3.39 ms (1.46%) |
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 154491 382205 386497 397478 402648 408880 414253 415921 419633 420277 420874 427539 427714 428742 428924 429566 430366 431234 432927 437708 439146 443248 444540 444922 445810 447318 447734 451082 452595 452792 452807 452850 452873 452875 452903 452914 452915 452923 453160 453170 453223 455084 456700 457486 459851 462223 466842 467110 469221 469741 473038 473087 477169 477411 478998 481861 482731 487425 493744 497690 498619 499936 500327 500779 502770 505370 510781 512674 514941 522288 522639 523896 525970 530956 532381 535916 536377 536474 538725 541277 541328 548954 549549 550919 553441 557343 559294 560054 561189 562585 568302 568303 572777 575610 576321 576979 579381 583472 594208 652249 655458 660441 664236 669668 674204 679194 686821 691808 696594 712433 713185 783745 784744 785851 813809 814411 814418 814470 814519 819862 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло teen toys"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло teen toys"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo teen toys"
]
|
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.