Query Metrics
7
Database Queries
7
Different statements
164.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.64 ms (85.66%) |
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 326205 383270 387005 387325 393742 403276 405858 406711 415871 417749 419927 420156 421044 421575 422051 444803 448259 451671 458397 459537 459777 462577 465902 466329 466458 467762 467942 469629 474889 476590 477783 477907 480113 480697 482814 485552 488576 490553 493024 496528 499160 500420 500710 503825 506144 508944 511564 513994 516901 517768 518555 519266 519740 520017 521726 539216 540658 542509 548734 548820 552483 552656 552703 553974 557077 558843 560153 565354 567081 569442 573238 573984 590174 590592 591380 597530 612247 613405 621193 621725 647844 662476 672975 682883 683314 695127 696764 704208 707730 707786 713651 722141 724887 726177 727056 731697 741212 746053 765007 767329 768552 772793 777878 777905 778748 779573 779974 780086 780965 782557 782697 786319 788828 789859 790592 790701 791699 794001 800562 805141 ] |
||||||||||||||||||||||||||||||
|
12.89 ms (7.85%) |
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 696764 707786 786319 790701 789859 772793 794001 768552 724887 731697 613405 777878 778748 779974 459777 422051 482814 496528 552656 560153 591380 448259 458397 467762 519740 500710 508944 499160 513994 516901 511564 405858 415871 503825 782697 767329 474889 383270 552483 417749 421575 480697 467942 520017 421044 451671 459537 477783 542509 780086 477907 480113 444803 493024 573238 465902 500420 490553 387005 466458 539216 790592 779573 780965 469629 540658 707730 683314 722141 682883 713651 621725 777905 791699 765007 741212 403276 565354 548734 558843 387325 662476 621193 406711 518555 548820 488576 746053 466329 567081 647844 704208 506144 553974 552703 590592 476590 393742 569442 590174 695127 557077 519266 420156 517768 326205 419927 521726 462577 485552 573984 672975 612247 597530 800562 805141 782557 726177 727056 788828 ] |
||||||||||||||||||||||||||||||
|
3.24 ms (1.98%) |
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 326205 383270 387005 387325 393742 403276 405858 406711 415871 417749 419927 420156 421044 421575 422051 444803 448259 451671 458397 459537 459777 462577 465902 466329 466458 467762 467942 469629 474889 476590 477783 477907 480113 480697 482814 485552 488576 490553 493024 496528 499160 500420 500710 503825 506144 508944 511564 513994 516901 517768 518555 519266 519740 520017 521726 539216 540658 542509 548734 548820 552483 552656 552703 553974 557077 558843 560153 565354 567081 569442 573238 573984 590174 590592 591380 597530 612247 613405 621193 621725 647844 662476 672975 682883 683314 695127 696764 704208 707730 707786 713651 722141 724887 726177 727056 731697 741212 746053 765007 767329 768552 772793 777878 777905 778748 779573 779974 780086 780965 782557 782697 786319 788828 789859 790592 790701 791699 794001 800562 805141 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм в рот красивая"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм в рот красивая"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð║ð¥ð¢Ðçð░ðÁÐé ð▓ ÐÇð¥Ðé ð║ÐÇð░Ðüð¥Ðéð║ðÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.87%) |
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.