Query Metrics
7
Database Queries
7
Different statements
359.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.29 ms (59.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло мастурбац масл"
]
|
||||||||||||||||||||||||||||||
|
123.15 ms (34.21%) |
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 148814 388183 411009 415863 416038 416648 416722 420742 424613 424765 426293 434328 438490 438543 438957 439130 439343 439427 440642 446981 449916 450277 451688 453521 454004 457650 463420 463978 464690 465672 467986 468151 468236 469959 470058 475762 475769 478988 483749 495467 512079 515356 517490 519758 526291 526505 526653 530425 530721 534045 534450 534758 535352 535552 537155 544896 548186 552113 555131 574661 575934 577340 582198 587295 598932 604032 607997 609976 642219 651731 652235 656938 660035 662907 664394 675837 683446 687399 692000 698156 701291 702695 710092 716241 718015 726454 738451 739150 739368 742346 744205 751636 754487 754516 755544 756843 758286 762149 769000 770379 770860 774881 777642 788319 793017 793266 799699 802071 807111 807160 809032 809077 809080 809086 812543 813800 816126 822638 826223 827506 ] |
||||||||||||||||||||||||||||||
|
15.17 ms (4.21%) |
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 512079 716241 465672 468151 483749 534045 575934 548186 710092 656938 687399 587295 607997 609976 793266 807160 809077 809086 774881 809032 809080 793017 799699 726454 738451 739150 769000 770379 742346 754516 770860 744205 756843 758286 762149 642219 701291 702695 788319 807111 812543 148814 683446 439343 415863 454004 453521 457650 467986 582198 438543 439130 475769 526291 495467 552113 438490 463978 449916 450277 464690 468236 478988 535352 463420 577340 555131 755544 451688 434328 388183 526505 526653 416648 420742 424613 424765 469959 470058 517490 515356 598932 416722 802071 439427 416038 426293 698156 751636 754487 777642 446981 739368 438957 411009 440642 822638 827506 813800 816126 826223 475762 519758 530721 534758 530425 534450 537155 535552 574661 651731 660035 662907 652235 664394 675837 692000 718015 544896 604032 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (0.87%) |
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 148814 388183 411009 415863 416038 416648 416722 420742 424613 424765 426293 434328 438490 438543 438957 439130 439343 439427 440642 446981 449916 450277 451688 453521 454004 457650 463420 463978 464690 465672 467986 468151 468236 469959 470058 475762 475769 478988 483749 495467 512079 515356 517490 519758 526291 526505 526653 530425 530721 534045 534450 534758 535352 535552 537155 544896 548186 552113 555131 574661 575934 577340 582198 587295 598932 604032 607997 609976 642219 651731 652235 656938 660035 662907 664394 675837 683446 687399 692000 698156 701291 702695 710092 716241 718015 726454 738451 739150 739368 742346 744205 751636 754487 754516 755544 756843 758286 762149 769000 770379 770860 774881 777642 788319 793017 793266 799699 802071 807111 807160 809032 809077 809080 809086 812543 813800 816126 822638 826223 827506 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo masturbation oil"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.52%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.41%) |
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.