Query Metrics
7
Database Queries
7
Different statements
191.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.67 ms (87.46%) |
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 392019 392023 410346 412330 414077 418121 419824 420774 428174 429596 429600 429905 434309 435530 440639 440708 443240 443247 444535 444548 445945 446022 447040 454688 455078 458115 464659 464815 468665 469096 470470 473453 474163 477417 483731 483745 483762 485468 485546 486778 493825 494325 495561 508891 508895 514254 515488 517304 517511 519349 523358 526189 530942 537091 547452 547481 547494 547979 548464 549740 553215 553221 554369 554551 555042 558261 569168 585296 586002 587184 598406 600719 601789 602249 604404 604781 613780 619802 626889 632094 636955 660359 660365 660373 665586 667011 668677 669023 669079 669361 669376 669386 671052 672950 700997 707556 709241 711629 718678 728466 733458 733541 740450 740555 742341 744173 749050 751678 752661 765699 796808 797146 803490 804241 805120 811104 811112 813605 817172 825751 ] |
||||||||||||||||||||||||||||||
|
14.53 ms (7.58%) |
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 813605 817172 486778 474163 547979 553221 636955 626889 797146 803490 811104 744173 804241 811112 728466 740450 733458 749050 740555 632094 445945 473453 508891 508895 547481 547494 718678 669079 669361 669376 669386 619802 586002 604781 752661 444548 414077 483745 555042 549740 667011 668677 709241 660365 665586 669023 585296 587184 733541 742341 751678 765699 700997 796808 435530 429600 440708 429596 418121 468665 464659 458115 470470 493825 494325 517304 517511 519349 515488 526189 495561 464815 558261 554369 569168 671052 553215 600719 604404 613780 601789 805120 392023 410346 446022 429905 434309 455078 443240 485546 825751 419824 443247 523358 602249 598406 444535 428174 392019 412330 420774 440639 447040 483731 454688 485468 477417 537091 514254 530942 469096 483762 548464 547452 554551 707556 711629 660359 660373 672950 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature solo dildo"
]
|
||||||||||||||||||||||||||||||
|
2.46 ms (1.29%) |
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 392019 392023 410346 412330 414077 418121 419824 420774 428174 429596 429600 429905 434309 435530 440639 440708 443240 443247 444535 444548 445945 446022 447040 454688 455078 458115 464659 464815 468665 469096 470470 473453 474163 477417 483731 483745 483762 485468 485546 486778 493825 494325 495561 508891 508895 514254 515488 517304 517511 519349 523358 526189 530942 537091 547452 547481 547494 547979 548464 549740 553215 553221 554369 554551 555042 558261 569168 585296 586002 587184 598406 600719 601789 602249 604404 604781 613780 619802 626889 632094 636955 660359 660365 660373 665586 667011 668677 669023 669079 669361 669376 669386 671052 672950 700997 707556 709241 711629 718678 728466 733458 733541 740450 740555 742341 744173 749050 751678 752661 765699 796808 797146 803490 804241 805120 811104 811112 813605 817172 825751 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature соло дилд"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.35 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature соло дилд"
]
|
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.