Query Metrics
7
Database Queries
7
Different statements
285.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
256.56 ms (89.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 396818 397526 415822 417008 424191 424292 430562 432650 437784 439791 439808 440889 442400 443292 448069 449950 450812 453454 453497 455380 457183 457409 457804 457861 462588 463221 464207 464837 468876 468984 471493 472858 475893 479959 481461 481926 485407 490178 491089 492222 492705 493110 493539 494833 502791 503943 504000 506209 506432 507499 509179 509192 509627 510608 515575 518536 520700 522494 524180 524359 525750 528858 530481 533801 534604 535546 537777 542090 543143 549827 550688 552361 553205 556247 556816 557924 558224 558819 560438 565626 565713 565756 565986 568096 579471 581354 584200 584244 590622 599178 604978 606032 617732 621676 653096 662405 667352 668969 707464 711761 713630 719112 725568 727038 746525 758174 760700 761781 765322 769536 772763 785499 790460 795123 796096 801068 802091 802778 807208 816073 ] |
||||||||||||||||||||||||||||||
|
19.03 ms (6.67%) |
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 796096 802091 802778 760700 761781 807208 769536 758174 765322 772763 725568 727038 746525 604978 617732 711761 719112 785499 790460 795123 801068 457409 462588 475893 417008 455380 424292 471493 479959 481461 430562 457804 468984 415822 424191 453497 481926 502791 503943 524180 490178 492222 509627 506209 506432 507499 509192 485407 491089 493539 518536 524359 528858 565626 443292 439791 439808 504000 520700 492705 396818 397526 437784 440889 442400 432650 816073 449950 453454 457861 463221 464207 448069 450812 457183 468876 494833 530481 533801 535546 525750 510608 515575 522494 509179 534604 537777 464837 472858 493110 542090 550688 557924 558224 558819 560438 565756 565986 584244 543143 552361 556247 565713 549827 553205 579471 653096 662405 667352 668969 707464 713630 556816 568096 581354 584200 606032 590622 599178 621676 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (0.89%) |
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 396818 397526 415822 417008 424191 424292 430562 432650 437784 439791 439808 440889 442400 443292 448069 449950 450812 453454 453497 455380 457183 457409 457804 457861 462588 463221 464207 464837 468876 468984 471493 472858 475893 479959 481461 481926 485407 490178 491089 492222 492705 493110 493539 494833 502791 503943 504000 506209 506432 507499 509179 509192 509627 510608 515575 518536 520700 522494 524180 524359 525750 528858 530481 533801 534604 535546 537777 542090 543143 549827 550688 552361 553205 556247 556816 557924 558224 558819 560438 565626 565713 565756 565986 568096 579471 581354 584200 584244 590622 599178 604978 606032 617732 621676 653096 662405 667352 668969 707464 711761 713630 719112 725568 727038 746525 758174 760700 761781 765322 769536 772763 785499 790460 795123 796096 801068 802091 802778 807208 816073 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf home"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.64%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf home"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.62%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf home"
]
|
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.