Query Metrics
7
Database Queries
7
Different statements
207.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.67 ms (84.77%) |
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 318700 383631 387933 389234 390204 391921 398949 401613 407442 411898 413286 414833 419045 423968 428174 443134 443764 444915 445607 445838 445935 446964 447882 448882 453239 453242 454195 454428 454445 458000 458761 459936 460097 462970 463898 464031 465571 466346 468165 470041 474629 476015 476229 476290 477717 482952 486553 489868 491771 492449 495287 510425 515555 517452 517674 519754 525479 526682 529378 530127 530430 530860 533952 536637 539329 543970 544834 549236 552275 558252 566387 575703 577037 578525 582457 584012 599631 599638 602530 603507 605184 614742 633954 636464 647913 653392 663355 663421 663938 664579 664800 665205 665442 675956 707464 712672 724878 727900 742608 749016 781785 781787 781792 781843 781889 792819 794190 796797 801064 801570 804368 806301 810744 812055 813808 813821 814704 820715 824067 827290 ] |
||||||||||||||||||||||||||||||
|
20.70 ms (9.99%) |
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 318700 414833 428174 445935 453242 445607 529378 536637 544834 614742 444915 398949 443764 468165 476229 470041 458000 458761 515555 489868 813821 820715 454445 459936 533952 530860 558252 582457 712672 647913 653392 675956 664579 664800 633954 636464 605184 781785 781889 794190 792819 801570 806301 810744 812055 749016 781843 724878 742608 602530 796797 801064 804368 423968 466346 391921 383631 407442 419045 460097 447882 453239 486553 517452 495287 519754 517674 549236 566387 575703 584012 665205 665442 663355 663938 707464 577037 599638 603507 781792 781787 727900 464031 462970 443134 482952 390204 663421 454428 492449 465571 448882 413286 510425 525479 477717 474629 491771 599631 411898 476015 446964 389234 387933 401613 827290 814704 824067 813808 463898 445838 454195 526682 539329 530127 530430 476290 578525 543970 552275 ] |
||||||||||||||||||||||||||||||
|
3.34 ms (1.61%) |
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 318700 383631 387933 389234 390204 391921 398949 401613 407442 411898 413286 414833 419045 423968 428174 443134 443764 444915 445607 445838 445935 446964 447882 448882 453239 453242 454195 454428 454445 458000 458761 459936 460097 462970 463898 464031 465571 466346 468165 470041 474629 476015 476229 476290 477717 482952 486553 489868 491771 492449 495287 510425 515555 517452 517674 519754 525479 526682 529378 530127 530430 530860 533952 536637 539329 543970 544834 549236 552275 558252 566387 575703 577037 578525 582457 584012 599631 599638 602530 603507 605184 614742 633954 636464 647913 653392 663355 663421 663938 664579 664800 665205 665442 675956 707464 712672 724878 727900 742608 749016 781785 781787 781792 781843 781889 792819 794190 796797 801064 801570 804368 806301 810744 812055 813808 813821 814704 820715 824067 827290 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbw mother"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbw мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbw мам женщин"
]
|
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.