Query Metrics
7
Database Queries
7
Different statements
146.99 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.06 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.74 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"молоко молоко"
]
|
||||||||||||||||||||||||||||||
| 3 | 12.51 ms |
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 584434 547575 566020 573200 665990 554033 580425 591861 603832 630850 591760 618746 624456 628692 586302 644054 776126 798873 792185 809502 770519 760694 773457 629212 644422 707071 710566 402507 445029 526534 669722 482888 495015 511319 494514 526900 533576 486005 545965 541188 661942 551121 559440 565695 629213 633512 588261 624537 597720 806157 784112 784528 789694 798610 736564 634867 419022 520808 373950 547496 693965 616382 617032 794963 432822 452562 455631 504787 484928 535888 686748 667817 611556 624480 603053 614580 643370 767275 509986 544788 607027 623306 670951 667748 518473 639334 639060 528361 605492 ] |
||||||||||||||||||||||||||||||
| 4 | 3.80 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 373950 402507 419022 432822 445029 452562 455631 482888 484928 486005 494514 495015 504787 509986 511319 518473 520808 526534 526900 528361 533576 535888 541188 544788 545965 547496 547575 551121 554033 559440 565695 566020 573200 580425 584434 586302 588261 591760 591861 597720 603053 603832 605492 607027 611556 614580 616382 617032 618746 623306 624456 624480 624537 628692 629212 629213 630850 633512 634867 639060 639334 643370 644054 644422 661942 665990 667748 667817 669722 670951 686748 693965 707071 710566 736564 760694 767275 770519 773457 776126 784112 784528 789694 792185 794963 798610 798873 806157 809502 ] |
||||||||||||||||||||||||||||||
| 5 | 124.05 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 373950 402507 419022 432822 445029 452562 455631 482888 484928 486005 494514 495015 504787 509986 511319 518473 520808 526534 526900 528361 533576 535888 541188 544788 545965 547496 547575 551121 554033 559440 565695 566020 573200 580425 584434 586302 588261 591760 591861 597720 603053 603832 605492 607027 611556 614580 616382 617032 618746 623306 624456 624480 624537 628692 629212 629213 630850 633512 634867 639060 639334 643370 644054 644422 661942 665990 667748 667817 669722 670951 686748 693965 707071 710566 736564 760694 767275 770519 773457 776126 784112 784528 789694 792185 794963 798610 798873 806157 809502 ] |
||||||||||||||||||||||||||||||
| 6 | 1.48 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"молок молок"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.35 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.