Query Metrics
7
Database Queries
7
Different statements
203.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.60 ms (85.51%) |
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 412925 420125 420203 420267 421234 422208 428116 430314 434209 439518 441952 443636 447810 447896 451866 452535 454107 465731 467867 469595 470774 473791 475833 475927 478090 486217 486685 487746 490684 495400 496603 497866 497921 500375 503405 505132 506500 508565 509879 510396 511812 512059 515420 517005 518599 519390 519561 522157 522871 522917 522976 524018 524712 525731 525864 526047 526891 528682 529794 530010 530275 530377 530495 530659 530703 530808 531097 532655 532680 532762 533844 534645 534988 535023 535025 535084 536586 537114 537241 537584 537595 540437 541872 543552 543652 543840 543848 543856 544627 559111 559142 560924 561136 565909 568480 569927 576219 578411 580290 585954 587970 590505 593863 596082 596851 599835 600014 609958 613508 617418 630552 632680 634138 639706 641949 648241 648252 652544 758915 784304 ] |
||||||||||||||||||||||||||||||
|
19.70 ms (9.70%) |
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 486217 530010 537241 496603 536586 541872 648252 587970 617418 639706 596082 613508 641949 475927 475833 515420 522917 434209 543856 585954 758915 412925 428116 420203 522157 526891 535084 561136 593863 422208 511812 497866 420125 503405 534988 519390 531097 537114 544627 652544 596851 543848 525731 469595 543652 599835 497921 543552 490684 420267 443636 478090 535023 537595 533844 580290 576219 430314 454107 535025 537584 559142 568480 632680 634138 421234 509879 522871 473791 451866 532655 560924 609958 447810 530703 519561 530495 578411 439518 526047 524712 532680 505132 510396 524018 530808 447896 486685 487746 530275 528682 532762 559111 470774 452535 525864 512059 530377 540437 530659 648241 630552 467867 518599 529794 441952 465731 569927 784304 590505 500375 600014 565909 534645 517005 495400 506500 522976 543840 508565 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (1.61%) |
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 412925 420125 420203 420267 421234 422208 428116 430314 434209 439518 441952 443636 447810 447896 451866 452535 454107 465731 467867 469595 470774 473791 475833 475927 478090 486217 486685 487746 490684 495400 496603 497866 497921 500375 503405 505132 506500 508565 509879 510396 511812 512059 515420 517005 518599 519390 519561 522157 522871 522917 522976 524018 524712 525731 525864 526047 526891 528682 529794 530010 530275 530377 530495 530659 530703 530808 531097 532655 532680 532762 533844 534645 534988 535023 535025 535084 536586 537114 537241 537584 537595 540437 541872 543552 543652 543840 543848 543856 544627 559111 559142 560924 561136 565909 568480 569927 576219 578411 580290 585954 587970 590505 593863 596082 596851 599835 600014 609958 613508 617418 630552 632680 634138 639706 641949 648241 648252 652544 758915 784304 ] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf bdsm anal"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf бдсм анал"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf бдсм анал"
]
|
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.