Query Metrics
7
Database Queries
7
Different statements
138.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
115.94 ms (83.60%) |
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 285356 385105 396013 407549 415189 415748 416215 432404 434281 434429 437448 445743 457018 461696 466219 475547 479176 489244 492197 498668 500191 503064 503395 507549 509780 528540 551553 564240 583283 584610 603096 606733 607007 610191 610196 613200 617687 621527 628614 636440 675359 675448 681525 684150 708760 710305 716362 717119 717327 717438 718967 719504 719864 728635 728661 730948 731604 734707 735625 741823 742602 743565 743857 744457 744479 746553 746773 748450 749361 750208 750266 750922 751918 757236 757995 760361 760933 767422 767616 767725 768114 769185 777859 782524 784586 785125 785827 787222 787822 788214 789470 790569 791774 791924 792031 792525 793493 794574 795243 795576 795696 798197 800140 801126 801784 802149 802179 802304 804535 804559 804686 805881 807777 809877 811799 812258 813638 ] |
||||||||||||||||||||||||||||||
|
12.41 ms (8.95%) |
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 792031 437448 802304 528540 434281 434429 479176 461696 466219 498668 503395 500191 509780 714962 716362 610191 811799 804686 744479 768114 621527 489244 813638 445743 710305 564240 790569 792525 795696 743565 750208 767725 746773 734707 735625 757236 787222 787822 812258 746553 785827 407549 603096 432404 475547 717119 804535 385105 675448 584610 628614 415748 492197 503064 606733 457018 681525 675359 718967 636440 789470 777859 800140 802149 804559 728635 728661 741823 767422 769185 769187 795243 749361 767616 731604 610196 717327 717438 791924 801784 684150 802179 396013 415189 285356 551553 507549 719504 708760 719864 617687 613200 785125 791774 798197 805881 795576 742602 744457 750922 760933 730948 743857 757995 759141 748450 750266 751918 760361 782524 784586 788214 793493 807777 809877 794574 801126 416215 583283 607007 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.97%) |
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 285356 385105 396013 407549 415189 415748 416215 432404 434281 434429 437448 445743 457018 461696 466219 475547 479176 489244 492197 498668 500191 503064 503395 507549 509780 528540 551553 564240 583283 584610 603096 606733 607007 610191 610196 613200 617687 621527 628614 636440 675359 675448 681525 684150 708760 710305 716362 717119 717327 717438 718967 719504 719864 728635 728661 730948 731604 734707 735625 741823 742602 743565 743857 744457 744479 746553 746773 748450 749361 750208 750266 750922 751918 757236 757995 760361 760933 767422 767616 767725 768114 769185 777859 782524 784586 785125 785827 787222 787822 788214 789470 790569 791774 791924 792031 792525 793493 794574 795243 795576 795696 798197 800140 801126 801784 802149 802179 802304 804535 804559 804686 805881 807777 809877 811799 812258 813638 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"massage for wife"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (1.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"массаж жен"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (1.14%) |
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.