Query Metrics
7
Database Queries
7
Different statements
216.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
188.39 ms (87.09%) |
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 384804 386253 398713 428399 437761 437959 442164 469900 473268 475010 482333 482444 484253 490461 491082 491387 494676 495257 495898 496123 497054 497652 497654 498345 504853 506316 511725 515825 518553 520987 521447 522293 522584 523938 523953 523962 524510 525951 526659 526740 527711 529298 529864 531154 535058 538119 538583 539300 540233 544056 544116 547429 549175 550650 551201 551710 553331 554251 555434 555756 560178 560273 560746 560768 561191 564481 565450 567235 568983 569135 569153 570764 571065 571077 571864 571933 574659 576724 577074 578132 578865 579717 581035 582722 586331 586424 588896 590447 592457 594505 604278 604424 605218 609318 614133 614260 614365 617025 619012 625382 626145 626154 635752 647109 650031 661280 661889 673101 682625 703547 704351 705712 705770 705781 709938 712672 736153 776426 784440 798748 ] |
||||||||||||||||||||||||||||||
|
12.03 ms (5.56%) |
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 605218 626154 588896 784440 551710 705770 704351 565450 626145 495257 551201 703547 682625 398713 437761 578865 544116 386253 661889 550650 553331 569135 571933 635752 520987 527711 497054 736153 442164 647109 539300 549175 614260 560768 609318 571077 568983 515825 540233 560746 554251 560273 571864 576724 547429 523938 522584 798748 495898 518553 506316 482444 496123 529298 535058 482333 586424 494676 538119 497654 619012 526740 570764 484253 526659 579717 614133 571065 544056 582722 590447 529864 614365 705781 712672 650031 604278 469900 705712 625382 523962 581035 475010 428399 574659 673101 384804 524510 555756 776426 567235 491082 564481 523953 521447 525951 661280 604424 617025 586331 522293 594505 498345 569153 531154 560178 511725 437959 561191 538583 555434 504853 592457 491387 497652 709938 577074 473268 578132 490461 ] |
||||||||||||||||||||||||||||||
|
6.13 ms (2.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
3.37 ms (1.56%) |
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 384804 386253 398713 428399 437761 437959 442164 469900 473268 475010 482333 482444 484253 490461 491082 491387 494676 495257 495898 496123 497054 497652 497654 498345 504853 506316 511725 515825 518553 520987 521447 522293 522584 523938 523953 523962 524510 525951 526659 526740 527711 529298 529864 531154 535058 538119 538583 539300 540233 544056 544116 547429 549175 550650 551201 551710 553331 554251 555434 555756 560178 560273 560746 560768 561191 564481 565450 567235 568983 569135 569153 570764 571065 571077 571864 571933 574659 576724 577074 578132 578865 579717 581035 582722 586331 586424 588896 590447 592457 594505 604278 604424 605218 609318 614133 614260 614365 617025 619012 625382 626145 626154 635752 647109 650031 661280 661889 673101 682625 703547 704351 705712 705770 705781 709938 712672 736153 776426 784440 798748 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс лес"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс лес природ"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс лес природ"
]
|
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.