Query Metrics
7
Database Queries
7
Different statements
152.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.59 ms (80.61%) |
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 124144 395676 406012 406018 410267 410352 410543 420406 422340 424329 429137 437285 441536 444542 445603 445652 446364 448878 449435 453826 458924 458925 460588 461059 461086 462294 462434 462606 463864 464136 464152 466278 469357 469533 469738 471464 472934 472943 473172 474746 475078 475443 476409 476962 477339 480399 482788 482795 485086 485100 486275 486456 493818 495035 499805 499830 500098 506500 506908 508737 510109 515681 515686 515737 515763 516624 519095 520176 522605 522606 522609 522618 522622 522785 522876 523442 526894 527750 529183 531061 532066 533928 541540 541604 541889 544490 544498 560155 571199 572653 572716 578666 584004 595682 595755 596829 602409 615978 619395 619396 619399 619401 619468 619483 619486 619802 619823 624152 626297 665675 675123 675430 675657 675675 675696 675723 675725 676097 706935 732735 ] |
||||||||||||||||||||||||||||||
|
18.09 ms (11.90%) |
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 619823 475078 675675 675723 706935 596829 602409 124144 482788 584004 395676 458924 516624 532066 560155 619395 619468 732735 461059 475443 429137 523442 466278 469357 493818 519095 544498 675430 675657 619401 619396 619486 462294 445603 495035 515686 453826 520176 527750 472934 572653 675696 675725 624152 480399 476962 406012 499805 437285 515737 541540 544490 486275 464152 578666 619802 445652 469533 463864 619399 441536 449435 410267 595682 474746 626297 461086 460588 510109 665675 410352 500098 499830 531061 422340 458925 522785 526894 515763 529183 508737 464136 471464 619483 462606 446364 469738 522606 571199 522609 406018 477339 676097 473172 522876 522618 522622 420406 485086 541604 444542 515681 482795 472943 506908 448878 522605 485100 533928 462434 476409 541889 410543 675123 486456 424329 572716 595755 615978 506500 ] |
||||||||||||||||||||||||||||||
|
3.50 ms (2.30%) |
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 124144 395676 406012 406018 410267 410352 410543 420406 422340 424329 429137 437285 441536 444542 445603 445652 446364 448878 449435 453826 458924 458925 460588 461059 461086 462294 462434 462606 463864 464136 464152 466278 469357 469533 469738 471464 472934 472943 473172 474746 475078 475443 476409 476962 477339 480399 482788 482795 485086 485100 486275 486456 493818 495035 499805 499830 500098 506500 506908 508737 510109 515681 515686 515737 515763 516624 519095 520176 522605 522606 522609 522618 522622 522785 522876 523442 526894 527750 529183 531061 532066 533928 541540 541604 541889 544490 544498 560155 571199 572653 572716 578666 584004 595682 595755 596829 602409 615978 619395 619396 619399 619401 619468 619483 619486 619802 619823 624152 626297 665675 675123 675430 675657 675675 675696 675723 675725 676097 706935 732735 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex french"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс french"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс french"
]
|
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.