Query Metrics
7
Database Queries
7
Different statements
213.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
184.91 ms (86.41%) |
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 412539 412618 417493 418099 424873 427622 429885 433669 435634 439742 441447 442363 444303 446435 448440 448512 451664 452272 455685 456553 457203 465771 466757 469019 469649 473258 480087 483417 484343 485179 486740 490015 492134 492229 492466 494036 494920 495283 497026 497818 502594 502976 503752 504162 504411 504765 507582 508168 508245 508441 511242 511777 514025 514653 514782 516308 516417 516876 518240 520628 521353 521489 521516 522230 523215 523451 525142 525298 527130 528592 538027 545622 548254 553485 554399 557091 558338 561298 561468 563312 567187 567188 570878 579899 585318 586591 586594 588953 590599 593778 608242 609746 611416 617205 620071 620100 621228 621352 622408 623616 623618 623620 624127 625547 625556 663259 668472 682252 703268 715898 717167 718901 731279 735010 737228 747968 776788 784107 795780 796128 ] |
||||||||||||||||||||||||||||||
|
19.13 ms (8.94%) |
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 516417 484343 485179 497818 502976 507582 735010 731279 668472 523451 579899 747968 417493 448440 527130 518240 561468 557091 593778 451664 456553 525298 514025 486740 497026 776788 715898 441447 452272 492134 522230 508168 511777 625547 620071 429885 466757 444303 427622 508245 492466 795780 561298 623616 570878 567187 448512 424873 494920 784107 490015 495283 525142 545622 624127 528592 502594 521516 503752 586594 439742 492229 504411 548254 663259 457203 554399 623620 473258 521353 718901 567188 514653 520628 558338 625556 586591 585318 511242 538027 455685 504162 621352 563312 622408 480087 609746 469019 504765 521489 483417 494036 620100 796128 703268 608242 737228 682252 412539 523215 717167 623618 433669 418099 508441 590599 611416 469649 446435 435634 412618 442363 465771 516308 553485 588953 621228 516876 617205 514782 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.16%) |
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 412539 412618 417493 418099 424873 427622 429885 433669 435634 439742 441447 442363 444303 446435 448440 448512 451664 452272 455685 456553 457203 465771 466757 469019 469649 473258 480087 483417 484343 485179 486740 490015 492134 492229 492466 494036 494920 495283 497026 497818 502594 502976 503752 504162 504411 504765 507582 508168 508245 508441 511242 511777 514025 514653 514782 516308 516417 516876 518240 520628 521353 521489 521516 522230 523215 523451 525142 525298 527130 528592 538027 545622 548254 553485 554399 557091 558338 561298 561468 563312 567187 567188 570878 579899 585318 586591 586594 588953 590599 593778 608242 609746 611416 617205 620071 620100 621228 621352 622408 623616 623618 623620 624127 625547 625556 663259 668472 682252 703268 715898 717167 718901 731279 735010 737228 747968 776788 784107 795780 796128 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade sleeping my"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск спящ my"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.70%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск спящ my"
]
|
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.