Query Metrics
7
Database Queries
7
Different statements
184.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.88 ms (87.19%) |
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 399192 400162 402793 409936 410352 415004 415388 418268 419860 420280 421045 421094 421310 425173 428494 429255 429541 430548 430787 434933 444168 449323 458699 460622 462824 463990 467003 468054 468154 469263 469434 479826 481877 489461 490831 493180 501177 507123 509861 510043 511520 512830 513657 519316 527755 528361 529213 530846 534301 537906 540186 541561 541919 546465 547733 556050 556741 558680 560192 561107 570179 575705 577290 584602 589543 590344 594788 598414 598642 599664 606578 619189 624838 624909 636280 640758 645293 646776 649991 650114 650476 654636 661268 661891 661974 682902 718698 720262 730091 733589 734038 736046 737197 742834 744649 748264 750299 764491 776621 782775 786509 788196 788788 788911 789977 792343 793926 801296 804464 806021 809935 810986 810995 811994 812429 813568 815232 816007 818156 826874 ] |
||||||||||||||||||||||||||||||
|
14.63 ms (7.93%) |
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 541561 558680 654636 682902 650114 661891 598414 619189 636280 786509 792343 806021 811994 788911 789977 801296 736046 737197 764491 810995 742834 776621 809935 469263 463990 444168 458699 513657 577290 468054 530846 575705 556050 813568 816007 818156 469434 490831 537906 547733 570179 718698 546465 624909 734038 462824 415004 421045 425173 804464 556741 815232 449323 793926 493180 507123 560192 529213 812429 782775 661268 561107 584602 528361 421094 429255 430548 410352 527755 541919 650476 646776 640758 589543 606578 415388 479826 419860 428494 420280 421310 429541 409936 430787 826874 481877 467003 509861 519316 510043 534301 540186 468154 661974 645293 649991 720262 599664 624838 594788 590344 598642 788196 788788 748264 750299 730091 733589 744649 810986 400162 460622 399192 402793 434933 511520 489461 512830 501177 418268 ] |
||||||||||||||||||||||||||||||
|
2.97 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 399192 400162 402793 409936 410352 415004 415388 418268 419860 420280 421045 421094 421310 425173 428494 429255 429541 430548 430787 434933 444168 449323 458699 460622 462824 463990 467003 468054 468154 469263 469434 479826 481877 489461 490831 493180 501177 507123 509861 510043 511520 512830 513657 519316 527755 528361 529213 530846 534301 537906 540186 541561 541919 546465 547733 556050 556741 558680 560192 561107 570179 575705 577290 584602 589543 590344 594788 598414 598642 599664 606578 619189 624838 624909 636280 640758 645293 646776 649991 650114 650476 654636 661268 661891 661974 682902 718698 720262 730091 733589 734038 736046 737197 742834 744649 748264 750299 764491 776621 782775 786509 788196 788788 788911 789977 792343 793926 801296 804464 806021 809935 810986 810995 811994 812429 813568 815232 816007 818156 826874 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"licking pussy squirt"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.35 ms (0.73%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза pussy сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.29 ms (0.70%) |
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.