Query Metrics
7
Database Queries
7
Different statements
157.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.74 ms (85.33%) |
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 62124 119646 149406 182285 213136 316153 352187 383932 387744 392565 396016 396932 408518 411373 422477 432372 432522 432547 433591 434252 439856 451458 451473 466130 466408 470948 472948 478129 480385 490412 490904 494043 496203 500497 503812 507540 507749 509641 514109 525268 530403 534013 546307 548213 550546 555202 557027 558209 564299 564797 568254 569304 571494 574422 587881 588957 601118 605912 609784 619907 629146 637173 648987 650746 658483 661674 665052 668182 695334 695407 695424 699938 715444 716143 718227 718717 724828 725533 727534 731800 733208 735925 736155 739400 742097 757025 758339 759623 759732 760969 761144 765567 767682 768576 772881 775649 778215 778608 781049 788661 789138 789985 790808 795166 796061 796544 799377 810597 811708 812444 816985 816987 817570 825473 825614 825654 826286 828567 ] |
||||||||||||||||||||||||||||||
|
12.09 ms (7.66%) |
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 480385 472948 548213 557027 558209 571494 601118 422477 466130 432372 432547 433591 432522 434252 478129 509641 525268 500497 490904 564299 699938 772881 790808 149406 799377 727534 765567 119646 316153 824851 828567 795166 796544 767682 761144 760969 768576 733208 778215 789985 736155 609784 817570 781049 810597 383932 466408 735925 759732 392565 396932 514109 496203 661674 637173 788661 724828 759623 758339 534013 587881 796061 789138 725533 742097 775649 778608 812444 411373 665052 715444 619907 811708 731800 629146 503812 574422 569304 387744 650746 743671 62124 352187 568254 555202 739400 757025 439856 451458 470948 451473 490412 494043 507540 507749 182285 213136 396016 408518 816985 816987 825654 825473 825614 826286 530403 564797 546307 550546 716143 718227 718717 668182 695407 695424 648987 658483 695334 588957 605912 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.86%) |
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 62124 119646 149406 182285 213136 316153 352187 383932 387744 392565 396016 396932 408518 411373 422477 432372 432522 432547 433591 434252 439856 451458 451473 466130 466408 470948 472948 478129 480385 490412 490904 494043 496203 500497 503812 507540 507749 509641 514109 525268 530403 534013 546307 548213 550546 555202 557027 558209 564299 564797 568254 569304 571494 574422 587881 588957 601118 605912 609784 619907 629146 637173 648987 650746 658483 661674 665052 668182 695334 695407 695424 699938 715444 716143 718227 718717 724828 725533 727534 731800 733208 735925 736155 739400 742097 757025 758339 759623 759732 760969 761144 765567 767682 768576 772881 775649 778215 778608 781049 788661 789138 789985 790808 795166 796061 796544 799377 810597 811708 812444 816985 816987 817570 825473 825614 825654 826286 828567 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass pantyhose"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп pantyhose"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.05%) |
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.