Query Metrics
7
Database Queries
7
Different statements
150.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.70 ms (81.99%) |
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 21575 249926 318892 393233 396273 414635 416367 418422 420629 421627 422629 425875 438889 443305 443599 443699 445237 446252 446461 447650 447809 447919 448760 451700 453228 455140 456909 459228 459801 460769 460770 461617 462123 463839 464177 465152 465741 466022 466588 468462 468585 468597 470238 470446 470530 470764 471359 472592 473058 473079 473771 474011 474380 474585 476421 478873 479197 480807 482929 484842 484849 485461 487038 488700 489050 489507 489566 491195 491585 491640 494499 495358 497039 497067 499782 500926 502292 502678 505952 506387 508043 510436 510510 512576 516743 517692 518982 520949 522599 523703 527607 533394 536674 537577 539396 540304 540334 540422 540574 540788 541099 546662 549979 559912 693847 709919 729626 730715 738245 741980 778239 799980 804704 810850 811863 817451 828058 ] |
||||||||||||||||||||||||||||||
|
16.19 ms (10.73%) |
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 522599 527607 478873 709919 730715 729626 738245 393233 396273 443305 470238 21575 443699 455140 474011 422629 447919 459801 465152 465741 468585 470446 473058 470530 470764 516743 494499 500926 517692 482929 489507 495358 512576 502678 693847 485461 540574 823062 533394 537577 546662 540788 539396 799980 810850 741980 823105 822348 828058 510510 549979 778239 804704 249926 438889 443599 421627 416367 420629 817451 446252 487038 491195 491585 453228 460770 473771 446461 466588 474585 497039 520949 540334 540422 497067 536674 518982 540304 472592 489050 541099 559912 811863 414635 425875 447809 448760 456909 459228 460769 476421 480807 447650 463839 471359 473079 474380 418422 461617 318892 462123 468462 479197 445237 451700 464177 466022 468597 523703 484842 499782 505952 508043 484849 488700 489566 491640 502292 506387 510436 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (2.09%) |
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 21575 249926 318892 393233 396273 414635 416367 418422 420629 421627 422629 425875 438889 443305 443599 443699 445237 446252 446461 447650 447809 447919 448760 451700 453228 455140 456909 459228 459801 460769 460770 461617 462123 463839 464177 465152 465741 466022 466588 468462 468585 468597 470238 470446 470530 470764 471359 472592 473058 473079 473771 474011 474380 474585 476421 478873 479197 480807 482929 484842 484849 485461 487038 488700 489050 489507 489566 491195 491585 491640 494499 495358 497039 497067 499782 500926 502292 502678 505952 506387 508043 510436 510510 512576 516743 517692 518982 520949 522599 523703 527607 533394 536674 537577 539396 540304 540334 540422 540574 540788 541099 546662 549979 559912 693847 709919 729626 730715 738245 741980 778239 799980 804704 810850 811863 817451 828058 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"white skinny"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"white худые"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"white худые"
]
|
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.