Query Metrics
7
Database Queries
7
Different statements
414.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
276.64 ms (66.75%) |
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 439641 532954 418145 605746 449404 547890 593586 389729 475185 424194 434371 511828 513486 745672 555066 685065 680800 810409 742356 742358 468255 424216 519313 430369 667052 708551 525577 496758 460027 537984 555098 670997 700478 695096 690749 621287 780016 803035 807067 790162 727666 751067 754589 771015 607828 705630 722591 785851 813332 619965 631245 475227 601792 391170 514399 513476 517816 411468 555834 554210 620663 529998 510877 428929 479083 439020 751565 467867 741687 756840 458051 440995 510170 424248 478003 544510 555057 686214 721203 649516 549836 618908 785972 747328 758281 439125 470198 461469 491925 502800 513672 486189 488537 436178 431090 495562 439545 389462 479694 429736 434286 447431 466206 431028 519299 498649 499391 513551 521798 401200 434376 555571 649566 556871 448851 454517 674177 722264 700257 705809 ] |
||||||||||||||||||||||||||||||
|
126.92 ms (30.63%) |
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 389462 389729 391170 401200 411468 418145 424194 424216 424248 428929 429736 430369 431028 431090 434286 434371 434376 436178 439020 439125 439545 439641 440995 447431 448851 449404 454517 458051 460027 461469 466206 467867 468255 470198 475185 475227 478003 479083 479694 486189 488537 491925 495562 496758 498649 499391 502800 510170 510877 511828 513486 513551 513672 514399 517816 519299 519313 521798 525577 529998 532954 537984 544510 547890 549836 554210 555057 555066 555098 555571 555834 556871 593586 601792 605746 607828 618908 619965 620663 621287 631245 649516 649566 667052 670997 674177 680800 685065 686214 690749 695096 700257 700478 705630 705809 708551 721203 722264 722591 727666 741687 742356 742358 745672 747328 751067 751565 754589 756840 758281 771015 780016 785851 785972 790162 803035 807067 810409 813332 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (0.77%) |
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 389462 389729 391170 401200 411468 418145 424194 424216 424248 428929 429736 430369 431028 431090 434286 434371 434376 436178 439020 439125 439545 439641 440995 447431 448851 449404 454517 458051 460027 461469 466206 467867 468255 470198 475185 475227 478003 479083 479694 486189 488537 491925 495562 496758 498649 499391 502800 510170 510877 511828 513486 513551 513672 514399 517816 519299 519313 521798 525577 529998 532954 537984 544510 547890 549836 554210 555057 555066 555098 555571 555834 556871 593586 601792 605746 607828 618908 619965 620663 621287 631245 649516 649566 667052 670997 674177 680800 685065 686214 690749 695096 700257 700478 705630 705809 708551 721203 722264 722591 727666 741687 742356 742358 745672 747328 751067 751565 754589 756840 758281 771015 780016 785851 785972 790162 803035 807067 810409 813332 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian anal dildo"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск анал дилд"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.46%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.