Query Metrics
7
Database Queries
7
Different statements
190.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.41 ms (88.25%) |
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 96269 96484 129748 218768 307458 348409 382766 383375 384847 385970 386072 388635 388690 388789 395446 395706 395824 396744 398909 399094 399926 400138 403021 404257 405174 406457 408692 409184 410090 410093 411047 417179 419702 420094 420392 429713 440624 443810 457782 458331 459999 461210 467749 469913 474488 474955 475933 476426 484131 484385 492261 508405 508967 513780 523689 548788 550416 553153 555689 556016 566038 569134 569549 570698 593894 595786 596990 600173 600225 603166 603178 606587 613864 617217 619247 621976 622131 631954 632698 633807 636322 640700 641965 645999 653177 653594 661970 667757 673143 676777 679770 691995 705160 711998 719001 721298 722822 724507 728386 734506 737394 742199 744649 756775 758969 762221 766129 775928 784859 785096 787344 790034 801894 804462 807514 807635 808999 809647 809931 810827 ] |
||||||||||||||||||||||||||||||
|
12.96 ms (6.79%) |
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 550416 553153 555689 566038 570698 676777 691995 719001 653177 667757 673143 679770 705160 711998 645999 653594 661970 722822 548788 556016 569134 569549 600173 603178 606587 631954 632698 595786 622131 593894 596990 603166 613864 619247 600225 617217 621976 640700 790034 809931 775928 807514 808999 737394 762221 807635 810827 728386 756775 724507 734506 742199 758969 744649 766129 633807 636322 641965 721298 784859 785096 787344 804462 809647 385970 408692 420392 429713 458331 476426 96269 218768 383375 388690 395706 400138 403021 404257 409184 410093 440624 443810 461210 467749 474488 388635 395446 398909 399094 399926 405174 388789 395824 396744 406457 410090 411047 419702 457782 459999 469913 474955 417179 420094 475933 484385 492261 508967 513780 508405 523689 484131 801894 386072 382766 96484 384847 129748 348409 307458 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (1.43%) |
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 96269 96484 129748 218768 307458 348409 382766 383375 384847 385970 386072 388635 388690 388789 395446 395706 395824 396744 398909 399094 399926 400138 403021 404257 405174 406457 408692 409184 410090 410093 411047 417179 419702 420094 420392 429713 440624 443810 457782 458331 459999 461210 467749 469913 474488 474955 475933 476426 484131 484385 492261 508405 508967 513780 523689 548788 550416 553153 555689 556016 566038 569134 569549 570698 593894 595786 596990 600173 600225 603166 603178 606587 613864 617217 619247 621976 622131 631954 632698 633807 636322 640700 641965 645999 653177 653594 661970 667757 673143 676777 679770 691995 705160 711998 719001 721298 722822 724507 728386 734506 737394 742199 744649 756775 758969 762221 766129 775928 784859 785096 787344 790034 801894 804462 807514 807635 808999 809647 809931 810827 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"порно секс ролики"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"порн секс ролик"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.33 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"порн секс ролик"
]
|
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.