Query Metrics
7
Database Queries
7
Different statements
264.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
235.63 ms (89.01%) |
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 382542 386728 388591 389848 400621 415691 416153 418166 420495 422299 424671 443706 447138 448752 450707 458720 459474 460346 479189 481656 484611 485298 489654 501701 502201 504352 504553 507405 513507 514250 514321 517452 522732 528741 529294 535825 541265 547962 550438 551896 552863 553225 563421 567190 574798 576332 583737 584379 591636 595820 596230 602416 607906 612458 614088 619718 620089 631451 633216 634363 634858 640304 641071 660150 661462 666709 679391 680576 693635 699401 701626 711700 712703 719228 720305 723917 728905 729177 729204 734706 737804 741699 744891 750072 751386 753546 753605 753728 755608 756047 765860 770662 775564 780323 780410 782770 785835 790275 791478 793721 794107 794413 796090 800126 802368 804265 804449 805239 817437 817707 817803 819520 823891 824174 825059 825992 826099 827025 828449 828803 ] |
||||||||||||||||||||||||||||||
|
17.64 ms (6.66%) |
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 448752 484611 502201 828449 728905 756047 825992 826099 389848 415691 418166 819520 481656 535825 552863 563421 567190 576332 541265 551896 553225 680576 693635 701626 660150 720305 574798 614088 620089 641071 780410 804449 723917 750072 770662 602416 804265 443706 458720 386728 400621 420495 513507 485298 489654 817707 719228 775564 785835 734706 744891 780323 791478 823891 712703 794107 550438 679391 596230 794413 729204 737804 729177 631451 802368 382542 824174 450707 460346 479189 517452 514250 547962 583737 584379 661462 666709 711700 595820 634858 612458 619718 796090 765860 741699 633216 388591 447138 459474 422299 504553 529294 507405 514321 522732 501701 504352 827025 591636 699401 790275 640304 607906 793721 805239 755608 800126 753546 753728 817803 825059 828803 782770 528741 817437 634363 753605 751386 416153 424671 ] |
||||||||||||||||||||||||||||||
|
3.41 ms (1.29%) |
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 382542 386728 388591 389848 400621 415691 416153 418166 420495 422299 424671 443706 447138 448752 450707 458720 459474 460346 479189 481656 484611 485298 489654 501701 502201 504352 504553 507405 513507 514250 514321 517452 522732 528741 529294 535825 541265 547962 550438 551896 552863 553225 563421 567190 574798 576332 583737 584379 591636 595820 596230 602416 607906 612458 614088 619718 620089 631451 633216 634363 634858 640304 641071 660150 661462 666709 679391 680576 693635 699401 701626 711700 712703 719228 720305 723917 728905 729177 729204 734706 737804 741699 744891 750072 751386 753546 753605 753728 755608 756047 765860 770662 775564 780323 780410 782770 785835 790275 791478 793721 794107 794413 796090 800126 802368 804265 804449 805239 817437 817707 817803 819520 823891 824174 825059 825992 826099 827025 828449 828803 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"shower pussy"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.71%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"shower pussy"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.70%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"shower pussy"
]
|
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.