Query Metrics
7
Database Queries
7
Different statements
241.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.87 ms (88.68%) |
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 388219 391450 414339 414341 414344 414372 416303 421146 422049 427966 428412 429088 429768 429804 432243 434642 436042 437470 437855 443334 443364 443389 443777 445735 446337 453095 453329 462079 474648 474685 474693 474694 474695 476288 476291 480299 482514 483544 499718 501611 506259 515226 517788 520224 522886 524183 525626 526130 526891 530015 531126 533382 535620 536586 537771 537894 541846 545383 554409 562823 562828 568573 580290 581349 581726 586770 589240 590935 592034 600503 601106 603204 606508 609812 613146 617416 617428 622973 624505 628396 629874 630297 631193 631209 632580 632639 632657 632695 633782 635614 636299 637032 637100 642025 642041 646904 647638 649545 666546 666549 666881 666883 670113 676025 676087 676101 677293 678066 679826 680255 702677 716887 767162 775792 775913 790965 800588 801960 811497 823942 ] |
||||||||||||||||||||||||||||||
|
17.64 ms (7.32%) |
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 775913 437855 526130 525626 562823 666546 666883 606508 613146 636299 642041 811497 437470 429088 443389 432243 414339 427966 429804 443364 480299 482514 445735 446337 537771 536586 530015 535620 476288 545383 562828 568573 581726 666881 670113 676101 676025 646904 647638 649545 666549 677293 678066 609812 624505 632695 637032 801960 617416 631193 633782 391450 416303 428412 434642 421146 453095 474648 474694 414372 436042 474685 474695 520224 506259 501611 515226 517788 524183 453329 590935 790965 775792 622973 635614 823942 601106 767162 629874 522886 702677 592034 642025 628396 631209 474693 603204 388219 422049 414341 414344 429768 483544 476291 533382 531126 537894 499718 526891 554409 580290 541846 581349 676087 679826 680255 586770 630297 632580 632657 600503 589240 637100 800588 617428 632639 716887 443334 462079 443777 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.08%) |
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 388219 391450 414339 414341 414344 414372 416303 421146 422049 427966 428412 429088 429768 429804 432243 434642 436042 437470 437855 443334 443364 443389 443777 445735 446337 453095 453329 462079 474648 474685 474693 474694 474695 476288 476291 480299 482514 483544 499718 501611 506259 515226 517788 520224 522886 524183 525626 526130 526891 530015 531126 533382 535620 536586 537771 537894 541846 545383 554409 562823 562828 568573 580290 581349 581726 586770 589240 590935 592034 600503 601106 603204 606508 609812 613146 617416 617428 622973 624505 628396 629874 630297 631193 631209 632580 632639 632657 632695 633782 635614 636299 637032 637100 642025 642041 646904 647638 649545 666546 666549 666881 666883 670113 676025 676087 676101 677293 678066 679826 680255 702677 716887 767162 775792 775913 790965 800588 801960 811497 823942 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"gangbang sperm"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.69%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"gangbang сперм"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"gangbang сперм"
]
|
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.