Query Metrics
7
Database Queries
7
Different statements
145.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.30 ms (81.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 96200 405468 413446 414119 417980 425398 432589 444018 446026 446790 447608 460889 469084 476055 476186 477496 477757 479818 486240 486768 487774 499111 499382 505725 508686 508882 509800 520834 524198 526257 530039 530369 530375 530476 530851 531137 531206 531208 531260 531261 532653 533556 534150 535358 536251 536259 536266 536337 536379 536580 537901 537913 537917 537988 538255 540291 545604 549092 550203 554338 555752 569050 575566 577371 585446 586294 599306 599875 601517 601544 601585 606405 606578 626021 631249 633521 634122 639718 639731 639784 640800 642033 644273 644952 647939 648832 648838 648855 650333 651051 662389 664431 674077 676111 685013 685819 688617 689949 695878 699526 704526 704529 707418 713375 720207 723494 738262 739993 741541 766830 769418 777750 784732 785503 788969 791844 793262 815520 815699 816115 ] |
||||||||||||||||||||||||||||||
|
16.47 ms (11.31%) |
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 509800 477757 499111 414119 816115 815520 815699 469084 476186 460889 446790 499382 536379 555752 738262 432589 526257 569050 538255 662389 505725 549092 685013 707418 689949 723494 599306 626021 769418 784732 674077 793262 685819 788969 739993 688617 486240 585446 446026 530039 531208 531260 540291 533556 535358 536337 530476 531261 537913 530851 532653 537988 550203 704526 648838 631249 644273 634122 640800 601517 606578 633521 639731 704529 479818 508686 524198 520834 96200 413446 644952 531137 486768 575566 720207 695878 713375 586294 601544 606405 777750 785503 791844 766830 741541 545604 444018 417980 487774 508882 577371 536251 647939 639784 599875 639718 530369 405468 425398 447608 477496 531206 534150 530375 536259 536580 536266 537901 537917 476055 554338 648832 650333 676111 699526 648855 651051 664431 601585 642033 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (2.16%) |
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 96200 405468 413446 414119 417980 425398 432589 444018 446026 446790 447608 460889 469084 476055 476186 477496 477757 479818 486240 486768 487774 499111 499382 505725 508686 508882 509800 520834 524198 526257 530039 530369 530375 530476 530851 531137 531206 531208 531260 531261 532653 533556 534150 535358 536251 536259 536266 536337 536379 536580 537901 537913 537917 537988 538255 540291 545604 549092 550203 554338 555752 569050 575566 577371 585446 586294 599306 599875 601517 601544 601585 606405 606578 626021 631249 633521 634122 639718 639731 639784 640800 642033 644273 644952 647939 648832 648838 648855 650333 651051 662389 664431 674077 676111 685013 685819 688617 689949 695878 699526 704526 704529 707418 713375 720207 723494 738262 739993 741541 766830 769418 777750 784732 785503 788969 791844 793262 815520 815699 816115 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal dildo penetration"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал дилд penetration"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал дилд penetration"
]
|
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.