Query Metrics
7
Database Queries
7
Different statements
208.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
182.39 ms (87.45%) |
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 388032 399912 425610 426894 428932 429026 431839 433574 433696 433963 434576 435830 435880 436046 439334 445006 445028 449572 449940 450446 450858 451057 457049 457807 458642 473099 473330 475173 477883 483721 486857 488332 489157 489326 489523 492621 493834 507955 513247 513758 514960 514986 518229 522082 525446 528374 530952 530969 533934 534066 534344 536100 538024 538367 539287 540894 541701 541796 541807 556078 556352 558324 558398 559827 563354 563376 564144 568303 570406 573289 574198 576170 576294 576319 577018 578182 584304 590100 594303 595484 595857 595881 597899 598503 598525 604056 608467 637474 650661 652380 660821 661034 661421 662833 669296 672810 677240 678615 685767 686179 704613 707323 709912 711274 714226 739318 742307 745457 747146 751815 757514 785603 785781 786088 790459 796187 802255 802275 814401 ] |
||||||||||||||||||||||||||||||
|
15.41 ms (7.39%) |
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 449572 492621 530969 507955 536100 538024 539287 493834 556078 563354 650661 709912 662833 704613 707323 595484 608467 590100 594303 802255 786088 757514 742307 745457 785781 475173 436046 431839 450446 541796 399912 435830 473099 449940 457807 534344 488332 556352 563376 576294 559827 574198 584304 678615 660821 672810 685767 652380 661034 669296 686179 570406 595881 598525 785603 428932 425610 426894 513758 534066 486857 489157 489523 541807 445006 439334 814401 458642 477883 522082 525446 528374 533934 530952 540894 558324 568303 577018 558398 564144 573289 541701 576170 672488 677240 661421 711274 576319 578182 597899 598503 595857 604056 637474 790459 802275 751815 747146 739318 714226 796187 434576 429026 433696 433963 435880 451057 457049 388032 433574 445028 450858 473330 514960 513247 514986 538367 518229 483721 489326 ] |
||||||||||||||||||||||||||||||
|
3.62 ms (1.73%) |
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 388032 399912 425610 426894 428932 429026 431839 433574 433696 433963 434576 435830 435880 436046 439334 445006 445028 449572 449940 450446 450858 451057 457049 457807 458642 473099 473330 475173 477883 483721 486857 488332 489157 489326 489523 492621 493834 507955 513247 513758 514960 514986 518229 522082 525446 528374 530952 530969 533934 534066 534344 536100 538024 538367 539287 540894 541701 541796 541807 556078 556352 558324 558398 559827 563354 563376 564144 568303 570406 573289 574198 576170 576294 576319 577018 578182 584304 590100 594303 595484 595857 595881 597899 598503 598525 604056 608467 637474 650661 652380 660821 661034 661421 662833 669296 672810 677240 678615 685767 686179 704613 707323 709912 711274 714226 739318 742307 745457 747146 751815 757514 785603 785781 786088 790459 796187 802255 802275 814401 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"erotic teen pussy"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"эротик teen pussy"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"эротик teen 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.