Query Metrics
7
Database Queries
7
Different statements
157.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.41 ms (84.12%) |
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 41912 110884 117844 118002 391977 392005 392841 393047 401841 402619 402625 410239 414269 415329 420193 420835 428179 428224 429957 435539 439023 439031 439038 441113 441799 444079 445406 447973 449068 452547 454981 456239 460084 462580 471330 478904 483704 486767 487519 497686 502212 505590 506321 506516 506839 507284 508909 509422 511343 512072 512935 514867 514876 515435 517724 519698 521814 530942 531789 531880 534540 534557 534566 540593 547483 547486 547855 549081 550144 550938 559355 559787 571961 575601 576545 576899 576916 576932 576989 581006 581477 586914 587851 590289 600087 610061 615693 618259 618276 630732 641997 658789 660373 660405 660411 660412 666016 668688 669012 669056 669071 671018 671045 672950 680423 686106 689074 713142 717535 736302 744405 745125 745136 752667 770265 782790 786911 799782 800282 825791 ] |
||||||||||||||||||||||||||||||
|
15.82 ms (10.05%) |
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 392005 391977 392841 506516 506839 508909 517724 519698 669012 559787 576916 590289 540593 110884 414269 435539 441799 441113 445406 447973 460084 502212 530942 534566 531789 531880 534557 547486 547483 576932 549081 559355 660405 669071 669056 680423 713142 717535 658789 660411 666016 671018 671045 686106 586914 587851 600087 782790 770265 752667 745125 745136 615693 618276 439023 454981 505590 462580 410239 689074 471330 444079 117844 118002 547855 744405 736302 456239 668688 514867 402619 825791 393047 41912 420835 571961 576989 610061 618259 800282 402625 439038 428179 439031 428224 449068 452547 497686 512072 512935 581006 660412 660373 672950 576545 581477 641997 786911 415329 478904 483704 511343 487519 509422 575601 401841 420193 534540 506321 429957 576899 550144 550938 630732 799782 486767 515435 507284 514876 521814 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.58%) |
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 41912 110884 117844 118002 391977 392005 392841 393047 401841 402619 402625 410239 414269 415329 420193 420835 428179 428224 429957 435539 439023 439031 439038 441113 441799 444079 445406 447973 449068 452547 454981 456239 460084 462580 471330 478904 483704 486767 487519 497686 502212 505590 506321 506516 506839 507284 508909 509422 511343 512072 512935 514867 514876 515435 517724 519698 521814 530942 531789 531880 534540 534557 534566 540593 547483 547486 547855 549081 550144 550938 559355 559787 571961 575601 576545 576899 576916 576932 576989 581006 581477 586914 587851 590289 600087 610061 615693 618259 618276 630732 641997 658789 660373 660405 660411 660412 666016 668688 669012 669056 669071 671018 671045 672950 680423 686106 689074 713142 717535 736302 744405 745125 745136 752667 770265 782790 786911 799782 800282 825791 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fisting wife amateur"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"фистинг жен любительск"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фистинг жен любительск"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.