Query Metrics
7
Database Queries
7
Different statements
629.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.72 ms (32.84%) |
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 98951 146508 191407 249637 365924 384582 385427 385946 391477 392602 395564 395699 396258 396758 397456 399631 400137 400478 402137 404582 405485 407424 407786 409184 411738 411864 413783 415734 418928 422806 428869 428890 430411 442407 443669 445060 454058 454897 459896 461035 461367 466217 466930 467502 469345 469475 474151 480780 481933 482505 483364 486958 489851 490188 490910 490931 493099 493117 503046 511181 513523 517953 523191 549646 550643 550644 554897 558523 563444 565147 567423 576262 593527 599543 608049 618404 621971 622826 631970 649940 665139 665311 665465 666844 666849 667536 667644 669768 673056 675524 683066 694715 707368 711671 712668 714743 714748 715234 718556 720603 724226 724481 726543 726553 745394 747258 770992 789998 800864 801350 804109 804619 807379 813750 813916 814940 815263 815598 824466 824791 ] |
||||||||||||||||||||||||||||||
|
205.21 ms (32.60%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
196.43 ms (31.20%) |
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 98951 146508 191407 249637 365924 384582 385427 385946 391477 392602 395564 395699 396258 396758 397456 399631 400137 400478 402137 404582 405485 407424 407786 409184 411738 411864 413783 415734 418928 422806 428869 428890 430411 442407 443669 445060 454058 454897 459896 461035 461367 466217 466930 467502 469345 469475 474151 480780 481933 482505 483364 486958 489851 490188 490910 490931 493099 493117 503046 511181 513523 517953 523191 549646 550643 550644 554897 558523 563444 565147 567423 576262 593527 599543 608049 618404 621971 622826 631970 649940 665139 665311 665465 666844 666849 667536 667644 669768 673056 675524 683066 694715 707368 711671 712668 714743 714748 715234 718556 720603 724226 724481 726543 726553 745394 747258 770992 789998 800864 801350 804109 804619 807379 813750 813916 814940 815263 815598 824466 824791 ] |
||||||||||||||||||||||||||||||
|
15.69 ms (2.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 407424 415734 411738 430411 413783 442407 445060 824791 815598 482505 459896 474151 490931 489851 493117 667644 707368 714748 714743 715234 565147 593527 599543 724481 804619 391477 428869 428890 409184 249637 467502 481933 98951 396758 400137 517953 486958 490910 493099 513523 483364 418928 576262 665139 385427 813750 824466 815263 461367 550644 666844 649940 683066 618404 801350 807379 711671 720603 146508 384582 365924 422806 511181 726543 726553 466217 385946 395699 396258 397456 399631 402137 407786 813916 480780 454897 554897 550643 669768 675524 712668 665465 666849 694715 718556 665311 667536 673056 567423 622826 621971 631970 789998 800864 804109 745394 747258 770992 724226 608049 400478 191407 392602 443669 395564 405485 404582 411864 814940 466930 490188 461035 469345 454058 469475 503046 523191 563444 549646 558523 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot young mature"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (0.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot young mature"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hot young mature"
]
|
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.