Query Metrics
7
Database Queries
7
Different statements
154.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.65 ms (84.79%) |
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 53992 383338 385965 387268 405894 407156 410811 411182 413289 421318 427447 431484 432687 435726 443550 443600 445252 446476 446870 458327 471628 483708 485576 486759 496361 499688 500565 501252 505384 508485 508769 511927 515891 517857 519769 519907 523326 525176 525178 528772 529854 534985 539886 539938 539942 540190 543510 550637 550717 550778 551984 552008 552025 552041 554141 554419 556607 557228 557518 558377 559645 560154 562808 564794 565481 566849 573566 575680 577045 577059 583267 586627 596856 601664 603294 605380 622137 623813 638811 640697 643146 643447 645643 646246 711838 718985 720943 724244 726641 726811 734345 734788 736999 742472 744249 747984 748119 748631 748674 748679 752770 754954 759782 771698 780196 783995 793645 796348 798527 800231 808754 809671 811784 816834 816844 816855 817847 820780 820982 826101 ] |
||||||||||||||||||||||||||||||
|
14.27 ms (9.26%) |
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 605380 586627 808754 747984 759782 720943 53992 446870 445252 483708 505384 501252 523326 427447 458327 515891 519907 623813 816844 816855 816834 820982 826101 543510 559645 711838 645643 780196 734788 809671 726811 742472 771698 748119 754954 811784 471628 550778 596856 421318 529854 539938 534985 486759 565481 640697 407156 411182 443550 443600 517857 519769 485576 508485 508769 385965 817847 540190 528772 539886 499688 552025 564794 577045 557228 718985 575680 577059 638811 643146 643447 622137 783995 796348 800231 798527 748631 744249 748674 748679 724244 726641 736999 752770 793645 413289 432687 560154 646246 601664 603294 734345 383338 387268 405894 410811 431484 435726 820780 446476 511927 525178 496361 525176 539942 500565 551984 552041 554141 554419 562808 550637 556607 558377 550717 552008 557518 566849 573566 583267 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.54%) |
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 53992 383338 385965 387268 405894 407156 410811 411182 413289 421318 427447 431484 432687 435726 443550 443600 445252 446476 446870 458327 471628 483708 485576 486759 496361 499688 500565 501252 505384 508485 508769 511927 515891 517857 519769 519907 523326 525176 525178 528772 529854 534985 539886 539938 539942 540190 543510 550637 550717 550778 551984 552008 552025 552041 554141 554419 556607 557228 557518 558377 559645 560154 562808 564794 565481 566849 573566 575680 577045 577059 583267 586627 596856 601664 603294 605380 622137 623813 638811 640697 643146 643447 645643 646246 711838 718985 720943 724244 726641 726811 734345 734788 736999 742472 744249 747984 748119 748631 748674 748679 752770 754954 759782 771698 780196 783995 793645 796348 798527 800231 808754 809671 811784 816834 816844 816855 817847 820780 820982 826101 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк pussy"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian pussy"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"азиатк 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.