Query Metrics
7
Database Queries
7
Different statements
161.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.86 ms (83.99%) |
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 447136 454759 465047 509311 524282 530604 530895 532536 533282 533469 533601 535359 535396 535985 536573 536702 539458 539516 540351 544302 545358 546403 547265 549307 549381 549385 549973 550003 550682 553841 559881 572546 576621 584321 588248 588668 590770 591629 596152 601105 603299 603369 606922 610181 616117 618115 628297 633901 634347 636883 637430 638067 638897 639259 639260 641940 648886 649859 650196 651043 651163 651182 651661 662606 665804 665943 668373 668485 670557 673216 674215 676157 677133 680855 680960 681118 681142 681147 682490 682802 684815 686029 686203 688567 693127 696195 710360 713576 714586 717060 719994 721045 722678 779560 779846 780089 814762 815459 815504 815531 815905 815973 815976 816035 816195 816585 816801 816802 817223 818432 818623 819086 822388 822999 823085 824229 824308 825487 825498 827949 ] |
||||||||||||||||||||||||||||||
|
16.31 ms (10.09%) |
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 816195 816585 816801 816802 822388 814762 815459 815531 816035 817223 818432 822999 823085 815905 815973 818623 824229 825498 815504 815976 819086 824308 825487 827949 447136 454759 465047 524282 533469 533601 535359 535985 539458 539516 533282 536573 509311 530604 530895 532536 535396 540351 536702 547265 550003 545358 549381 549385 550682 559881 544302 549307 576621 584321 650196 651661 665804 668373 674215 677133 681118 681142 682490 684815 696195 722678 649859 651043 662606 665943 668485 680855 680960 681147 686203 693127 714586 717060 719994 721045 648886 651163 651182 670557 673216 676157 682802 686029 688567 710360 713576 546403 549973 553841 572546 588248 591629 603299 603369 606922 616117 596152 628297 634347 639259 639260 590770 601105 610181 618115 636883 588668 633901 637430 638067 638897 641940 779560 779846 780089 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.53%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"beauty boobs"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (1.28%) |
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 447136 454759 465047 509311 524282 530604 530895 532536 533282 533469 533601 535359 535396 535985 536573 536702 539458 539516 540351 544302 545358 546403 547265 549307 549381 549385 549973 550003 550682 553841 559881 572546 576621 584321 588248 588668 590770 591629 596152 601105 603299 603369 606922 610181 616117 618115 628297 633901 634347 636883 637430 638067 638897 639259 639260 641940 648886 649859 650196 651043 651163 651182 651661 662606 665804 665943 668373 668485 670557 673216 674215 676157 677133 680855 680960 681118 681142 681147 682490 682802 684815 686029 686203 688567 693127 696195 710360 713576 714586 717060 719994 721045 722678 779560 779846 780089 814762 815459 815504 815531 815905 815973 815976 816035 816195 816585 816801 816802 817223 818432 818623 819086 822388 822999 823085 824229 824308 825487 825498 827949 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beauty boobs"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"beauty boobs"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.88%) |
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.