Query Metrics
7
Database Queries
7
Different statements
141.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.49 ms (83.52%) |
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 420376 454500 460002 470102 491035 492035 495368 499418 503018 506713 511903 513766 515787 518087 518321 519375 530187 534589 542752 545229 555437 556993 562387 569825 576144 578571 579177 579434 580857 583408 583497 584070 585950 588083 588365 591064 593590 595340 600955 601460 602487 603000 603668 613227 618203 618384 618809 619336 627815 638117 639010 646693 653891 657529 659346 666499 672321 672322 687056 694809 694894 695891 699551 700828 701254 708592 709430 709655 717975 718405 720176 724488 727965 729264 730398 730986 731014 731194 732591 737152 737159 737481 740101 740154 742959 742987 744393 744818 747044 747219 748753 753442 759704 764954 765384 768085 772434 772441 773659 774966 777279 777694 781301 788893 789768 798327 798606 798617 799473 804528 806072 806838 809916 810052 810556 812542 813316 814404 814728 ] |
||||||||||||||||||||||||||||||
|
13.48 ms (9.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 687056 695891 672322 588083 618809 593590 600955 601460 603668 777694 789768 747219 804528 727965 730398 731014 742987 744393 764954 737481 748753 753442 772434 619336 638117 798327 503018 534589 666499 700828 718405 646693 659346 709430 717975 556993 562387 591064 613227 618203 627815 639010 813316 777279 809916 799473 732591 744818 759704 768085 742959 747044 765384 772441 724488 699551 774966 810556 506713 491035 420376 814728 814404 460002 511903 515787 513766 519375 492035 569825 579434 583497 542752 555437 579177 584070 545229 576144 580857 583408 672321 694809 701254 653891 708592 657529 659047 694894 709655 578571 588365 618384 595340 585950 603000 806072 812542 788893 798606 798617 729264 740154 773659 781301 730986 737152 737159 731194 740101 602487 720176 806838 810052 454500 470102 518321 499418 518087 495368 530187 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.83%) |
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 420376 454500 460002 470102 491035 492035 495368 499418 503018 506713 511903 513766 515787 518087 518321 519375 530187 534589 542752 545229 555437 556993 562387 569825 576144 578571 579177 579434 580857 583408 583497 584070 585950 588083 588365 591064 593590 595340 600955 601460 602487 603000 603668 613227 618203 618384 618809 619336 627815 638117 639010 646693 653891 657529 659346 666499 672321 672322 687056 694809 694894 695891 699551 700828 701254 708592 709430 709655 717975 718405 720176 724488 727965 729264 730398 730986 731014 731194 732591 737152 737159 737481 740101 740154 742959 742987 744393 744818 747044 747219 748753 753442 759704 764954 765384 768085 772434 772441 773659 774966 777279 777694 781301 788893 789768 798327 798606 798617 799473 804528 806072 806838 809916 810052 810556 812542 813316 814404 814728 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"сосе"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сос"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сос"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.18%) |
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.