Query Metrics
7
Database Queries
7
Different statements
156.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.57 ms (81.95%) |
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 391567 395812 395984 404633 415223 419198 419590 422500 422594 422709 423259 428302 463948 463965 473112 483498 486354 489484 491644 494695 501809 508438 511733 512257 514796 515202 518270 523985 524089 525102 526188 528459 529846 530757 532831 533471 545517 545610 550067 550099 558138 558947 561653 562116 565471 566703 567166 568556 568573 568580 569677 569682 573788 574818 575059 575137 576101 576112 576859 580669 583677 584022 584539 590542 595383 595489 596648 597045 597940 598092 598806 606508 612399 612799 619175 622331 622398 622402 623849 626878 627809 627813 628387 628406 630540 631965 632001 632046 634482 637094 637123 646838 660439 666546 666868 666883 677053 677142 692127 701118 716161 720487 722717 727798 731379 741306 747387 747595 750143 751770 754192 774155 774162 790036 790754 791181 800588 811628 812150 813902 ] |
||||||||||||||||||||||||||||||
|
18.10 ms (11.54%) |
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 494695 523985 576101 561653 574818 692127 597940 596648 576859 622398 566703 565471 634482 612399 612799 791181 747595 473112 391567 501809 489484 404633 701118 812150 774162 731379 774155 716161 597045 575059 573788 575137 423259 530757 529846 533471 550067 550099 558138 567166 584539 545610 584022 568556 568580 576112 583677 660439 677142 646838 666546 666883 606508 627809 630540 631965 623849 590542 598092 628387 628406 619175 622331 622402 632001 632046 637094 800588 598806 637123 518270 722717 720487 666868 419590 568573 569677 811628 627813 395984 483498 515202 463965 512257 514796 463948 428302 569682 558947 580669 595383 422709 415223 422500 524089 526188 562116 545517 595489 790754 790036 395812 419198 422594 525102 508438 528459 532831 486354 491644 511733 813902 677053 626878 754192 727798 741306 751770 747387 750143 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.78%) |
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 391567 395812 395984 404633 415223 419198 419590 422500 422594 422709 423259 428302 463948 463965 473112 483498 486354 489484 491644 494695 501809 508438 511733 512257 514796 515202 518270 523985 524089 525102 526188 528459 529846 530757 532831 533471 545517 545610 550067 550099 558138 558947 561653 562116 565471 566703 567166 568556 568573 568580 569677 569682 573788 574818 575059 575137 576101 576112 576859 580669 583677 584022 584539 590542 595383 595489 596648 597045 597940 598092 598806 606508 612399 612799 619175 622331 622398 622402 623849 626878 627809 627813 628387 628406 630540 631965 632001 632046 634482 637094 637123 646838 660439 666546 666868 666883 677053 677142 692127 701118 716161 720487 722717 727798 731379 741306 747387 747595 750143 751770 754192 774155 774162 790036 790754 791181 800588 811628 812150 813902 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen маленькая young"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen small young"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen маленькая young"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.04%) |
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.