Query Metrics
7
Database Queries
7
Different statements
218.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
193.64 ms (88.55%) |
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 233733 409093 475682 519251 522914 524951 538895 538937 541398 541822 541872 541889 542960 544500 544571 544586 547909 548278 548307 549767 549771 554804 556847 559060 560958 560993 561033 563223 563423 563533 567404 567423 567424 567425 571439 574235 576634 576645 576678 576684 576711 576713 577363 581259 583387 583885 589204 590417 591294 592450 592515 593207 593236 599172 614258 615167 619482 620142 620147 620150 620156 621319 621323 621698 622372 622377 629898 641370 644285 644296 645233 653330 663507 668559 669567 670108 671734 671740 671751 672138 677706 683256 687119 690810 690870 691510 694212 694563 695249 695276 696355 697369 698423 698550 699546 699607 699730 703091 703436 703525 703833 706611 708422 708462 716409 717859 719097 719873 721715 724173 727828 729821 734493 742971 753257 789844 790814 790986 808093 817298 ] |
||||||||||||||||||||||||||||||
|
15.29 ms (6.99%) |
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 690870 691510 695276 699607 716409 719097 645233 670108 672138 677706 690810 694563 696355 697369 703525 706611 717859 719873 653330 669567 671734 671740 671751 683256 687119 694212 695249 698423 699546 708422 556847 560993 561033 563423 567404 567423 581259 589204 592450 620147 622372 644285 590417 620142 621319 593207 615167 620156 592515 593236 619482 622377 790986 753257 789844 808093 724173 727828 734493 729821 742971 621323 629898 644296 698550 699730 703091 703436 708462 721715 790814 233733 409093 519251 522914 548278 576713 542960 576645 576711 703833 541889 563223 541822 541872 544500 549767 559060 567424 567425 574235 576678 583387 541398 663507 549771 576634 576684 583885 599172 591294 614258 620150 641370 524951 621698 668559 817298 475682 538895 538937 544571 548307 554804 571439 577363 544586 547909 560958 563533 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.18%) |
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 233733 409093 475682 519251 522914 524951 538895 538937 541398 541822 541872 541889 542960 544500 544571 544586 547909 548278 548307 549767 549771 554804 556847 559060 560958 560993 561033 563223 563423 563533 567404 567423 567424 567425 571439 574235 576634 576645 576678 576684 576711 576713 577363 581259 583387 583885 589204 590417 591294 592450 592515 593207 593236 599172 614258 615167 619482 620142 620147 620150 620156 621319 621323 621698 622372 622377 629898 641370 644285 644296 645233 653330 663507 668559 669567 670108 671734 671740 671751 672138 677706 683256 687119 690810 690870 691510 694212 694563 695249 695276 696355 697369 698423 698550 699546 699607 699730 703091 703436 703525 703833 706611 708422 708462 716409 717859 719097 719873 721715 724173 727828 729821 734493 742971 753257 789844 790814 790986 808093 817298 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"retro mature and"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ретр mature"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ретр mature"
]
|
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.