Query Metrics
7
Database Queries
7
Different statements
145.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.65 ms (84.47%) |
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 388097 388308 404369 413826 415303 415874 418112 421052 426026 426283 431960 434324 435136 441355 441985 443260 443323 443432 443773 444283 445211 448851 450557 451044 453408 456666 460911 462319 466601 467196 467588 467605 467875 474800 475420 476296 481952 484699 491299 497896 498294 499789 501611 514230 515564 522363 527916 531115 531118 533064 536359 540032 542595 544473 550298 550817 551693 552272 553210 555008 556745 556753 556877 556882 559281 559784 565539 567323 568561 576230 580190 584783 590476 595016 597964 600498 601604 602056 603386 607355 613508 635993 638576 639710 639732 639802 640442 642037 642687 642742 643098 645263 647885 647895 647969 650476 651188 666589 666672 678556 683054 688581 696216 698496 699627 709128 715574 730461 734829 735132 749885 770248 771935 772439 786008 788788 796370 798243 814289 814394 ] |
||||||||||||||||||||||||||||||
|
13.73 ms (9.45%) |
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 466601 555008 565539 567323 576230 542595 544473 650476 666589 696216 678556 683054 688581 647885 651188 638576 639802 603386 613508 607355 443773 415874 474800 462319 426283 460911 453408 497896 484699 501611 522363 527916 536359 531118 533064 643098 426026 550298 814394 388308 418112 415303 435136 441355 441985 443260 443432 444283 467196 450557 451044 456666 475420 540032 499789 514230 515564 550817 584783 556882 559784 559281 568561 666672 699627 556877 590476 595016 597964 601604 635993 642742 600498 639710 788788 798243 730461 735132 709128 421052 434324 448851 467588 467875 431960 481952 445211 491299 498294 476296 551693 556745 786008 772439 796370 749885 771935 443323 413826 639732 642037 552272 647895 467605 814289 556753 553210 602056 388097 404369 531115 647969 580190 640442 770248 734829 698496 715574 642687 645263 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.57%) |
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 388097 388308 404369 413826 415303 415874 418112 421052 426026 426283 431960 434324 435136 441355 441985 443260 443323 443432 443773 444283 445211 448851 450557 451044 453408 456666 460911 462319 466601 467196 467588 467605 467875 474800 475420 476296 481952 484699 491299 497896 498294 499789 501611 514230 515564 522363 527916 531115 531118 533064 536359 540032 542595 544473 550298 550817 551693 552272 553210 555008 556745 556753 556877 556882 559281 559784 565539 567323 568561 576230 580190 584783 590476 595016 597964 600498 601604 602056 603386 607355 613508 635993 638576 639710 639732 639802 640442 642037 642687 642742 643098 645263 647885 647895 647969 650476 651188 666589 666672 678556 683054 688581 696216 698496 699627 709128 715574 730461 734829 735132 749885 770248 771935 772439 786008 788788 796370 798243 814289 814394 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"extreme gape pussy"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хардкор большая большие дырк pussy"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"хардкор большая большие дырк pussy"
]
|
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.