Query Metrics
7
Database Queries
7
Different statements
162.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.68 ms (84.32%) |
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 7981 183979 191048 260940 280073 334950 358942 391253 395516 395721 395738 397053 400178 400209 401223 402592 402997 403562 404462 404615 405208 407028 407052 407414 407552 407554 407557 409682 409894 410124 411237 412289 412424 413870 427243 427935 429307 430837 433241 442946 443802 446633 447785 451826 454191 457396 460135 466943 466996 468774 469338 471183 474826 475220 477080 483141 484157 484649 484670 485037 486157 486529 492108 495652 502222 502512 511422 511568 511925 518948 519184 523803 531512 533182 554513 557125 565534 582407 585689 590861 591294 592310 598852 601063 603736 605415 632010 653794 663444 663495 665208 666113 667646 677974 687511 687980 699023 699804 710318 712973 713065 714973 719343 724271 724291 728288 732040 745433 751457 770844 789702 790022 792621 807141 811930 813913 814817 815417 815600 820973 ] |
||||||||||||||||||||||||||||||
|
16.21 ms (10.00%) |
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 400209 454191 601063 603736 411237 815600 451826 466943 466996 511568 519184 531512 557125 677974 719343 590861 407414 395738 395721 598852 724271 469338 486157 474826 477080 511925 582407 667646 663495 554513 728288 409682 484670 485037 483141 492108 433241 395516 442946 484649 495652 502512 591294 446633 412289 409894 334950 663444 404615 484157 405208 407554 413870 712973 724291 404462 502222 391253 397053 402592 407557 427243 460135 565534 402997 407552 401223 427935 407028 511422 400178 410124 820973 447785 665208 699023 699804 585689 605415 770844 789702 745433 751457 358942 429307 430837 632010 518948 486529 471183 183979 403562 407052 412424 814817 815417 457396 468774 475220 653794 687511 713065 592310 792621 811930 790022 807141 732040 710318 714973 280073 260940 443802 7981 191048 813913 523803 533182 666113 687980 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.56%) |
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 7981 183979 191048 260940 280073 334950 358942 391253 395516 395721 395738 397053 400178 400209 401223 402592 402997 403562 404462 404615 405208 407028 407052 407414 407552 407554 407557 409682 409894 410124 411237 412289 412424 413870 427243 427935 429307 430837 433241 442946 443802 446633 447785 451826 454191 457396 460135 466943 466996 468774 469338 471183 474826 475220 477080 483141 484157 484649 484670 485037 486157 486529 492108 495652 502222 502512 511422 511568 511925 518948 519184 523803 531512 533182 554513 557125 565534 582407 585689 590861 591294 592310 598852 601063 603736 605415 632010 653794 663444 663495 665208 666113 667646 677974 687511 687980 699023 699804 710318 712973 713065 714973 719343 724271 724291 728288 732040 745433 751457 770844 789702 790022 792621 807141 811930 813913 814817 815417 815600 820973 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old mature ffm"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old mature жмж секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old 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.