Query Metrics
7
Database Queries
7
Different statements
163.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.62 ms (84.20%) |
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 396073 402784 414769 418596 419387 419475 420351 420352 421043 426416 427289 430476 432574 432639 432662 433391 435162 435917 441203 441616 441952 446026 446031 446038 446811 446964 447722 449180 451430 453494 456600 464006 465449 465688 469560 475329 475752 476082 479788 481878 482223 482227 482768 492495 495686 496615 503274 510926 514214 517049 517528 517779 517843 518243 518747 519760 521132 525045 525055 527091 527405 528077 528702 531840 534823 535417 539030 544659 550902 568289 577340 582016 583238 588144 589069 589074 589106 589200 589591 597753 601423 603051 626362 628641 637085 648539 656515 660464 720343 724921 727229 736564 742817 742865 742887 742896 747193 757072 761028 761366 767022 767025 767275 769964 770729 784756 790844 791233 791351 794338 798345 802868 803620 804587 804708 812704 817203 817384 824049 828281 ] |
||||||||||||||||||||||||||||||
|
16.39 ms (10.03%) |
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 475752 637085 628641 597753 812704 736564 767025 482223 761028 784756 396073 427289 435162 447722 451430 527091 517528 525055 469560 589074 589069 421043 804708 791351 430476 525045 492495 769964 757072 770729 433391 481878 449180 446026 503274 495686 496615 521132 514214 446811 420352 767022 456600 656515 603051 742865 742896 441952 544659 828281 510926 539030 804587 727229 464006 475329 720343 802868 432662 432639 482768 518747 601423 420351 402784 432574 482227 446031 583238 724921 817384 803620 794338 577340 660464 582016 589106 589200 790844 742817 518243 527405 588144 435917 441203 418596 419387 479788 528077 817203 761366 568289 531840 550902 517779 535417 517843 742887 824049 626362 798345 747193 426416 519760 414769 465688 453494 528702 589591 441616 534823 476082 648539 767275 419475 446038 465449 446964 791233 517049 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.62%) |
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 396073 402784 414769 418596 419387 419475 420351 420352 421043 426416 427289 430476 432574 432639 432662 433391 435162 435917 441203 441616 441952 446026 446031 446038 446811 446964 447722 449180 451430 453494 456600 464006 465449 465688 469560 475329 475752 476082 479788 481878 482223 482227 482768 492495 495686 496615 503274 510926 514214 517049 517528 517779 517843 518243 518747 519760 521132 525045 525055 527091 527405 528077 528702 531840 534823 535417 539030 544659 550902 568289 577340 582016 583238 588144 589069 589074 589106 589200 589591 597753 601423 603051 626362 628641 637085 648539 656515 660464 720343 724921 727229 736564 742817 742865 742887 742896 747193 757072 761028 761366 767022 767025 767275 769964 770729 784756 790844 791233 791351 794338 798345 802868 803620 804587 804708 812704 817203 817384 824049 828281 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina anal wife"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"латинская анал жен"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская анал жен"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.96%) |
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.