Query Metrics
7
Database Queries
7
Different statements
229.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
203.48 ms (88.79%) |
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 6656 7390 55731 316153 386083 389351 389757 390264 390934 397325 397848 402896 404386 410308 422477 423886 429863 432580 439806 439856 442545 447600 451473 452260 455603 456573 457468 458178 470166 470948 470964 480385 480389 482522 485363 490899 490904 493308 515720 515866 517204 529437 532780 536440 544834 552482 553660 555091 557027 564393 564394 568643 574422 584101 586962 588363 592536 598958 603807 604257 604270 617044 618808 618843 620253 674328 677357 695724 727040 728170 728379 729277 731898 737910 740908 741896 742729 742880 746570 750550 755164 757077 757099 758693 759702 765403 765459 765718 766710 768031 773912 777058 778215 781049 782294 784162 785558 787567 788852 792986 795296 795731 796050 796081 797390 799701 800573 800697 801294 801298 803920 807383 811102 811925 812018 814906 816985 818051 828457 828549 ] |
||||||||||||||||||||||||||||||
|
15.18 ms (6.62%) |
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 617044 755164 402896 493308 695724 800573 742729 795731 728170 757099 6656 564394 604270 618808 536440 482522 553660 564393 765403 727040 458178 485363 515720 750550 757077 800697 731898 759702 480389 584101 788852 386083 432580 470964 592536 741896 389351 740908 604257 765459 620253 457468 811102 456573 814906 737910 742880 768031 389757 598958 777058 828457 390264 568643 422477 452260 410308 828549 439856 7390 555091 447600 557027 423886 429863 55731 439806 470948 778215 397848 442545 674328 618843 480385 532780 807383 785558 490899 677357 544834 784162 766710 782294 574422 517204 603807 811925 781049 801298 796081 803920 455603 470166 451473 490904 796050 792986 552482 529437 588363 746570 758693 816985 797390 729277 390934 818051 787567 765718 404386 799701 801294 812018 795296 728379 773912 397325 586962 316153 515866 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.22%) |
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 6656 7390 55731 316153 386083 389351 389757 390264 390934 397325 397848 402896 404386 410308 422477 423886 429863 432580 439806 439856 442545 447600 451473 452260 455603 456573 457468 458178 470166 470948 470964 480385 480389 482522 485363 490899 490904 493308 515720 515866 517204 529437 532780 536440 544834 552482 553660 555091 557027 564393 564394 568643 574422 584101 586962 588363 592536 598958 603807 604257 604270 617044 618808 618843 620253 674328 677357 695724 727040 728170 728379 729277 731898 737910 740908 741896 742729 742880 746570 750550 755164 757077 757099 758693 759702 765403 765459 765718 766710 768031 773912 777058 778215 781049 782294 784162 785558 787567 788852 792986 795296 795731 796050 796081 797390 799701 800573 800697 801294 801298 803920 807383 811102 811925 812018 814906 816985 818051 828457 828549 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal-pantyhose"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал pantyhose"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал pantyhose"
]
|
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.