Query Metrics
7
Database Queries
7
Different statements
201.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.76 ms (88.04%) |
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 56464 76172 270290 392066 395240 396404 430777 449718 464404 465661 483484 485522 485548 491351 500436 501505 512188 515137 515601 515624 515661 515692 522034 530364 531166 531902 531997 539458 543711 544321 547927 551133 551703 553968 562708 562743 563512 563514 566555 568699 569052 569423 572580 578072 588340 588341 588362 588370 594892 596227 596324 600277 600820 600831 601255 601619 602806 602933 605999 619423 621635 634468 643386 651198 654074 661941 664772 667774 668518 671942 673611 681062 681613 690314 694551 699573 705530 705531 707308 707314 708840 712721 714170 715493 721772 730235 731546 736908 742247 744651 748202 750326 752950 757439 759842 759935 760549 760814 771370 775890 777843 780399 785920 787178 788866 789243 799965 800356 801247 803327 805206 806352 814938 815141 815283 815308 815508 815810 815895 816554 ] |
||||||||||||||||||||||||||||||
|
14.26 ms (7.06%) |
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 705531 56464 601255 742247 759935 601619 530364 600277 708840 801247 578072 694551 789243 673611 671942 667774 602806 392066 430777 661941 596324 787178 531166 588362 799965 600820 803327 605999 572580 543711 588341 600831 731546 715493 634468 815141 815895 515661 270290 562708 712721 785920 643386 816554 544321 563512 566555 651198 780399 748202 588340 491351 654074 568699 500436 515624 707314 76172 664772 681062 449718 815308 539458 531902 551703 721772 690314 805206 777843 760549 551133 602933 465661 512188 515692 699573 815283 815810 531997 569052 562743 788866 800356 707308 714170 547927 619423 522034 569423 705530 553968 483484 814938 668518 515137 485522 515601 563514 594892 752950 759842 771370 775890 464404 815508 681613 621635 750326 806352 760814 730235 744651 757439 736908 588370 596227 396404 395240 485548 501505 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.30%) |
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 56464 76172 270290 392066 395240 396404 430777 449718 464404 465661 483484 485522 485548 491351 500436 501505 512188 515137 515601 515624 515661 515692 522034 530364 531166 531902 531997 539458 543711 544321 547927 551133 551703 553968 562708 562743 563512 563514 566555 568699 569052 569423 572580 578072 588340 588341 588362 588370 594892 596227 596324 600277 600820 600831 601255 601619 602806 602933 605999 619423 621635 634468 643386 651198 654074 661941 664772 667774 668518 671942 673611 681062 681613 690314 694551 699573 705530 705531 707308 707314 708840 712721 714170 715493 721772 730235 731546 736908 742247 744651 748202 750326 752950 757439 759842 759935 760549 760814 771370 775890 777843 780399 785920 787178 788866 789243 799965 800356 801247 803327 805206 806352 814938 815141 815283 815308 815508 815810 815895 816554 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom glasses office"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom очкастая секретарш"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom очкастая секретарш"
]
|
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.