Query Metrics
7
Database Queries
7
Different statements
149.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.05 ms (83.18%) |
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 145314 383595 387018 403039 405194 408024 414973 416315 421000 448061 450254 453716 462970 476344 476904 477346 485450 489958 495259 498816 499371 505836 507168 507532 509780 519594 520253 525800 526834 527029 527449 528540 530777 531405 532080 533000 534318 535833 559849 562884 563009 564797 565218 565938 574644 577039 586590 586662 587879 591805 601599 601644 604011 604864 605961 606831 607007 607139 610266 618284 618654 618659 620318 623263 640699 643050 673052 680745 705226 710305 710881 716033 718967 728635 736260 737169 741823 743565 745044 746773 749361 750208 750390 753722 760808 779663 782729 786428 787822 789709 789761 790836 794421 796855 797678 797706 797710 800140 800738 801784 801892 802304 811236 813638 813917 814586 814847 815326 815371 815466 815640 816034 816211 816916 816927 816967 817028 818198 820070 820582 ] |
||||||||||||||||||||||||||||||
|
14.57 ms (9.77%) |
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 520253 531405 586590 530777 476904 815466 818198 820070 816211 601599 760808 753722 789709 408024 786428 498816 586662 643050 813638 532080 564797 710305 618659 802304 743565 750390 790836 750208 746773 618654 787822 797710 499371 526834 527029 604011 448061 450254 533000 607139 462970 485450 519594 565218 607007 476344 680745 737169 716033 605961 736260 534318 565938 587879 815326 816916 817028 710881 618284 797678 811236 800738 801892 145314 505836 495259 383595 387018 507532 705226 577039 591805 813917 563009 477346 489958 820582 816927 816967 816034 559849 673052 718967 796855 800140 728635 741823 745044 749361 797706 801784 794421 782729 414973 421000 403039 528540 610266 620318 606831 640699 509780 507168 416315 525800 562884 623263 601644 453716 527449 405194 814847 815371 815640 814586 535833 574644 604864 779663 789761 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (2.04%) |
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 145314 383595 387018 403039 405194 408024 414973 416315 421000 448061 450254 453716 462970 476344 476904 477346 485450 489958 495259 498816 499371 505836 507168 507532 509780 519594 520253 525800 526834 527029 527449 528540 530777 531405 532080 533000 534318 535833 559849 562884 563009 564797 565218 565938 574644 577039 586590 586662 587879 591805 601599 601644 604011 604864 605961 606831 607007 607139 610266 618284 618654 618659 620318 623263 640699 643050 673052 680745 705226 710305 710881 716033 718967 728635 736260 737169 741823 743565 745044 746773 749361 750208 750390 753722 760808 779663 782729 786428 787822 789709 789761 790836 794421 796855 797678 797706 797710 800140 800738 801784 801892 802304 811236 813638 813917 814586 814847 815326 815371 815466 815640 816034 816211 816916 816927 816967 817028 818198 820070 820582 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother massage"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин массаж"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.10%) |
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.