Query Metrics
7
Database Queries
7
Different statements
157.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.02 ms (84.61%) |
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 4350 21711 203516 388127 401886 408751 493445 507861 522571 527214 533332 538891 547265 552171 556864 562278 569853 570042 573787 574631 583652 596293 598894 613945 621995 629072 636190 637735 669761 671120 672105 673456 676529 677118 679060 679081 679132 681147 692172 698548 698915 699708 705557 706339 710578 720430 720768 720870 722435 722774 722888 724460 724709 725350 727339 727425 727436 727854 729091 730354 730517 732699 732725 733230 735002 735346 736295 736636 739718 740967 741953 742466 742709 743089 744556 745381 746146 746723 747354 747458 747918 748434 750769 753847 754214 754877 755156 755416 756171 758439 759580 759841 768426 772034 773779 775571 783790 784996 786039 787912 789048 795513 796271 799650 800877 801746 802448 802697 803263 803963 804170 805974 815167 816802 817022 817165 818267 818421 818595 818946 ] |
||||||||||||||||||||||||||||||
|
13.11 ms (8.34%) |
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 727339 727854 730354 735346 736636 742466 746146 747918 748434 758439 768426 730517 732725 744556 746723 750769 724460 735002 741953 747354 773779 621995 629072 698915 699708 804170 4350 408751 203516 21711 388127 401886 816802 818267 818595 817022 817165 818946 815167 818421 493445 507861 522571 527214 538891 533332 547265 562278 574631 569853 573787 552171 570042 673456 677118 679081 720768 722435 671120 676529 679060 679132 681147 692172 698548 710578 722888 669761 672105 705557 706339 720430 720870 722774 556864 583652 636190 596293 637735 598894 613945 775571 783790 786039 795513 799650 800877 801746 802448 802697 803263 784996 787912 796271 805974 724709 725350 729091 733230 736295 742709 743089 745381 753847 754214 755156 756171 759580 772034 789048 803963 727425 732699 739718 740967 747458 754877 755416 759841 727436 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (1.97%) |
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 4350 21711 203516 388127 401886 408751 493445 507861 522571 527214 533332 538891 547265 552171 556864 562278 569853 570042 573787 574631 583652 596293 598894 613945 621995 629072 636190 637735 669761 671120 672105 673456 676529 677118 679060 679081 679132 681147 692172 698548 698915 699708 705557 706339 710578 720430 720768 720870 722435 722774 722888 724460 724709 725350 727339 727425 727436 727854 729091 730354 730517 732699 732725 733230 735002 735346 736295 736636 739718 740967 741953 742466 742709 743089 744556 745381 746146 746723 747354 747458 747918 748434 750769 753847 754214 754877 755156 755416 756171 758439 759580 759841 768426 772034 773779 775571 783790 784996 786039 787912 789048 795513 796271 799650 800877 801746 802448 802697 803263 803963 804170 805974 815167 816802 817022 817165 818267 818421 818595 818946 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.54%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"kissing pussy"
]
|
||||||||||||||||||||||||||||||
|
2.30 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"kissing pussy"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"kissing pussy"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.