Query Metrics
7
Database Queries
7
Different statements
157.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.14 ms (82.62%) |
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 13075 386468 390776 391704 415957 416512 416529 416680 418577 420358 420816 421678 437874 439960 439993 440698 440710 444052 444533 444795 445409 446785 450023 451044 452640 452843 453409 453820 462840 475261 477757 477762 478055 482731 482768 493411 498226 498963 500340 500341 500910 508909 514240 514652 524687 528315 528502 531139 532942 536631 541836 541992 545404 545428 547241 547490 547576 556885 569050 572022 576503 579452 581013 584301 586407 589064 589836 592206 594606 596796 599001 604667 604824 614975 616315 618514 623205 623262 637537 641837 643542 648414 662389 664192 665662 674077 674177 680928 683183 713375 719480 720077 720139 728229 747313 747328 749087 750308 752653 756840 758079 765628 765896 770250 770269 785591 787506 787515 793187 796221 803040 803603 806583 807206 808972 813275 813899 814037 814467 814523 ] |
||||||||||||||||||||||||||||||
|
18.10 ms (11.49%) |
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 415957 444533 439993 500340 500341 576503 662389 439960 541836 614975 493411 390776 719480 418577 592206 451044 420816 444052 498963 569050 584301 813899 453820 475261 713375 596796 747313 806583 637537 477757 648414 750308 787506 589064 416512 416529 545404 462840 440698 594606 498226 514240 440710 500910 528315 683183 813275 770269 452843 446785 616315 749087 416680 674077 803603 545428 477762 556885 508909 547576 589836 482768 581013 814523 814467 814037 482731 579452 674177 641837 803040 808972 793187 787515 765896 720077 720139 796221 391704 445409 478055 532942 452640 604667 524687 599001 623262 528502 421678 807206 437874 680928 664192 665662 604824 618514 747328 765628 785591 770250 728229 752653 758079 450023 547490 623205 444795 514652 531139 536631 13075 386468 643542 586407 547241 756840 541992 453409 420358 572022 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.64%) |
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 13075 386468 390776 391704 415957 416512 416529 416680 418577 420358 420816 421678 437874 439960 439993 440698 440710 444052 444533 444795 445409 446785 450023 451044 452640 452843 453409 453820 462840 475261 477757 477762 478055 482731 482768 493411 498226 498963 500340 500341 500910 508909 514240 514652 524687 528315 528502 531139 532942 536631 541836 541992 545404 545428 547241 547490 547576 556885 569050 572022 576503 579452 581013 584301 586407 589064 589836 592206 594606 596796 599001 604667 604824 614975 616315 618514 623205 623262 637537 641837 643542 648414 662389 664192 665662 674077 674177 680928 683183 713375 719480 720077 720139 728229 747313 747328 749087 750308 752653 756840 758079 765628 765896 770250 770269 785591 787506 787515 793187 796221 803040 803603 806583 807206 808972 813275 813899 814037 814467 814523 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ridding dildo anal"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"наездниц поз дилд анал"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"наездниц поз дилд анал"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.95%) |
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.