Query Metrics
7
Database Queries
7
Different statements
157.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.16 ms (83.84%) |
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 397335 401924 404693 406646 413274 415387 415388 416876 417388 420398 421340 428987 429906 433067 440680 446027 446505 447121 447904 451950 454099 455841 462872 468651 469182 474553 475410 477183 482679 488551 488805 489120 494979 497964 499446 499636 500913 502530 503118 503840 507928 514150 514309 515135 515475 516857 517391 523553 524749 527203 530494 532741 532843 532848 533353 533929 534280 534293 534650 536835 537674 537991 539239 539240 539424 540333 543810 543921 550093 551103 552997 553916 556036 557196 560201 563844 563852 564842 566126 566385 568914 577519 580518 583331 586494 588262 591807 595821 597638 599159 602006 603657 625604 628114 634198 639729 642266 647637 647993 649838 650206 673522 678306 711555 721790 727611 731869 750436 752599 762721 764892 790853 794668 796008 810521 810890 813316 815748 815881 822077 ] |
||||||||||||||||||||||||||||||
|
16.38 ms (10.39%) |
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 750436 764892 625604 416876 401924 815881 815748 482679 455841 469182 474553 454099 532848 534650 497964 515475 534293 540333 494979 517391 524749 536835 553916 551103 564842 568914 583331 647637 673522 721790 552997 577519 580518 597638 599159 591807 595821 628114 602006 639729 397335 417388 415387 447121 451950 420398 502530 514309 488805 516857 488551 499636 537991 634198 822077 446505 532843 647993 468651 514150 810521 813316 794668 762721 727611 563852 556036 413274 539240 499446 503840 752599 527203 731869 790853 404693 406646 429906 440680 421340 447904 537674 539239 500913 507928 523553 532741 534280 530494 533353 539424 503118 533929 543810 550093 543921 557196 560201 563844 649838 586494 603657 462872 475410 477183 415388 428987 446027 489120 515135 433067 566385 678306 711555 650206 566126 588262 642266 796008 810890 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.39%) |
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 397335 401924 404693 406646 413274 415387 415388 416876 417388 420398 421340 428987 429906 433067 440680 446027 446505 447121 447904 451950 454099 455841 462872 468651 469182 474553 475410 477183 482679 488551 488805 489120 494979 497964 499446 499636 500913 502530 503118 503840 507928 514150 514309 515135 515475 516857 517391 523553 524749 527203 530494 532741 532843 532848 533353 533929 534280 534293 534650 536835 537674 537991 539239 539240 539424 540333 543810 543921 550093 551103 552997 553916 556036 557196 560201 563844 563852 564842 566126 566385 568914 577519 580518 583331 586494 588262 591807 595821 597638 599159 602006 603657 625604 628114 634198 639729 642266 647637 647993 649838 650206 673522 678306 711555 721790 727611 731869 750436 752599 762721 764892 790853 794668 796008 810521 810890 813316 815748 815881 822077 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina small cock"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская маленькая cock"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"латинская маленькая cock"
]
|
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.