Query Metrics
7
Database Queries
7
Different statements
185.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.28 ms (85.44%) |
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 381963 383065 383353 384455 385342 388115 395548 397019 403381 407429 408730 408978 411722 411761 412380 415488 416871 420299 420304 420306 423646 428456 429479 434040 435748 441876 443177 445560 452968 452991 454408 455981 458370 460019 460195 464315 469486 474811 475084 488378 490660 490664 493061 493156 496840 504009 504584 514607 514730 516642 521184 521745 523366 527171 533289 539326 542707 544502 552935 555166 559789 559868 563114 565931 566070 569306 577100 579347 581390 581972 590426 593310 600847 600905 600987 610972 618538 623569 628559 630215 634760 647882 660311 673963 681182 681307 710471 714380 714466 715762 718422 724641 733025 734708 737136 737162 756841 756874 767284 771816 774514 781786 785674 792642 796543 800344 800463 800553 808226 812052 815341 815778 819439 820122 820340 821691 822242 824826 ] |
||||||||||||||||||||||||||||||
|
16.94 ms (9.15%) |
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 734708 634760 381963 420306 443177 455981 445560 464315 411722 493156 385342 397019 408978 415488 822242 821691 820340 469486 490664 516642 539326 527171 559868 566070 563114 681307 559789 569306 600847 600905 610972 628559 593310 774514 800553 785674 792642 812052 756841 800463 733025 737162 737136 771816 724641 796543 423646 420299 514730 819439 544502 542707 581972 714380 565931 824826 408730 412380 821926 820122 827902 458370 475084 490660 496840 521745 504009 660311 718422 681182 715762 630215 590426 618538 800344 756874 781786 808226 767284 623569 710471 714466 420304 383353 460019 383065 411761 429479 452968 523366 577100 488378 533289 600987 384455 395548 388115 403381 416871 441876 428456 434040 407429 435748 815341 815778 474811 452991 454408 493061 504584 514607 521184 460195 552935 579347 555166 581390 673963 647882 ] |
||||||||||||||||||||||||||||||
|
3.23 ms (1.75%) |
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 381963 383065 383353 384455 385342 388115 395548 397019 403381 407429 408730 408978 411722 411761 412380 415488 416871 420299 420304 420306 423646 428456 429479 434040 435748 441876 443177 445560 452968 452991 454408 455981 458370 460019 460195 464315 469486 474811 475084 488378 490660 490664 493061 493156 496840 504009 504584 514607 514730 516642 521184 521745 523366 527171 533289 539326 542707 544502 552935 555166 559789 559868 563114 565931 566070 569306 577100 579347 581390 581972 590426 593310 600847 600905 600987 610972 618538 623569 628559 630215 634760 647882 660311 673963 681182 681307 710471 714380 714466 715762 718422 724641 733025 734708 737136 737162 756841 756874 767284 771816 774514 781786 785674 792642 796543 800344 800463 800553 808226 812052 815341 815778 819439 820122 820340 821691 822242 824826 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"horny волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"horny hairy"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"horny волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.83%) |
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.