Query Metrics
7
Database Queries
7
Different statements
158.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.28 ms (82.11%) |
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 81734 382049 383356 393590 395267 396600 397340 400946 403641 405712 406085 406290 406661 410709 414342 415855 416787 417889 427289 429523 429766 429909 432883 433047 438858 443163 443807 445883 448633 456131 458001 460186 464969 468482 468667 470953 474126 474977 476128 478463 489987 490093 493535 497776 499354 505138 509833 513655 514830 515370 518766 522264 524193 529187 530039 530476 530643 530770 530851 531194 531208 531260 531261 532653 532967 533556 534981 535358 536251 536337 536340 536689 537913 537988 540291 543304 545117 549568 550203 554286 559951 567775 568981 598298 599875 600280 601517 601575 606578 620244 628094 629333 633458 633521 634122 634556 639731 639784 640800 642000 647939 648838 649583 653487 660696 666355 666859 673035 681686 704526 704529 705817 720720 721103 724330 726864 728930 740251 784152 806324 ] |
||||||||||||||||||||||||||||||
|
19.18 ms (12.09%) |
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 673035 705817 721103 649583 666859 666355 545117 600280 628094 598298 601575 740251 726864 724330 448633 395267 474977 406290 489987 522264 383356 400946 403641 406661 415855 416787 414342 429909 427289 429523 429766 443807 445883 456131 458001 464969 474126 460186 478463 505138 530643 549568 568981 653487 660696 567775 620244 438858 382049 432883 397340 470953 468667 509833 490093 499354 513655 518766 524193 497776 515370 529187 536251 536689 647939 554286 639784 599875 633458 543304 410709 81734 393590 396600 405712 406085 443163 417889 493535 468482 476128 530039 531208 531260 536340 540291 532967 533556 534981 535358 536337 530476 530770 531261 537913 514830 530851 531194 532653 537988 550203 681686 704526 720720 648838 559951 629333 642000 634122 640800 601517 634556 784152 728930 606578 633521 639731 704529 806324 433047 ] |
||||||||||||||||||||||||||||||
|
2.20 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 81734 382049 383356 393590 395267 396600 397340 400946 403641 405712 406085 406290 406661 410709 414342 415855 416787 417889 427289 429523 429766 429909 432883 433047 438858 443163 443807 445883 448633 456131 458001 460186 464969 468482 468667 470953 474126 474977 476128 478463 489987 490093 493535 497776 499354 505138 509833 513655 514830 515370 518766 522264 524193 529187 530039 530476 530643 530770 530851 531194 531208 531260 531261 532653 532967 533556 534981 535358 536251 536337 536340 536689 537913 537988 540291 543304 545117 549568 550203 554286 559951 567775 568981 598298 599875 600280 601517 601575 606578 620244 628094 629333 633458 633521 634122 634556 639731 639784 640800 642000 647939 648838 649583 653487 660696 666355 666859 673035 681686 704526 704529 705817 720720 721103 724330 726864 728930 740251 784152 806324 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"biggest cock anal"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные cock анал"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.89%) |
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.