Query Metrics
5
Database Queries
5
Different statements
716.76 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.82 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
| 2 | 18.37 ms |
SELECT p.post_id, p.user_id, p.content_id, p.public_key, 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.type = ? AND p.status = ? AND p.sexual_orientation = ? ORDER BY max_ctr DESC LIMIT 120 OFFSET 960
Parameters:
[ 1 2 0 10 0 ] |
| 3 | 2.08 ms |
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 643423 635481 631165 629926 629616 628363 622656 616096 614743 613785 603302 601910 584024 582842 582181 575440 568093 565156 560316 551942 550053 547666 546257 541164 530710 530637 530415 524517 520178 517888 515980 513144 511238 507792 503924 496054 492268 491465 491331 476409 473064 469649 468751 466022 461039 459804 457751 452323 451868 435054 434141 426279 423832 422074 421761 416568 413283 409016 407377 406476 400619 393833 391059 385420 385347 384325 384319 383652 82133 8619 768430 752562 747956 735545 590978 576187 514489 509240 428805 422295 415805 415584 414252 401059 396670 385634 623856 572183 452171 684173 667168 487370 385440 748015 663854 660571 618065 615709 539059 513167 436163 133707 688332 629793 581101 523492 516015 536035 735465 699580 517018 484155 406168 760382 758552 756386 753166 753042 746760 743911 ] |
| 4 | 159.41 ms |
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 643423 635481 631165 629926 629616 628363 622656 616096 614743 613785 603302 601910 584024 582842 582181 575440 568093 565156 560316 551942 550053 547666 546257 541164 530710 530637 530415 524517 520178 517888 515980 513144 511238 507792 503924 496054 492268 491465 491331 476409 473064 469649 468751 466022 461039 459804 457751 452323 451868 435054 434141 426279 423832 422074 421761 416568 413283 409016 407377 406476 400619 393833 391059 385420 385347 384325 384319 383652 82133 8619 768430 752562 747956 735545 590978 576187 514489 509240 428805 422295 415805 415584 414252 401059 396670 385634 623856 572183 452171 684173 667168 487370 385440 748015 663854 660571 618065 615709 539059 513167 436163 133707 688332 629793 581101 523492 516015 536035 735465 699580 517018 484155 406168 760382 758552 756386 753166 753042 746760 743911 ] |
| 5 | 535.07 ms |
SELECT COUNT(*) 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.type = ? AND p.status = ? AND p.sexual_orientation = ?
Parameters:
[ 1 2 0 10 0 ] |
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.