Query Metrics
7
Database Queries
7
Different statements
583.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
415.81 ms (71.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"her boobs"
]
|
||||||||||||||||||||||||||||||
|
145.65 ms (24.95%) |
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 185296 191336 387472 421809 432228 440726 447886 448427 449716 452345 456037 456647 456707 457475 458313 460663 464296 464298 469500 469582 471657 474443 484533 485720 493443 496301 496549 497037 503733 505342 510516 512897 514878 515982 519908 525621 526578 528716 532519 535379 535483 538912 540071 543180 543311 543492 546402 556592 557496 558772 568640 580847 582852 609376 610223 621347 626369 630519 650435 650992 664221 680541 720524 726116 733105 735541 738297 738852 744186 748017 770173 773204 773681 774591 797069 802427 813917 814753 814783 814787 814840 814885 815305 815367 815520 815608 815755 815902 816780 816816 816839 817579 818205 818808 818849 819148 819239 819254 820330 821069 824174 825338 825356 826376 826393 826959 827583 828001 828060 828194 828229 828313 828490 828596 828709 828802 ] |
||||||||||||||||||||||||||||||
|
14.46 ms (2.48%) |
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 826376 816780 818808 826959 815902 818205 825338 825356 826393 828001 828194 828802 828081 828040 828490 828596 535379 512897 558772 546402 720524 802427 733105 744186 191336 557496 556592 582852 650435 680541 610223 626369 774591 773681 738297 770173 738852 609376 505342 528716 519908 540071 650992 621347 440726 387472 816816 826228 816839 827583 817579 819148 819254 824404 818849 819239 828229 828060 828313 828709 535483 543492 664221 630519 797069 748017 726116 773204 735541 185296 432228 421809 813917 815305 815367 814753 815608 815755 820330 814783 814840 814885 815520 814787 821069 824174 448427 456647 456707 457475 469500 484533 485720 447886 449716 458313 452345 456037 460663 471657 493443 496549 503733 497037 525621 538912 514878 496301 510516 515982 526578 532519 464296 464298 469582 474443 543311 568640 580847 543180 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (0.43%) |
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 185296 191336 387472 421809 432228 440726 447886 448427 449716 452345 456037 456647 456707 457475 458313 460663 464296 464298 469500 469582 471657 474443 484533 485720 493443 496301 496549 497037 503733 505342 510516 512897 514878 515982 519908 525621 526578 528716 532519 535379 535483 538912 540071 543180 543311 543492 546402 556592 557496 558772 568640 580847 582852 609376 610223 621347 626369 630519 650435 650992 664221 680541 720524 726116 733105 735541 738297 738852 744186 748017 770173 773204 773681 774591 797069 802427 813917 814753 814783 814787 814840 814885 815305 815367 815520 815608 815755 815902 816780 816816 816839 817579 818205 818808 818849 819148 819239 819254 820330 821069 824174 825338 825356 826376 826393 826959 827583 828001 828060 828194 828229 828313 828490 828596 828709 828802 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"her boobs"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"her boobs"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.