Query Metrics
7
Database Queries
7
Different statements
161.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.99 ms (82.50%) |
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 390402 395563 395863 401073 404311 404777 415189 415801 420860 424197 424895 426503 428488 436719 440827 445741 454813 457640 459654 460697 461186 463792 466693 468707 491609 491947 493300 496565 507500 509566 512800 512818 513715 518553 518621 519372 521589 528071 529912 530799 533690 540100 555834 557572 558443 576966 590192 591666 593865 597726 602995 603678 607023 620121 621392 625521 632090 640388 651276 652708 661896 668559 682348 684200 687362 688998 689521 699398 703140 712278 720198 720241 720659 720878 722014 724853 725601 726169 726366 727799 729826 730947 733572 735554 737130 737465 738624 741076 742685 744368 745556 746213 758216 761088 761591 761850 766623 770888 774182 784308 791578 792594 793877 794296 794797 794817 796143 800513 803463 805502 806715 811870 812092 814399 814606 814844 815270 817482 823275 827850 ] |
||||||||||||||||||||||||||||||
|
16.78 ms (10.41%) |
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 805502 761591 741076 703140 602995 794817 460697 420860 814606 491609 512800 513715 684200 720198 722014 625521 632090 724853 761850 774182 712278 404311 426503 459654 518621 491947 512818 597726 758216 761088 817482 815270 468707 533690 540100 461186 687362 661896 558443 590192 791578 793877 806715 725601 770888 784308 726366 738624 744368 735554 737465 730947 737130 742685 794797 800513 457640 726169 445741 496565 529912 688998 593865 620121 603678 621392 463792 424197 493300 521589 404777 415801 436719 668559 814844 454813 466693 689521 727799 733572 812092 395563 395863 440827 557572 682348 591666 607023 794296 401073 415189 509566 507500 519372 576966 827850 424895 814399 823275 518553 530799 555834 720659 651276 652708 699398 720878 640388 796143 811870 746213 803463 729826 745556 766623 720241 792594 390402 428488 528071 ] |
||||||||||||||||||||||||||||||
|
4.02 ms (2.49%) |
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 390402 395563 395863 401073 404311 404777 415189 415801 420860 424197 424895 426503 428488 436719 440827 445741 454813 457640 459654 460697 461186 463792 466693 468707 491609 491947 493300 496565 507500 509566 512800 512818 513715 518553 518621 519372 521589 528071 529912 530799 533690 540100 555834 557572 558443 576966 590192 591666 593865 597726 602995 603678 607023 620121 621392 625521 632090 640388 651276 652708 661896 668559 682348 684200 687362 688998 689521 699398 703140 712278 720198 720241 720659 720878 722014 724853 725601 726169 726366 727799 729826 730947 733572 735554 737130 737465 738624 741076 742685 744368 745556 746213 758216 761088 761591 761850 766623 770888 774182 784308 791578 792594 793877 794296 794797 794817 796143 800513 803463 805502 806715 811870 812092 814399 814606 814844 815270 817482 823275 827850 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"husband anal"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"husband анал"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"husband анал"
]
|
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.