Query Metrics
7
Database Queries
7
Different statements
148.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.69 ms (83.24%) |
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 401005 403770 405112 405485 405501 408213 410210 413518 413711 414114 416234 418669 418817 419423 423786 425577 427737 431893 434946 435503 435724 437222 440943 441702 443287 448126 450829 451661 453390 453533 455947 455967 456538 457349 458525 458975 461159 463152 463688 467939 471166 471830 471895 475118 475390 479752 486133 493443 500331 501451 505827 506356 510814 514353 519878 520150 520647 525546 528775 528785 529474 531197 532721 535537 538309 547142 554955 558545 562142 564850 565077 566097 566955 567908 572203 579271 579764 581083 581306 583191 585229 585729 587300 592377 595023 596063 597917 604151 604667 604909 607576 609370 617441 619730 624883 633503 634312 638380 645096 646779 661054 667901 684660 699916 707368 710767 730994 742848 758803 766616 786398 789526 800055 804554 807595 810826 813532 814981 815347 817597 ] |
||||||||||||||||||||||||||||||
|
15.60 ms (10.50%) |
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 471830 529474 604667 403770 413518 431893 435503 443287 814981 815347 453533 455967 456538 493443 538309 514353 572203 579271 667901 547142 595023 597917 604909 604151 587300 609370 617441 807595 789526 800055 804554 730994 742848 607576 633503 699916 786398 427737 435724 453390 416234 455947 418817 419423 440943 451661 448126 506356 566955 401005 405501 434946 441702 410210 817597 471166 531197 532721 581306 567908 554955 558545 661054 684660 707368 646779 645096 566097 585729 810826 758803 624883 408213 463688 475118 418669 425577 437222 458525 501451 520150 528785 486133 519878 405485 461159 450829 458975 471895 475390 500331 479752 581083 583191 579764 565077 710767 564850 585229 592377 596063 619730 634312 813532 766616 638380 423786 405112 414114 457349 463152 413711 520647 510814 528775 467939 525546 535537 505827 562142 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (1.96%) |
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 401005 403770 405112 405485 405501 408213 410210 413518 413711 414114 416234 418669 418817 419423 423786 425577 427737 431893 434946 435503 435724 437222 440943 441702 443287 448126 450829 451661 453390 453533 455947 455967 456538 457349 458525 458975 461159 463152 463688 467939 471166 471830 471895 475118 475390 479752 486133 493443 500331 501451 505827 506356 510814 514353 519878 520150 520647 525546 528775 528785 529474 531197 532721 535537 538309 547142 554955 558545 562142 564850 565077 566097 566955 567908 572203 579271 579764 581083 581306 583191 585229 585729 587300 592377 595023 596063 597917 604151 604667 604909 607576 609370 617441 619730 624883 633503 634312 638380 645096 646779 661054 667901 684660 699916 707368 710767 730994 742848 758803 766616 786398 789526 800055 804554 807595 810826 813532 814981 815347 817597 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"boobs ride"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boobs ride"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"boobs ride"
]
|
||||||||||||||||||||||||||||||
|
1.30 ms (0.87%) |
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.