Query Metrics
7
Database Queries
7
Different statements
608.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
266.04 ms (43.73%) |
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 532984 537200 537206 540404 545383 544827 543877 544784 544803 544812 645238 647320 647663 647879 666874 666899 648889 651079 676025 676110 677672 677801 678533 679733 679799 702164 645952 647322 647885 648815 651147 666897 676107 678066 565241 630765 640758 640789 642061 601579 639762 600352 632561 637145 596082 599868 600342 640759 641667 643376 731665 617416 633768 642038 708443 510394 518493 467608 523225 536645 536653 530784 531259 533370 556480 645276 647355 647830 650158 582376 600296 599863 599961 599965 600019 745384 632283 633775 644918 476753 446167 522157 537685 523558 537654 530791 536262 475275 646007 646025 649970 677294 678141 651089 668534 677674 679029 695124 676097 677766 678159 680167 708447 589524 637044 599914 631212 632659 633749 634118 641690 465605 629963 617421 536712 447924 452018 532995 533944 510198 ] |
||||||||||||||||||||||||||||||
|
208.31 ms (34.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"interracial anal casting"
]
|
||||||||||||||||||||||||||||||
|
126.81 ms (20.84%) |
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 446167 447924 452018 465605 467608 475275 476753 510198 510394 518493 522157 523225 523558 530784 530791 531259 532984 532995 533370 533944 536262 536645 536653 536712 537200 537206 537654 537685 540404 543877 544784 544803 544812 544827 545383 556480 565241 582376 589524 596082 599863 599868 599914 599961 599965 600019 600296 600342 600352 601579 617416 617421 629963 630765 631212 632283 632561 632659 633749 633768 633775 634118 637044 637145 639762 640758 640759 640789 641667 641690 642038 642061 643376 644918 645238 645276 645952 646007 646025 647320 647322 647355 647663 647830 647879 647885 648815 648889 649970 650158 651079 651089 651147 666874 666897 666899 668534 676025 676097 676107 676110 677294 677672 677674 677766 677801 678066 678141 678159 678533 679029 679733 679799 680167 695124 702164 708443 708447 731665 745384 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (0.40%) |
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 446167 447924 452018 465605 467608 475275 476753 510198 510394 518493 522157 523225 523558 530784 530791 531259 532984 532995 533370 533944 536262 536645 536653 536712 537200 537206 537654 537685 540404 543877 544784 544803 544812 544827 545383 556480 565241 582376 589524 596082 599863 599868 599914 599961 599965 600019 600296 600342 600352 601579 617416 617421 629963 630765 631212 632283 632561 632659 633749 633768 633775 634118 637044 637145 639762 640758 640759 640789 641667 641690 642038 642061 643376 644918 645238 645276 645952 646007 646025 647320 647322 647355 647663 647830 647879 647885 648815 648889 649970 650158 651079 651089 651147 666874 666897 666899 668534 676025 676097 676107 676110 677294 677672 677674 677766 677801 678066 678141 678159 678533 679029 679733 679799 680167 695124 702164 708443 708447 731665 745384 ] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"межрасов анал кастинг"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.26%) |
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.