Query Metrics
7
Database Queries
7
Different statements
156.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.68 ms (84.60%) |
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 229704 337190 385073 387365 393855 397155 418553 423192 423550 423953 434422 440164 441563 443493 450139 454472 455165 455491 461783 475177 475302 478709 493021 495363 508265 509189 514048 514234 517695 529699 540132 544048 545303 546620 551485 551914 554862 555672 574060 574469 578535 583547 584501 588618 589487 590041 591596 593988 596943 605176 605180 605924 611760 617509 617672 620940 628596 636062 639670 640827 646052 646719 650082 660569 662394 662925 676576 695158 697219 700930 705705 707457 708052 708194 708254 710541 711327 713473 715441 715952 726974 732204 733995 735581 738892 739947 740959 745964 747239 748035 759921 760301 761012 763444 764220 766600 771120 772026 774080 774610 778410 782594 783671 784780 785962 788828 791531 792390 795918 795998 796158 797191 797231 801101 801547 802806 804882 807582 809583 824031 ] |
||||||||||||||||||||||||||||||
|
13.76 ms (8.78%) |
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 697219 713473 778410 785962 791531 802806 455165 508265 801547 583547 589487 591596 732204 509189 397155 475302 551485 676576 620940 801101 771120 715441 387365 461783 423192 493021 660569 574060 695158 761012 584501 650082 605176 617672 795918 797231 726974 797191 807582 788828 792390 454472 766600 795998 735581 733995 593988 596943 440164 441563 590041 393855 434422 639670 423953 455491 544048 551914 738892 385073 229704 337190 423550 824031 478709 529699 555672 578535 546620 574469 646052 646719 708194 708254 711327 707457 708052 662394 662925 715952 545303 628596 605924 640827 636062 588618 605180 617509 796158 774610 783671 740959 759921 764220 809583 748035 763444 772026 760301 747239 774080 739947 745964 611760 705705 710541 784780 804882 514048 517695 495363 514234 443493 700930 782594 475177 418553 450139 540132 554862 ] |
||||||||||||||||||||||||||||||
|
2.89 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 229704 337190 385073 387365 393855 397155 418553 423192 423550 423953 434422 440164 441563 443493 450139 454472 455165 455491 461783 475177 475302 478709 493021 495363 508265 509189 514048 514234 517695 529699 540132 544048 545303 546620 551485 551914 554862 555672 574060 574469 578535 583547 584501 588618 589487 590041 591596 593988 596943 605176 605180 605924 611760 617509 617672 620940 628596 636062 639670 640827 646052 646719 650082 660569 662394 662925 676576 695158 697219 700930 705705 707457 708052 708194 708254 710541 711327 713473 715441 715952 726974 732204 733995 735581 738892 739947 740959 745964 747239 748035 759921 760301 761012 763444 764220 766600 771120 772026 774080 774610 778410 782594 783671 784780 785962 788828 791531 792390 795918 795998 796158 797191 797231 801101 801547 802806 804882 807582 809583 824031 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass doggystyle"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп doggystyle"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие жоп doggystyle"
]
|
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.