Query Metrics
7
Database Queries
7
Different statements
142.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.52 ms (83.25%) |
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 146800 148814 401813 411009 414240 416025 420835 420866 421856 426043 426486 431385 434307 440642 444086 446860 448328 458109 468678 473437 475762 507171 511857 512495 513172 520138 524512 586375 586891 587295 588525 588852 589229 590061 598284 599709 600613 607997 609976 610249 622318 622658 623509 630478 640948 642219 643423 656938 679563 687399 689323 701291 702695 713240 716140 724929 726454 727685 738451 739150 741256 741526 742346 744205 744697 746187 747376 751281 752750 754516 755343 756843 758286 758812 762149 769000 770062 770379 770438 770860 773182 774881 778331 780380 785707 786390 788215 788319 793017 793266 798674 799699 801892 802367 803110 806919 807111 807160 809032 809077 809080 809086 812543 812920 813188 813800 815174 815949 815965 816126 817146 817334 817782 822638 824438 824724 826102 826223 827506 ] |
||||||||||||||||||||||||||||||
|
14.83 ms (10.42%) |
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 656938 679563 687399 689323 630478 586891 598284 610249 586375 587295 600613 590061 607997 609976 622318 643423 778331 793266 798674 807160 809077 809086 774881 780380 785707 786390 809032 809080 724929 727685 747376 793017 799699 801892 802367 812920 726454 738451 739150 741256 746187 769000 770379 742346 754516 770860 744205 751281 756843 758286 758812 762149 770438 773182 622658 623509 642219 701291 702695 776045 788215 788319 807111 812543 813188 146800 148814 431385 416025 426043 421856 434307 468678 511857 512495 520138 524512 414240 426486 458109 513172 713240 716140 588852 599709 589229 770062 755343 741526 444086 448328 507171 806919 803110 744697 752750 640948 588525 401813 420866 411009 420835 440642 815174 817334 824438 826102 817782 822638 824724 827506 813800 815949 815965 816126 817146 826223 475762 446860 473437 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.58%) |
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 146800 148814 401813 411009 414240 416025 420835 420866 421856 426043 426486 431385 434307 440642 444086 446860 448328 458109 468678 473437 475762 507171 511857 512495 513172 520138 524512 586375 586891 587295 588525 588852 589229 590061 598284 599709 600613 607997 609976 610249 622318 622658 623509 630478 640948 642219 643423 656938 679563 687399 689323 701291 702695 713240 716140 724929 726454 727685 738451 739150 741256 741526 742346 744205 744697 746187 747376 751281 752750 754516 755343 756843 758286 758812 762149 769000 770062 770379 770438 770860 773182 774881 778331 780380 785707 786390 788215 788319 793017 793266 798674 799699 801892 802367 803110 806919 807111 807160 809032 809077 809080 809086 812543 812920 813188 813800 815174 815949 815965 816126 817146 817334 817782 822638 824438 824724 826102 826223 827506 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation oil"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац масл"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.97%) |
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.