Query Metrics
7
Database Queries
7
Different statements
413.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
386.21 ms (93.34%) |
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 373768 384757 387015 397265 405712 414339 416824 416873 420768 421582 439828 453336 458034 458772 465054 470412 482375 482768 482839 484410 486779 530039 530383 530476 530491 530770 530789 530851 531139 531173 531194 531208 531260 531261 531524 532653 532737 532741 532779 532837 532960 532967 533371 533556 535038 535358 535620 535644 536285 536337 536340 536579 536608 536621 536628 536631 537896 537908 537911 537913 537988 540291 542583 542588 542912 544796 544812 544827 545648 550124 550203 569386 600290 600295 600352 601517 606578 607355 610083 613508 632697 633521 633768 634122 634207 634556 634561 636303 639731 639742 639762 640800 642000 642064 644273 644962 645952 647320 647322 647638 648838 649619 650175 650325 650830 652223 675019 676092 676107 677801 677986 678144 678161 678533 679728 704526 720720 723620 747140 807953 ] |
||||||||||||||||||||||||||||||
|
19.04 ms (4.60%) |
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 416873 373768 397265 421582 387015 458772 416824 458034 482839 384757 405712 414339 420768 439828 723620 644962 482375 453336 470412 486779 465054 482768 530039 530383 530491 531208 531260 532779 533371 536285 536340 536608 537908 540291 531524 532737 532741 532960 532967 533556 535358 536337 536579 536621 530476 530770 531139 531173 531261 532837 535644 536631 537911 537913 530789 530851 531194 532653 535038 535620 536628 537896 537988 484410 542912 545648 550124 550203 569386 542583 544827 542588 544812 647320 650175 652223 678144 678161 679728 650325 677801 677986 678533 704526 720720 645952 647322 647638 648838 649619 650830 675019 676092 676107 544796 642064 644273 632697 639762 642000 600290 600352 634122 636303 640800 600295 601517 613508 634207 634556 634561 639742 807953 747140 606578 607355 610083 633521 633768 639731 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (0.60%) |
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 373768 384757 387015 397265 405712 414339 416824 416873 420768 421582 439828 453336 458034 458772 465054 470412 482375 482768 482839 484410 486779 530039 530383 530476 530491 530770 530789 530851 531139 531173 531194 531208 531260 531261 531524 532653 532737 532741 532779 532837 532960 532967 533371 533556 535038 535358 535620 535644 536285 536337 536340 536579 536608 536621 536628 536631 537896 537908 537911 537913 537988 540291 542583 542588 542912 544796 544812 544827 545648 550124 550203 569386 600290 600295 600352 601517 606578 607355 610083 613508 632697 633521 633768 634122 634207 634556 634561 636303 639731 639742 639762 640800 642000 642064 644273 644962 645952 647320 647322 647638 648838 649619 650175 650325 650830 652223 675019 676092 676107 677801 677986 678144 678161 678533 679728 704526 720720 723620 747140 807953 ] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.38%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд cock"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo by cock"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд cock"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.35%) |
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.