Query Metrics
7
Database Queries
7
Different statements
623.34 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.93 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.12 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mommy xxx sex"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.53 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 484739 753990 474700 484700 525743 688071 467619 448084 478596 474627 474681 484670 462322 470459 428837 456607 474685 474695 513977 521356 525179 495252 421995 445932 631616 474694 457420 470287 528355 502197 477727 522771 589709 460742 451513 465963 490901 460609 470286 509320 556577 412289 404678 469039 412261 412297 606782 456614 481463 546766 453721 484722 463158 563198 407571 466208 474696 484629 521807 466215 468076 514457 518559 445799 589708 640136 682522 474693 456618 474686 466239 484644 484681 482507 554905 474654 428126 561515 474663 472161 557021 571016 525154 597134 620754 490204 526439 495199 ] |
||||||||||||||||||||||||||||||
| 4 | 2.18 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 404678 407571 412261 412289 412297 421995 428126 428837 445799 445932 448084 451513 453721 456607 456614 456618 457420 460609 460742 462322 463158 465963 466208 466215 466239 467619 468076 469039 470286 470287 470459 472161 474627 474654 474663 474681 474685 474686 474693 474694 474695 474696 474700 477727 478596 481463 482507 484629 484644 484670 484681 484700 484722 484739 490204 490901 495199 495252 502197 509320 513977 514457 518559 521356 521807 522771 525154 525179 525743 526439 528355 546766 554905 556577 557021 561515 563198 571016 589708 589709 597134 606782 620754 631616 640136 682522 688071 753990 ] |
||||||||||||||||||||||||||||||
| 5 | 393.97 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 404678 407571 412261 412289 412297 421995 428126 428837 445799 445932 448084 451513 453721 456607 456614 456618 457420 460609 460742 462322 463158 465963 466208 466215 466239 467619 468076 469039 470286 470287 470459 472161 474627 474654 474663 474681 474685 474686 474693 474694 474695 474696 474700 477727 478596 481463 482507 484629 484644 484670 484681 484700 484722 484739 490204 490901 495199 495252 502197 509320 513977 514457 518559 521356 521807 522771 525154 525179 525743 526439 528355 546766 554905 556577 557021 561515 563198 571016 589708 589709 597134 606782 620754 631616 640136 682522 688071 753990 ] |
||||||||||||||||||||||||||||||
| 6 | 1.76 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mommy xxx секс"
]
|
||||||||||||||||||||||||||||||
| 7 | 206.85 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mommy xxx секс"
]
|
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.