Query Metrics
7
Database Queries
7
Different statements
163.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.70 ms (85.93%) |
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 398747 417154 420405 458781 459368 487466 499578 511615 513570 518152 528371 534515 547608 552287 557833 559318 559326 562984 570131 577446 579368 585256 608609 612285 616509 623293 623918 624232 626579 626791 630136 630140 632089 637311 644171 649066 654691 660098 665995 667187 674502 676652 677586 678214 678219 693009 693511 695764 697188 699233 699543 703765 706379 707485 708743 709458 711710 713601 714953 715362 715442 715489 716956 717219 717546 718648 718913 724889 725219 727283 729694 734296 734569 736981 738127 744184 745610 747240 747981 748000 753210 753281 758747 760440 761384 762024 764005 768072 770373 771935 778481 779150 787775 790815 791267 791672 792775 793084 793521 793827 794109 794110 794394 794418 794442 794460 794511 794532 794712 794871 794893 795038 795381 796490 802043 802310 803614 805259 807245 811875 ] |
||||||||||||||||||||||||||||||
|
12.91 ms (7.88%) |
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 729694 753281 758747 770373 734569 707485 715489 807245 398747 699543 420405 511615 499578 487466 559326 649066 693511 708743 718913 667187 674502 695764 717219 608609 623293 644171 623918 778481 779150 791672 794418 794511 793084 794109 794712 724889 734296 794110 794893 796490 803614 725219 747240 748000 745610 753210 747981 727283 736981 624232 697188 715362 718648 793521 794460 794871 802310 811875 791267 738127 709458 579368 711710 717546 795038 762024 458781 562984 714953 585256 616509 794394 790815 794442 794532 761384 632089 805259 630136 518152 654691 744184 792775 793827 764005 534515 513570 547608 660098 665995 678214 678219 676652 637311 626791 787775 795381 760440 768072 771935 630140 715442 557833 559318 577446 459368 417154 528371 552287 570131 677586 703765 716956 693009 699233 706379 713601 612285 626579 802043 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.84%) |
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 398747 417154 420405 458781 459368 487466 499578 511615 513570 518152 528371 534515 547608 552287 557833 559318 559326 562984 570131 577446 579368 585256 608609 612285 616509 623293 623918 624232 626579 626791 630136 630140 632089 637311 644171 649066 654691 660098 665995 667187 674502 676652 677586 678214 678219 693009 693511 695764 697188 699233 699543 703765 706379 707485 708743 709458 711710 713601 714953 715362 715442 715489 716956 717219 717546 718648 718913 724889 725219 727283 729694 734296 734569 736981 738127 744184 745610 747240 747981 748000 753210 753281 758747 760440 761384 762024 764005 768072 770373 771935 778481 779150 787775 790815 791267 791672 792775 793084 793521 793827 794109 794110 794394 794418 794442 794460 794511 794532 794712 794871 794893 795038 795381 796490 802043 802310 803614 805259 807245 811875 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sperm inside pussy"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм inside pussy"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм inside pussy"
]
|
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.