Query Metrics
7
Database Queries
7
Different statements
160.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.56 ms (84.72%) |
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 30208 181693 389883 389964 391771 400507 402599 411198 411310 411904 413958 415802 416116 417070 418046 418268 418425 418655 418689 418862 418975 419324 423652 425279 426029 426637 429242 429537 435618 435643 437724 437836 438506 440292 441583 441609 441770 441822 442135 443924 445105 446520 447224 449194 449411 449514 450141 453912 456252 456505 458109 461814 461831 463779 464587 464911 466391 466852 471050 471712 472262 472311 472392 473282 473620 477515 477779 479240 479597 481101 481985 482001 482892 483855 485283 486910 487389 488381 488984 489853 490134 490664 490750 493657 493808 493981 495304 497918 499172 501031 501362 501407 502854 504020 505290 510377 515586 516159 530418 534893 537480 545761 545874 555564 563762 665737 677848 682763 683477 695730 696086 708681 711041 713864 715070 768280 796363 802872 825843 ] |
||||||||||||||||||||||||||||||
|
14.66 ms (9.16%) |
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 391771 418046 426029 438506 447224 416116 445105 472392 516159 501407 502854 483855 497918 490134 411198 461831 775468 796363 479597 488984 493657 515586 419324 441822 466852 490750 802872 768280 471050 479240 466391 472311 477779 461814 471712 482001 181693 30208 389883 389964 400507 402599 411310 418655 441770 443924 411904 413958 418268 418689 425279 426637 437724 437836 441609 442135 418425 418975 423652 429537 435618 435643 441583 417070 418862 415802 429242 440292 825843 449194 453912 456252 458109 463779 486910 487389 488381 489853 449514 450141 456505 482892 493808 446520 449411 464911 473282 477515 481985 485283 490664 501031 510377 537480 499172 505290 530418 534893 495304 501362 504020 464587 472262 473620 481101 493981 545874 545761 555564 677848 682763 708681 711041 713864 683477 695730 715070 665737 696086 563762 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.76%) |
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 30208 181693 389883 389964 391771 400507 402599 411198 411310 411904 413958 415802 416116 417070 418046 418268 418425 418655 418689 418862 418975 419324 423652 425279 426029 426637 429242 429537 435618 435643 437724 437836 438506 440292 441583 441609 441770 441822 442135 443924 445105 446520 447224 449194 449411 449514 450141 453912 456252 456505 458109 461814 461831 463779 464587 464911 466391 466852 471050 471712 472262 472311 472392 473282 473620 477515 477779 479240 479597 481101 481985 482001 482892 483855 485283 486910 487389 488381 488984 489853 490134 490664 490750 493657 493808 493981 495304 497918 499172 501031 501362 501407 502854 504020 505290 510377 515586 516159 530418 534893 537480 545761 545874 555564 563762 665737 677848 682763 683477 695730 696086 708681 711041 713864 715070 768280 796363 802872 825843 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"gorgeous wife"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"шикарная жен"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.97%) |
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.