Query Metrics
7
Database Queries
7
Different statements
213.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.78 ms (82.98%) |
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 187443 382676 407863 411371 421855 423832 424458 426697 432394 432497 432543 433078 433390 433618 436419 444071 444650 444819 456345 457959 464491 469498 470628 470888 471193 476633 477676 487320 490874 492012 492926 499542 500314 501494 503338 504962 507540 509736 512198 513978 516055 516652 520044 524100 525555 526569 526772 528843 529437 536525 554423 554434 555703 557195 559865 559889 560185 563609 565316 571834 572882 579338 581292 582899 585525 587781 589928 590893 594638 600463 604381 604688 619474 620851 622294 622927 624792 625973 632074 682857 686343 697892 697917 701231 713437 713706 714561 715603 716111 716240 720361 731472 735768 736561 740586 742063 754842 758572 764100 767704 770965 772846 776227 778017 782013 783934 785883 787154 788121 790285 793566 796493 798799 799740 800550 802601 802944 811098 812697 ] |
||||||||||||||||||||||||||||||
|
26.11 ms (12.26%) |
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 783934 767704 714561 788121 802944 526772 528843 492012 622927 426697 720361 793566 776227 802601 457959 557195 516652 555703 782013 579338 701231 470628 620851 590893 436419 716111 800550 598922 778017 432394 464491 433390 444071 187443 604381 469498 477676 736561 500314 470888 499542 713706 686343 632074 625973 790285 796493 787154 758572 742063 754842 770965 624792 713437 798799 559865 421855 516055 735768 604688 731472 536525 513978 622294 619474 529437 490874 772846 565316 563609 501494 524100 504962 507540 509736 520044 525555 554434 407863 476633 697917 799740 811098 764100 444819 582899 411371 587781 785883 432497 433618 512198 432543 471193 716240 715603 424458 572882 456345 503338 423832 433078 526569 581292 492926 697892 560185 594638 812697 740586 382676 571834 600463 444650 487320 554423 682857 559889 585525 589928 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.41%) |
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 187443 382676 407863 411371 421855 423832 424458 426697 432394 432497 432543 433078 433390 433618 436419 444071 444650 444819 456345 457959 464491 469498 470628 470888 471193 476633 477676 487320 490874 492012 492926 499542 500314 501494 503338 504962 507540 509736 512198 513978 516055 516652 520044 524100 525555 526569 526772 528843 529437 536525 554423 554434 555703 557195 559865 559889 560185 563609 565316 571834 572882 579338 581292 582899 585525 587781 589928 590893 594638 600463 604381 604688 619474 620851 622294 622927 624792 625973 632074 682857 686343 697892 697917 701231 713437 713706 714561 715603 716111 716240 720361 731472 735768 736561 740586 742063 754842 758572 764100 767704 770965 772846 776227 778017 782013 783934 785883 787154 788121 790285 793566 796493 798799 799740 800550 802601 802944 811098 812697 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в трусиках и колготка%…"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"в трусик нижн бел колготк"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.