Query Metrics
7
Database Queries
7
Different statements
482.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
240.86 ms (49.95%) |
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 392077 393222 395622 397102 398701 415836 416523 416689 419325 423338 427159 432752 438613 439844 441611 447955 456201 456627 456706 459360 464648 470742 471515 477441 486814 492313 495527 495929 496076 498822 501148 503953 504297 507395 511803 516615 517691 519472 521971 523138 524877 526024 527808 529488 537630 537774 541902 543790 543960 546680 547191 552766 554017 554646 555819 557983 559009 565844 565914 567429 567863 571259 572004 592538 600455 614330 617259 630639 639889 652125 652622 660787 661652 666415 683011 693875 694131 701344 701970 704984 712955 716311 731404 736012 739557 747501 750653 752547 756149 756690 760083 765920 766852 771903 777489 778303 779561 780363 783955 784500 787536 787933 790036 790349 791181 791475 796994 798711 802985 803991 807068 810816 813314 817378 818241 823352 823367 824764 825795 826713 ] |
||||||||||||||||||||||||||||||
|
230.10 ms (47.72%) |
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 504297 503953 527808 392077 818241 817378 517691 507395 554017 701344 660787 780363 766852 731404 747501 783955 438613 416689 495929 419325 441611 486814 529488 547191 652622 791181 423338 393222 565844 694131 807068 778303 760083 756149 796994 398701 543790 543960 557983 630639 739557 523138 572004 447955 477441 470742 519472 516615 521971 498822 416523 825795 541902 552766 683011 701970 693875 704984 592538 600455 752547 787536 427159 397102 826713 823367 824764 712955 614330 802985 771903 617259 777489 779561 813314 459360 471515 495527 567429 546680 554646 790036 395622 456627 511803 823352 492313 639889 790349 784500 810816 716311 415836 432752 456201 501148 524877 555819 567863 652125 559009 565914 456706 439844 526024 464648 496076 537630 537774 571259 661652 666415 791475 798711 765920 756690 736012 750653 787933 803991 ] |
||||||||||||||||||||||||||||||
|
4.01 ms (0.83%) |
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 392077 393222 395622 397102 398701 415836 416523 416689 419325 423338 427159 432752 438613 439844 441611 447955 456201 456627 456706 459360 464648 470742 471515 477441 486814 492313 495527 495929 496076 498822 501148 503953 504297 507395 511803 516615 517691 519472 521971 523138 524877 526024 527808 529488 537630 537774 541902 543790 543960 546680 547191 552766 554017 554646 555819 557983 559009 565844 565914 567429 567863 571259 572004 592538 600455 614330 617259 630639 639889 652125 652622 660787 661652 666415 683011 693875 694131 701344 701970 704984 712955 716311 731404 736012 739557 747501 750653 752547 756149 756690 760083 765920 766852 771903 777489 778303 779561 780363 783955 784500 787536 787933 790036 790349 791181 791475 796994 798711 802985 803991 807068 810816 813314 817378 818241 823352 823367 824764 825795 826713 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (0.51%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер young девушк"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam young girls"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер young девушк"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.31%) |
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.