Query Metrics
7
Database Queries
7
Different statements
217.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
184.30 ms (84.70%) |
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 73052 74135 133695 383112 384118 384594 385009 385379 387779 388795 390108 398642 418718 423812 425670 429020 431455 448642 449112 452576 452942 453270 454570 457992 458564 460979 462224 463214 463896 465909 470225 472749 475097 476646 488789 488887 493553 494247 495543 495553 498972 500060 511611 514731 518505 521266 528995 529017 530106 535336 537480 541123 543021 552358 561971 571997 573289 574767 577381 577805 579381 580184 584968 585935 600125 605087 648206 650727 652772 672812 724508 724854 725786 728472 729142 733428 734877 735750 739297 740375 743236 744933 745521 745591 746028 751044 751111 751243 752916 755038 757518 758606 761344 768255 771709 780848 783733 784678 785263 785492 785974 786434 787354 790485 794155 794471 797050 802220 802273 802937 806566 807536 807571 809706 810458 812477 812488 814412 818798 823887 ] |
||||||||||||||||||||||||||||||
|
22.75 ms (10.45%) |
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 802273 810458 729142 739297 740375 743236 752916 784678 785263 786434 787354 794471 807536 807571 812477 728472 744933 745591 751044 725786 733428 734877 735750 746028 768255 755038 761344 751243 757518 771709 605087 780848 783733 785492 785974 794155 797050 802937 809706 812488 385379 384594 418718 454570 495553 385009 133695 390108 387779 429020 814412 493553 452576 453270 462224 470225 488789 488887 457992 476646 530106 463896 561971 577381 579381 543021 571997 573289 574767 577805 584968 672812 600125 585935 802220 751111 806566 724508 745521 758606 724854 790485 463214 431455 384118 398642 423812 425670 448642 452942 460979 465909 514731 500060 518505 521266 495543 498972 535336 383112 73052 74135 388795 818798 823887 458564 472749 475097 449112 537480 494247 511611 528995 529017 541123 552358 580184 648206 650727 652772 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (1.40%) |
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 73052 74135 133695 383112 384118 384594 385009 385379 387779 388795 390108 398642 418718 423812 425670 429020 431455 448642 449112 452576 452942 453270 454570 457992 458564 460979 462224 463214 463896 465909 470225 472749 475097 476646 488789 488887 493553 494247 495543 495553 498972 500060 511611 514731 518505 521266 528995 529017 530106 535336 537480 541123 543021 552358 561971 571997 573289 574767 577381 577805 579381 580184 584968 585935 600125 605087 648206 650727 652772 672812 724508 724854 725786 728472 729142 733428 734877 735750 739297 740375 743236 744933 745521 745591 746028 751044 751111 751243 752916 755038 757518 758606 761344 768255 771709 780848 783733 784678 785263 785492 785974 786434 787354 790485 794155 794471 797050 802220 802273 802937 806566 807536 807571 809706 810458 812477 812488 814412 818798 823887 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац sexy"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation sexy"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мастурбац sexy"
]
|
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.