Query Metrics
7
Database Queries
7
Different statements
253.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
223.74 ms (88.21%) |
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 16897 315244 385831 397265 401793 402626 410690 411183 414114 414252 414675 415303 415874 415877 415966 416170 416561 416624 416648 416681 416684 416694 416696 418780 419439 428299 428955 429594 429608 430262 430350 430559 431385 434443 439169 439240 441354 443086 444535 447144 447151 448588 448642 449173 451316 457293 466842 473413 474900 477246 482280 482283 483583 483705 487418 488817 493398 493717 493825 494493 497474 499934 509833 511933 519699 523063 523393 527526 527531 527922 529003 529020 529069 531588 531655 534764 534839 541442 545392 553761 558082 576128 576320 580114 583290 583385 595339 595488 600125 601696 604229 605791 606365 619679 624191 639481 648648 656803 658777 670997 671648 674181 692691 697833 703586 704065 709917 715165 722273 722483 744949 750600 751067 770401 776927 782872 783651 824668 825442 ] |
||||||||||||||||||||||||||||||
|
18.61 ms (7.34%) |
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 744949 401793 527531 604229 595488 416170 431385 416694 429594 447144 430559 457293 509833 493398 434443 385831 648648 670997 671648 722483 606365 750600 751067 583290 715165 697833 531655 558082 692691 704065 783651 639481 782872 419439 429608 430262 416681 447151 497689 534764 488817 541442 583385 545392 576128 553761 624191 619679 595339 443086 414114 482283 477246 519699 415966 473413 444535 415874 439240 466842 511933 499934 605791 600125 428955 448588 397265 439169 428299 448642 411183 523063 523393 418780 825442 824668 474900 493717 529003 529020 527526 531588 576320 703586 656803 722273 658777 776927 770401 414252 16897 315244 402626 416624 430350 415303 416561 414675 416648 416684 410690 415877 416696 441354 482280 449173 451316 483705 483583 493825 494493 497474 527922 529069 534839 487418 580114 709917 674181 601696 ] |
||||||||||||||||||||||||||||||
|
3.43 ms (1.35%) |
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 16897 315244 385831 397265 401793 402626 410690 411183 414114 414252 414675 415303 415874 415877 415966 416170 416561 416624 416648 416681 416684 416694 416696 418780 419439 428299 428955 429594 429608 430262 430350 430559 431385 434443 439169 439240 441354 443086 444535 447144 447151 448588 448642 449173 451316 457293 466842 473413 474900 477246 482280 482283 483583 483705 487418 488817 493398 493717 493825 494493 497474 499934 509833 511933 519699 523063 523393 527526 527531 527922 529003 529020 529069 531588 531655 534764 534839 541442 545392 553761 558082 576128 576320 580114 583290 583385 595339 595488 600125 601696 604229 605791 606365 619679 624191 639481 648648 656803 658777 670997 671648 674181 692691 697833 703586 704065 709917 715165 722273 722483 744949 750600 751067 770401 776927 782872 783651 824668 825442 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд мастурбац teen"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд мастурбац teen"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo masturbation teen"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.73%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.