Query Metrics
7
Database Queries
7
Different statements
187.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.90 ms (87.92%) |
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 509298 509659 534621 536324 537379 540208 542259 542304 543546 543636 543723 544981 545750 546367 547979 553436 557506 558476 558541 558708 566672 567100 567902 575223 575885 577002 581554 590471 598778 599242 602048 604807 619899 623403 625679 630453 631784 632949 633715 638957 644205 655507 655575 658468 660667 666491 667984 669244 669869 669876 669894 669930 673033 683084 690027 694615 701963 702034 704635 704990 705029 706143 708321 708846 708908 709910 716125 717322 722294 727584 735828 736334 737891 740852 742131 748550 748638 749363 751680 751792 752570 753715 754302 754394 757924 759411 765851 769348 769373 774872 778655 778656 778679 778692 778768 782064 782109 782138 783692 786601 789479 790102 790230 791120 792237 793101 793146 795711 795990 796408 799708 800715 801783 803116 807110 808313 808507 809571 809630 812039 ] |
||||||||||||||||||||||||||||||
|
13.43 ms (7.16%) |
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 537379 509298 536324 534621 540208 509659 553436 558708 567100 542259 543546 544981 545750 558476 567902 575885 581554 542304 543636 543723 547979 557506 577002 655507 667984 690027 702034 704990 705029 706143 708321 716125 655575 669869 673033 694615 708908 658468 660667 666491 669244 669876 669894 669930 683084 701963 704635 708846 709910 717322 722294 546367 558541 566672 575223 590471 632949 598778 599242 602048 633715 604807 630453 619899 623403 625679 631784 638957 644205 774872 778655 778679 778768 782064 782138 783692 786601 792237 795990 799708 803116 807110 808313 808507 812039 778656 778692 789479 790102 793146 796408 800715 727584 736334 737891 740852 749363 751792 753715 757924 769373 782109 790230 791120 793101 795711 801783 809571 809630 735828 742131 748550 748638 752570 754302 754394 759411 765851 769348 751680 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.27%) |
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 509298 509659 534621 536324 537379 540208 542259 542304 543546 543636 543723 544981 545750 546367 547979 553436 557506 558476 558541 558708 566672 567100 567902 575223 575885 577002 581554 590471 598778 599242 602048 604807 619899 623403 625679 630453 631784 632949 633715 638957 644205 655507 655575 658468 660667 666491 667984 669244 669869 669876 669894 669930 673033 683084 690027 694615 701963 702034 704635 704990 705029 706143 708321 708846 708908 709910 716125 717322 722294 727584 735828 736334 737891 740852 742131 748550 748638 749363 751680 751792 752570 753715 754302 754394 757924 759411 765851 769348 769373 774872 778655 778656 778679 778692 778768 782064 782109 782138 783692 786601 789479 790102 790230 791120 792237 793101 793146 795711 795990 796408 799708 800715 801783 803116 807110 808313 808507 809571 809630 812039 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian wife solo"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск жен соло"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.