Query Metrics
7
Database Queries
7
Different statements
185.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.15 ms (85.57%) |
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 24224 73990 233147 385086 386913 391483 391594 392599 395134 395533 402972 403649 427614 460577 465386 468843 475589 486539 517328 524682 526995 529518 531979 531995 532265 532587 533434 533629 535490 539614 543909 544342 560459 562992 566016 572630 577048 581143 600241 602591 609834 610057 610563 611345 613052 616103 619654 631214 635081 636568 637207 637411 637687 663419 669634 686009 697308 697913 710389 710833 710917 713169 714655 716192 721039 721910 728038 734204 737180 739562 741893 742232 745517 751560 751661 756225 756725 758804 760137 774393 775064 775381 775516 776174 779069 779599 782989 784955 786665 789740 791710 794019 794612 795136 799802 804991 807523 808221 808453 808633 810285 810347 811053 811182 814359 814851 815263 815365 815386 815605 815823 815840 816050 816392 818451 818854 821902 823043 823278 823358 ] |
||||||||||||||||||||||||||||||
|
15.25 ms (8.20%) |
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 816392 543909 779599 814851 818854 823278 581143 544342 610057 775381 739562 737180 609834 721039 811182 815823 821902 535490 562992 714655 710833 635081 775064 784955 734204 756725 774393 710917 786665 392599 391483 611345 385086 395533 533434 663419 600241 794019 779069 808633 782989 742232 751661 791710 402972 465386 24224 529518 721910 758804 233147 427614 468843 486539 760137 775516 823358 815840 517328 533629 531979 532265 539614 532587 566016 697308 697913 713169 572630 577048 619654 637207 637411 636568 602591 807523 808453 751560 710389 808221 403649 818451 669634 686009 613052 776174 815365 815386 816050 531995 560459 794612 745517 728038 73990 395134 391594 814359 526995 460577 610563 631214 637687 799802 804991 810285 789740 795136 810347 741893 756225 616103 716192 811053 475589 524682 386913 815605 823043 815263 ] |
||||||||||||||||||||||||||||||
|
4.01 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 24224 73990 233147 385086 386913 391483 391594 392599 395134 395533 402972 403649 427614 460577 465386 468843 475589 486539 517328 524682 526995 529518 531979 531995 532265 532587 533434 533629 535490 539614 543909 544342 560459 562992 566016 572630 577048 581143 600241 602591 609834 610057 610563 611345 613052 616103 619654 631214 635081 636568 637207 637411 637687 663419 669634 686009 697308 697913 710389 710833 710917 713169 714655 716192 721039 721910 728038 734204 737180 739562 741893 742232 745517 751560 751661 756225 756725 758804 760137 774393 775064 775381 775516 776174 779069 779599 782989 784955 786665 789740 791710 794019 794612 795136 799802 804991 807523 808221 808453 808633 810285 810347 811053 811182 814359 814851 815263 815365 815386 815605 815823 815840 816050 816392 818451 818854 821902 823043 823278 823358 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck mom shower"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс mom shower"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс mom shower"
]
|
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.