Query Metrics
7
Database Queries
7
Different statements
369.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.81 ms (55.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature in pantyhose"
]
|
||||||||||||||||||||||||||||||
|
140.94 ms (38.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 14477 148793 187443 233710 276696 362787 365881 383073 385880 387422 388200 390206 390252 390290 392673 396970 397859 397868 397898 405494 407863 411347 411907 428823 451472 452230 457631 465456 465822 465895 466023 466919 469455 474486 480466 480557 482328 483260 490932 491960 491977 496781 504029 504060 510925 512515 522413 530438 530674 530679 539487 541618 545431 546929 548052 550591 557606 558073 560383 560397 561483 562603 562976 563135 563157 563204 566197 566662 573347 578814 580025 583564 586547 596432 599202 604806 605147 606066 606285 620014 624792 642001 663882 667849 669073 697232 703448 715423 721470 722281 725165 731756 731816 735859 736047 736263 740792 741896 741904 745007 748246 757982 770116 777250 781714 782262 788773 794219 796807 800454 800573 810056 810461 811060 811957 812504 813835 817160 819237 820229 ] |
||||||||||||||||||||||||||||||
|
15.86 ms (4.29%) |
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 480557 820229 530438 722281 757982 811060 387422 388200 703448 560397 392673 800573 812504 735859 428823 390206 810461 405494 465456 469455 580025 697232 558073 606066 624792 794219 796807 741896 14477 530679 781714 782262 810056 731756 788773 397898 482328 411907 777250 741904 491960 491977 512515 362787 390290 465895 385880 817160 483260 510925 504029 466919 550591 583564 605147 606285 811957 736263 480466 383073 187443 819237 539487 530674 669073 715423 721470 667849 620014 596432 599202 748246 770116 745007 736047 233710 390252 452230 466023 560383 396970 578814 465822 451472 813835 474486 562976 541618 566662 546929 725165 642001 397868 397859 365881 407863 504060 496781 522413 562603 545431 566197 573347 561483 563204 663882 548052 557606 563135 563157 604806 586547 800454 731816 148793 457631 490932 740792 411347 276696 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (0.82%) |
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 14477 148793 187443 233710 276696 362787 365881 383073 385880 387422 388200 390206 390252 390290 392673 396970 397859 397868 397898 405494 407863 411347 411907 428823 451472 452230 457631 465456 465822 465895 466023 466919 469455 474486 480466 480557 482328 483260 490932 491960 491977 496781 504029 504060 510925 512515 522413 530438 530674 530679 539487 541618 545431 546929 548052 550591 557606 558073 560383 560397 561483 562603 562976 563135 563157 563204 566197 566662 573347 578814 580025 583564 586547 596432 599202 604806 605147 606066 606285 620014 624792 642001 663882 667849 669073 697232 703448 715423 721470 722281 725165 731756 731816 735859 736047 736263 740792 741896 741904 745007 748246 757982 770116 777250 781714 782262 788773 794219 796807 800454 800573 810056 810461 811060 811957 812504 813835 817160 819237 820229 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature pantyhose"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature pantyhose"
]
|
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.