Query Metrics
5
Database Queries
5
Different statements
1073.19 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.88 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
| 2 | 14.21 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 600
Parameters:
[ 1 2 0 10 0 ] |
| 3 | 3.70 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 432762 412989 780704 729835 550334 478254 118359 512094 455319 415594 385386 757078 711899 613167 399318 763914 518919 513837 448356 777244 763399 758785 758676 756568 716591 662653 628058 606711 603193 589592 581203 573308 562000 557978 536084 529419 436047 417075 413708 409241 405472 390857 786637 775880 692453 661496 660068 607993 565167 554506 519268 467081 459802 448646 385582 603277 651603 552346 756956 727431 726744 667246 650539 512136 481343 450656 420431 382724 766481 697169 552023 548565 759377 724329 663391 631166 618272 516979 512556 511418 506283 415635 383211 768851 740790 710222 687532 554780 506348 461923 384291 384133 702456 484111 758395 701275 680588 679863 651646 521439 415488 682351 746222 747295 768709 743322 720534 696065 570970 555263 524423 500043 495892 475069 188266 384258 688071 751021 608497 566786 ] |
| 4 | 228.20 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 432762 412989 780704 729835 550334 478254 118359 512094 455319 415594 385386 757078 711899 613167 399318 763914 518919 513837 448356 777244 763399 758785 758676 756568 716591 662653 628058 606711 603193 589592 581203 573308 562000 557978 536084 529419 436047 417075 413708 409241 405472 390857 786637 775880 692453 661496 660068 607993 565167 554506 519268 467081 459802 448646 385582 603277 651603 552346 756956 727431 726744 667246 650539 512136 481343 450656 420431 382724 766481 697169 552023 548565 759377 724329 663391 631166 618272 516979 512556 511418 506283 415635 383211 768851 740790 710222 687532 554780 506348 461923 384291 384133 702456 484111 758395 701275 680588 679863 651646 521439 415488 682351 746222 747295 768709 743322 720534 696065 570970 555263 524423 500043 495892 475069 188266 384258 688071 751021 608497 566786 ] |
| 5 | 825.21 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.