Query Metrics
7
Database Queries
7
Different statements
162.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.71 ms (78.97%) |
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 31492 159305 382959 383856 389060 407759 409352 415780 418080 422144 422347 424448 433240 440838 443697 443827 443918 446515 450108 453112 453491 454194 454280 457605 457782 458730 461688 462290 465962 466063 466279 466341 467075 467240 468096 470041 470613 471340 472703 473246 473334 474433 474710 475874 476630 479145 479148 479668 483382 485689 488363 490644 494204 495518 496871 502199 503580 505640 509590 511570 513341 515078 516466 516478 517397 517535 518579 519073 522961 523824 525878 528596 529346 531070 535439 545972 547987 549728 549772 554463 558295 563220 566356 568100 568603 569426 582321 585035 641652 664846 681168 683284 683288 693208 709528 710510 718861 720621 727863 733078 746598 753667 763914 776320 778524 780634 780673 781746 781929 786371 787557 794226 794704 796459 796920 797245 799357 800337 805923 814369 ] |
||||||||||||||||||||||||||||||
|
21.66 ms (13.29%) |
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 422144 529346 683288 805923 794704 753667 443918 453491 465962 566356 450108 476630 495518 511570 474710 31492 389060 409352 681168 797245 475874 466063 523824 531070 509590 585035 461688 473334 485689 505640 517535 473246 545972 568603 558295 582321 547987 568100 569426 549772 467240 479148 466341 471340 407759 454280 470613 502199 522961 513341 518579 528596 494204 517397 515078 718861 641652 780673 796459 733078 746598 778524 781929 794226 383856 418080 814369 683284 709528 664846 693208 781746 786371 727863 763914 787557 796920 800337 446515 453112 458730 503580 467075 549728 563220 443827 462290 474433 433240 443697 470041 479145 422347 457782 466279 454194 516466 516478 483382 519073 496871 490644 535439 415780 440838 479668 488363 159305 424448 525878 382959 468096 472703 457605 554463 710510 720621 776320 780634 799357 ] |
||||||||||||||||||||||||||||||
|
3.41 ms (2.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"обвисшая зрелая женщин порн"
]
|
||||||||||||||||||||||||||||||
|
2.77 ms (1.70%) |
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 31492 159305 382959 383856 389060 407759 409352 415780 418080 422144 422347 424448 433240 440838 443697 443827 443918 446515 450108 453112 453491 454194 454280 457605 457782 458730 461688 462290 465962 466063 466279 466341 467075 467240 468096 470041 470613 471340 472703 473246 473334 474433 474710 475874 476630 479145 479148 479668 483382 485689 488363 490644 494204 495518 496871 502199 503580 505640 509590 511570 513341 515078 516466 516478 517397 517535 518579 519073 522961 523824 525878 528596 529346 531070 535439 545972 547987 549728 549772 554463 558295 563220 566356 568100 568603 569426 582321 585035 641652 664846 681168 683284 683288 693208 709528 710510 718861 720621 727863 733078 746598 753667 763914 776320 778524 780634 780673 781746 781929 786371 787557 794226 794704 796459 796920 797245 799357 800337 805923 814369 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"обвисшая зрелая женщин порн"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð▓ð©ÐüÐÅÐçð©ðÁ Ðâ ðÀÐÇðÁð╗ÐïÐà ð┐ð¥ÐÇð¢ðÔǪ"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.