Query Metrics
7
Database Queries
7
Different statements
143.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.39 ms (82.34%) |
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 490812 509311 511416 520985 522154 524282 528296 529210 530604 530895 531046 531658 531902 532536 533191 533282 533332 533469 533601 534751 534783 535359 535396 535485 535544 535985 536573 536702 538930 538940 539151 539154 539458 539516 539610 539654 540257 540351 540481 540667 541200 544302 544339 545358 547265 547314 547770 549307 549381 549385 550003 550682 551703 551710 559385 559881 560369 566550 570852 570853 573233 576621 577626 581326 584321 584423 648255 649859 650196 651043 651661 654351 659150 662606 664380 665804 665943 668373 668485 674215 677133 679230 680855 680960 681118 681142 681147 682490 684815 686035 689300 696195 720761 722678 815309 815504 815779 815795 815905 815917 815973 815976 815979 816035 817223 818432 818623 819086 820872 821084 822999 823085 824229 824308 825487 825498 827949 ] |
||||||||||||||||||||||||||||||
|
14.52 ms (10.10%) |
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 815795 816035 817223 818432 822999 823085 815309 815905 815973 815979 818623 820872 821084 824229 825498 815504 815779 815917 815976 819086 824308 825487 827949 490812 447136 454759 465047 524282 531046 533469 533601 535359 535544 535985 539458 539516 539610 539654 540257 528296 531658 531902 533191 533282 536573 538930 540667 509311 520985 529210 530604 530895 532536 533332 534783 535396 535485 539151 540351 540481 511416 522154 534751 536702 538940 539154 541200 547265 547314 550003 551703 551710 570853 577626 545358 547770 549381 549385 550682 559881 560369 570852 581326 584423 544302 544339 549307 559385 566550 573233 576621 584321 648255 650196 651661 659150 664380 665804 668373 674215 677133 679230 681118 681142 682490 684815 686035 689300 696195 720761 722678 649859 651043 654351 662606 665943 668485 680855 680960 681147 ] |
||||||||||||||||||||||||||||||
|
3.29 ms (2.29%) |
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 490812 509311 511416 520985 522154 524282 528296 529210 530604 530895 531046 531658 531902 532536 533191 533282 533332 533469 533601 534751 534783 535359 535396 535485 535544 535985 536573 536702 538930 538940 539151 539154 539458 539516 539610 539654 540257 540351 540481 540667 541200 544302 544339 545358 547265 547314 547770 549307 549381 549385 550003 550682 551703 551710 559385 559881 560369 566550 570852 570853 573233 576621 577626 581326 584321 584423 648255 649859 650196 651043 651661 654351 659150 662606 664380 665804 665943 668373 668485 674215 677133 679230 680855 680960 681118 681142 681147 682490 684815 686035 689300 696195 720761 722678 815309 815504 815779 815795 815905 815917 815973 815976 815979 816035 817223 818432 818623 819086 820872 821084 822999 823085 824229 824308 825487 825498 827949 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beauty and"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"beauty"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"beauty"
]
|
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.