Query Metrics
7
Database Queries
7
Different statements
175.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.69 ms (85.76%) |
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 154491 188560 382304 397509 401768 402628 410305 412721 414099 414253 414595 415863 415958 416174 419970 420171 420625 424195 428728 428750 431439 438543 439027 439343 439353 441070 446016 450373 454590 459472 467114 467584 467636 471131 475504 476053 479148 480255 480258 483523 485661 498473 506115 509436 522639 523884 529617 530402 531834 531877 532634 534545 534563 536129 540868 545459 561019 564271 564518 572778 574377 584337 584425 596632 602136 608664 608711 620486 703668 712236 717660 736037 739127 739798 742715 745359 746191 748490 748497 748499 749134 749958 750998 754628 756785 759052 759335 760195 760563 761265 772213 773666 779263 780309 781424 783016 783600 785075 790192 794316 796692 796709 797035 797039 798593 800322 800649 804035 806139 806455 806828 807110 807570 807616 807642 809660 811330 811714 812275 826507 ] |
||||||||||||||||||||||||||||||
|
15.80 ms (8.99%) |
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 800322 807110 807570 811714 790192 796692 797035 798593 800649 804035 748499 759052 760195 761265 781424 783016 783600 785075 807616 809660 811330 812275 736037 739127 748490 748497 750998 772213 742715 746191 756785 739798 745359 749958 759335 760563 749134 754628 773666 608664 608711 620486 703668 712236 717660 779263 780309 794316 796709 797039 806139 806828 807642 826507 439343 428728 415863 415958 439027 419970 441070 450373 467114 471131 498473 572778 584337 596632 602136 806455 397509 424195 438543 439353 459472 479148 428750 420171 420625 509436 483523 523884 154491 188560 382304 402628 401768 412721 431439 410305 416174 414595 414099 414253 540868 480255 485661 446016 454590 467584 480258 534545 531834 531877 532634 529617 534563 536129 506115 522639 530402 467636 475504 476053 574377 584425 545459 561019 564271 564518 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.55%) |
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 154491 188560 382304 397509 401768 402628 410305 412721 414099 414253 414595 415863 415958 416174 419970 420171 420625 424195 428728 428750 431439 438543 439027 439343 439353 441070 446016 450373 454590 459472 467114 467584 467636 471131 475504 476053 479148 480255 480258 483523 485661 498473 506115 509436 522639 523884 529617 530402 531834 531877 532634 534545 534563 536129 540868 545459 561019 564271 564518 572778 574377 584337 584425 596632 602136 608664 608711 620486 703668 712236 717660 736037 739127 739798 742715 745359 746191 748490 748497 748499 749134 749958 750998 754628 756785 759052 759335 760195 760563 761265 772213 773666 779263 780309 781424 783016 783600 785075 790192 794316 796692 796709 797035 797039 798593 800322 800649 804035 806139 806455 806828 807110 807570 807616 807642 809660 811330 811714 812275 826507 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"веб-камера дилдо"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер дилд"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.29 ms (0.73%) |
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.