Query Metrics
7
Database Queries
7
Different statements
146.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.69 ms (83.63%) |
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 79574 385591 389944 390925 394566 397918 403006 403357 403770 404353 406931 416384 417564 417693 420156 424092 426837 447521 448092 453882 455625 456561 459618 460430 461329 466620 466728 468963 469399 471133 474579 475391 483274 485611 486751 494671 505785 512289 512599 545014 549716 557051 563667 564361 566290 567138 573794 574930 588145 591965 600146 602036 613240 621718 625896 626528 627570 627710 631851 632981 648672 651186 679093 692209 692583 695785 696371 699488 700105 700303 700540 702302 703448 708194 710751 710833 712698 719040 721156 725584 726221 729100 729562 731107 733116 734483 736120 741301 742053 749714 749871 755634 756811 757506 757866 758680 766171 770211 770233 785035 787579 789009 793081 793223 793744 797574 798161 799528 800784 801889 803974 804718 805392 806892 808050 811406 813833 814116 ] |
||||||||||||||||||||||||||||||
|
13.86 ms (9.45%) |
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 390925 813833 567138 692583 621718 627570 789009 772133 726221 734483 741301 736120 749714 756811 700303 787579 801889 394566 710833 805392 757506 475391 447521 512289 448092 485611 466728 466620 549716 563667 712698 651186 699488 626528 600146 729562 755634 758680 799528 757866 770233 733116 749871 613240 700105 721156 416384 459618 627710 588145 420156 426837 79574 397918 403357 403770 573794 700540 455625 417564 692209 632981 725584 469399 456561 471133 494671 564361 695785 460430 385591 461329 417693 468963 483274 505785 512599 403006 797574 404353 574930 406931 424092 389944 804718 811406 742053 474579 453882 486751 814116 824550 557051 566290 648672 702302 708194 719040 679093 710751 696371 703448 545014 591965 631851 602036 625896 793223 808050 793081 800784 806892 729100 731107 785035 793744 798161 803974 766171 770211 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.88%) |
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 79574 385591 389944 390925 394566 397918 403006 403357 403770 404353 406931 416384 417564 417693 420156 424092 426837 447521 448092 453882 455625 456561 459618 460430 461329 466620 466728 468963 469399 471133 474579 475391 483274 485611 486751 494671 505785 512289 512599 545014 549716 557051 563667 564361 566290 567138 573794 574930 588145 591965 600146 602036 613240 621718 625896 626528 627570 627710 631851 632981 648672 651186 679093 692209 692583 695785 696371 699488 700105 700303 700540 702302 703448 708194 710751 710833 712698 719040 721156 725584 726221 729100 729562 731107 733116 734483 736120 741301 742053 749714 749871 755634 756811 757506 757866 758680 766171 770211 770233 785035 787579 789009 793081 793223 793744 797574 798161 799528 800784 801889 803974 804718 805392 806892 808050 811406 813833 814116 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob best"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс best"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс best"
]
|
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.