Query Metrics
7
Database Queries
7
Different statements
168.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.02 ms (84.23%) |
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 7170 96623 103696 182749 192691 198857 282858 324183 341691 373803 383641 383925 390680 395674 395727 396030 409405 426197 432268 434275 444645 447851 452311 460222 461086 468626 473739 474610 475894 500300 503673 513511 515833 515892 522043 522899 527412 530295 530625 530630 531272 531849 533512 534842 537925 542524 544749 544751 545341 545441 558119 564554 565102 566789 582217 583677 586886 588301 600415 600490 601150 602506 615918 617412 620471 627807 628405 632614 632641 633179 633602 634480 635835 637008 646450 646849 646884 650373 652850 654097 661285 661455 674107 675021 676624 678517 681515 685775 695923 699719 702342 702675 704205 717066 717947 718159 720836 723094 727850 727906 734412 736107 738121 738820 740578 745924 750719 764220 775896 775904 777876 782439 796430 796652 796789 805228 811941 817139 817624 822304 ] |
||||||||||||||||||||||||||||||
|
15.76 ms (9.35%) |
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 617412 702675 432268 383641 395727 460222 474610 515833 198857 192691 817139 531849 685775 620471 782439 796430 734412 740578 717066 777876 600490 182749 650373 718159 750719 727906 738121 811941 566789 586886 390680 426197 447851 468626 522899 515892 537925 678517 720836 675021 676624 565102 395674 461086 500300 527412 503673 373803 661285 475894 282858 383925 542524 661455 674107 717947 775904 764220 738820 727850 775896 444645 452311 531272 530625 530630 533512 545441 558119 583677 646450 646884 582217 602506 588301 628405 601150 632614 615918 627807 434275 522043 534842 473739 545341 646849 704205 600415 637008 632641 7170 341691 817624 822304 513511 530295 544751 564554 654097 681515 695923 652850 544749 633179 635835 633602 805228 796652 796789 736107 745924 634480 699719 702342 723094 324183 96623 396030 103696 409405 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (1.84%) |
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 7170 96623 103696 182749 192691 198857 282858 324183 341691 373803 383641 383925 390680 395674 395727 396030 409405 426197 432268 434275 444645 447851 452311 460222 461086 468626 473739 474610 475894 500300 503673 513511 515833 515892 522043 522899 527412 530295 530625 530630 531272 531849 533512 534842 537925 542524 544749 544751 545341 545441 558119 564554 565102 566789 582217 583677 586886 588301 600415 600490 601150 602506 615918 617412 620471 627807 628405 632614 632641 633179 633602 634480 635835 637008 646450 646849 646884 650373 652850 654097 661285 661455 674107 675021 676624 678517 681515 685775 695923 699719 702342 702675 704205 717066 717947 718159 720836 723094 727850 727906 734412 736107 738121 738820 740578 745924 750719 764220 775896 775904 777876 782439 796430 796652 796789 805228 811941 817139 817624 822304 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"double anal teen"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"double анал teen"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"double анал teen"
]
|
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.