Query Metrics
7
Database Queries
7
Different statements
207.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
182.81 ms (87.94%) |
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 302443 384108 384128 390082 396646 400638 401616 413090 414975 420311 422865 423934 423974 425904 428154 428750 442038 443985 447761 448819 449012 449230 451657 452711 454320 454633 454835 456707 459419 459794 460297 463248 465713 471764 472297 474858 476344 477131 477357 481499 481897 481935 486810 488889 490310 493615 495027 497484 498795 500789 501247 506782 508743 512162 513228 514392 515666 515798 516286 517881 518053 521915 522468 522653 522701 523678 524147 524566 525645 525904 525995 527842 528781 528784 536497 542097 542280 543404 543567 547929 548753 551637 557669 559601 560492 561694 561713 561910 562699 566997 568679 572775 574868 575745 584172 584745 595770 595870 599140 601498 603192 609815 619071 619775 652219 653142 670279 684547 697314 704525 713834 736225 747966 757427 770123 770245 788269 796248 814554 822046 ] |
||||||||||||||||||||||||||||||
|
15.83 ms (7.61%) |
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 551637 559601 584745 557669 561713 575745 796248 414975 428750 459794 465713 514392 495027 501247 384128 490310 459419 486810 522701 574868 542280 562699 599140 747966 302443 428154 525645 493615 524566 508743 516286 528781 443985 456707 488889 525904 568679 542097 697314 566997 609815 601498 619071 770123 757427 713834 477131 454320 420311 515666 472297 653142 684547 400638 481499 547929 595870 603192 463248 454835 515798 524147 523678 390082 536497 500789 527842 396646 525995 652219 595770 770245 452711 528784 814554 448819 460297 451657 497484 548753 788269 447761 449230 423974 512162 518053 521915 543404 704525 736225 425904 454633 476344 522468 506782 822046 474858 449012 481897 481935 543567 561694 572775 561910 670279 619775 423934 477357 413090 498795 513228 517881 384108 401616 442038 422865 471764 522653 584172 560492 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.43%) |
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 302443 384108 384128 390082 396646 400638 401616 413090 414975 420311 422865 423934 423974 425904 428154 428750 442038 443985 447761 448819 449012 449230 451657 452711 454320 454633 454835 456707 459419 459794 460297 463248 465713 471764 472297 474858 476344 477131 477357 481499 481897 481935 486810 488889 490310 493615 495027 497484 498795 500789 501247 506782 508743 512162 513228 514392 515666 515798 516286 517881 518053 521915 522468 522653 522701 523678 524147 524566 525645 525904 525995 527842 528781 528784 536497 542097 542280 543404 543567 547929 548753 551637 557669 559601 560492 561694 561713 561910 562699 566997 568679 572775 574868 575745 584172 584745 595770 595870 599140 601498 603192 609815 619071 619775 652219 653142 670279 684547 697314 704525 713834 736225 747966 757427 770123 770245 788269 796248 814554 822046 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex fun"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.69%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс fun"
]
|
||||||||||||||||||||||||||||||
|
1.28 ms (0.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс fun"
]
|
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.