Query Metrics
7
Database Queries
7
Different statements
185.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.56 ms (84.62%) |
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 101056 389495 389803 390818 391219 398940 408339 414064 418692 418943 420742 421199 424721 428115 435171 446019 446272 446695 449023 449107 449470 450392 452355 454282 456214 461840 464836 465553 466460 469081 473400 473479 475860 480478 483444 483686 497037 499326 502777 503712 507168 515275 515546 516605 517736 520161 520252 522184 522632 523245 523461 523599 526102 526556 529340 529351 530811 538708 541212 545882 547959 552081 562418 564486 565127 567331 567414 572006 572764 574086 574657 582282 582443 582955 584158 584726 592605 594113 594125 594150 594201 596470 596649 597284 601388 601744 603310 604782 604843 604909 605591 606636 607070 607236 607966 622592 625553 628641 641436 650345 651845 652513 679213 683297 690020 717410 724467 742383 745345 755350 770123 770402 775414 776398 799049 805630 808027 810103 811271 811415 ] |
||||||||||||||||||||||||||||||
|
19.20 ms (10.38%) |
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 389495 456214 391219 408339 452355 522632 811415 414064 449023 480478 574086 574657 545882 562418 584158 601744 594125 607070 449470 454282 465553 526556 526102 503712 446272 473400 101056 389803 418692 469081 483444 464836 497037 499326 523599 515546 529351 538708 515275 466460 547959 582955 565127 572764 552081 679213 652513 717410 650345 683297 567414 582443 604782 604909 606636 592605 597284 604843 607966 622592 601388 625553 775414 799049 805630 810103 776398 811271 724467 770123 770402 742383 745345 755350 808027 475860 398940 435171 450392 522184 520252 523461 483686 473479 507168 582282 596649 594201 461840 446019 516605 390818 418943 421199 428115 420742 424721 446695 449107 520161 502777 523245 517736 529340 530811 564486 584726 541212 690020 651845 567331 572006 603310 605591 594150 596470 607236 628641 641436 594113 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.38%) |
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 101056 389495 389803 390818 391219 398940 408339 414064 418692 418943 420742 421199 424721 428115 435171 446019 446272 446695 449023 449107 449470 450392 452355 454282 456214 461840 464836 465553 466460 469081 473400 473479 475860 480478 483444 483686 497037 499326 502777 503712 507168 515275 515546 516605 517736 520161 520252 522184 522632 523245 523461 523599 526102 526556 529340 529351 530811 538708 541212 545882 547959 552081 562418 564486 565127 567331 567414 572006 572764 574086 574657 582282 582443 582955 584158 584726 592605 594113 594125 594150 594201 596470 596649 597284 601388 601744 603310 604782 604843 604909 605591 606636 607070 607236 607966 622592 625553 628641 641436 650345 651845 652513 679213 683297 690020 717410 724467 742383 745345 755350 770123 770402 775414 776398 799049 805630 808027 810103 811271 811415 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"busty masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"busty мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"busty мастурбац"
]
|
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.