Query Metrics
7
Database Queries
7
Different statements
181.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.69 ms (87.67%) |
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 185249 185428 382194 382650 382807 383553 388001 390219 390318 401484 402987 405505 405534 406237 406404 406438 407054 407549 413195 419115 420086 428583 430989 447244 456184 465789 476336 478760 484289 489606 494771 499815 504444 507129 510037 518483 518948 522775 525251 530718 531416 535672 535733 551334 551340 551358 551397 551405 551421 551428 551430 551432 551741 557337 561669 564462 564621 564633 575118 577775 577818 578493 580372 580644 583213 583656 604497 610390 615883 618937 618938 624285 629094 636926 643436 643835 644666 645847 651928 651930 652177 653245 653250 653258 661092 661698 662038 662333 662723 663535 666299 677041 689308 705720 714471 727454 727482 728067 732379 733900 738927 741631 742993 748752 757977 772942 799522 799623 800296 800324 801243 813228 813949 814917 815691 815790 816047 816556 818317 827860 ] |
||||||||||||||||||||||||||||||
|
12.11 ms (6.69%) |
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 525251 405505 615883 478760 402987 465789 447244 535672 510037 382650 413195 583213 551421 551430 651928 653245 652177 653258 661698 662038 551358 583656 618937 800324 772942 799623 733900 742993 748752 390318 390219 816047 662333 636926 518948 531416 407549 827860 689308 643436 801243 738927 383553 382807 388001 504444 580644 651930 662723 551405 618938 800296 799522 643835 644666 705720 185249 419115 401484 420086 499815 610390 507129 564462 578493 653250 577775 489606 382194 407054 428583 430989 530718 518483 813228 406237 405534 494771 818317 815691 815790 816556 661092 645847 663535 629094 185428 814917 522775 476336 564621 727482 406438 406404 813949 551397 551432 575118 551340 577818 551428 677041 714471 551334 604497 624285 732379 757977 728067 741631 727454 456184 535733 666299 484289 551741 557337 564633 561669 580372 ] |
||||||||||||||||||||||||||||||
|
3.26 ms (1.80%) |
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 185249 185428 382194 382650 382807 383553 388001 390219 390318 401484 402987 405505 405534 406237 406404 406438 407054 407549 413195 419115 420086 428583 430989 447244 456184 465789 476336 478760 484289 489606 494771 499815 504444 507129 510037 518483 518948 522775 525251 530718 531416 535672 535733 551334 551340 551358 551397 551405 551421 551428 551430 551432 551741 557337 561669 564462 564621 564633 575118 577775 577818 578493 580372 580644 583213 583656 604497 610390 615883 618937 618938 624285 629094 636926 643436 643835 644666 645847 651928 651930 652177 653245 653250 653258 661092 661698 662038 662333 662723 663535 666299 677041 689308 705720 714471 727454 727482 728067 732379 733900 738927 741631 742993 748752 757977 772942 799522 799623 800296 800324 801243 813228 813949 814917 815691 815790 816047 816556 818317 827860 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"massage beauty"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"массаж beauty"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.