Query Metrics
7
Database Queries
7
Different statements
149.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.58 ms (82.44%) |
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 14328 14389 28591 29242 31028 31305 33082 33602 34170 44177 56810 57344 59007 71071 72766 81100 86313 97276 102043 111630 117883 135519 145053 146216 153376 156487 156877 170942 181438 186988 191069 191336 191509 205205 213662 214719 222222 229555 239112 239542 289441 308832 311005 327338 361382 382302 382357 382489 382556 382611 382934 383149 383437 383658 384543 384545 384762 384923 385104 385373 385484 385851 386630 386778 387176 387424 387919 388195 389978 390229 390318 390483 390809 393267 393694 395542 395554 395656 396111 396292 396543 396859 397307 399364 399757 401395 401798 404359 408493 412858 416402 416820 421417 429841 451538 454797 465612 472606 477528 499908 532439 539102 539104 540501 546403 560090 579089 581845 591699 591708 603174 603879 604525 710889 723708 790824 812595 827892 828845 ] |
||||||||||||||||||||||||||||||
|
16.41 ms (10.95%) |
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 34170 222222 191069 451538 385373 153376 395656 389978 390809 416402 382357 393694 383437 135519 229555 156877 382611 388195 390229 401798 454797 539104 532439 581845 591708 181438 156487 28591 386630 308832 384545 393267 311005 33602 827892 579089 604525 59007 117883 97276 384762 146216 31028 539102 812595 56810 384923 111630 385104 327338 289441 382556 57344 14389 81100 408493 429841 828845 465612 591699 603174 603879 723708 771522 14328 396543 412858 477528 416820 385851 102043 239542 71071 382934 386778 72766 31305 44177 396292 421417 710889 546403 790824 33082 390318 86313 191509 205205 383149 383658 401395 404359 213662 214719 239112 390483 395554 382489 382302 396111 540501 387176 399364 387424 395542 499908 186988 191336 145053 170942 361382 29242 387919 399757 472606 560090 396859 384543 385484 397307 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.74%) |
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 14328 14389 28591 29242 31028 31305 33082 33602 34170 44177 56810 57344 59007 71071 72766 81100 86313 97276 102043 111630 117883 135519 145053 146216 153376 156487 156877 170942 181438 186988 191069 191336 191509 205205 213662 214719 222222 229555 239112 239542 289441 308832 311005 327338 361382 382302 382357 382489 382556 382611 382934 383149 383437 383658 384543 384545 384762 384923 385104 385373 385484 385851 386630 386778 387176 387424 387919 388195 389978 390229 390318 390483 390809 393267 393694 395542 395554 395656 396111 396292 396543 396859 397307 399364 399757 401395 401798 404359 408493 412858 416402 416820 421417 429841 451538 454797 465612 472606 477528 499908 532439 539102 539104 540501 546403 560090 579089 581845 591699 591708 603174 603879 604525 710889 723708 790824 812595 827892 828845 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big muscle"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие мускулистые"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.11%) |
1 |
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.