Query Metrics
7
Database Queries
7
Different statements
142.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
114.83 ms (80.87%) |
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 39167 396869 398138 400569 401935 404052 425935 429252 438046 456288 456565 461634 469418 470230 470360 472095 473562 475574 476765 491698 493933 511047 523044 535008 541946 543851 549401 551221 551263 553398 554642 560493 560911 564083 567688 567861 572825 576391 581028 585290 589771 599439 599763 606212 613415 613579 618189 622022 625750 627032 629650 635569 646325 647126 649905 650020 650228 660270 666476 670467 671242 681699 682956 691112 695074 696053 696062 696675 696687 696698 696716 698195 699108 700171 701611 702347 707332 712835 715874 716121 716786 720470 722993 724331 739688 758949 761483 765802 768013 771514 772836 773498 775815 779811 784104 786588 791579 792351 798746 798940 798989 817403 817519 817520 817853 818697 819221 819452 819454 819524 820564 820978 821004 821143 821168 821475 821507 821564 826158 ] |
||||||||||||||||||||||||||||||
|
17.46 ms (12.30%) |
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 819221 819524 646325 712835 765802 798940 739688 650020 551263 541946 666476 396869 535008 613415 768013 429252 470230 564083 425935 491698 817403 817519 820564 821143 821168 821564 819452 822935 715874 647126 622022 798746 791579 404052 543851 554642 716121 599439 476765 560911 456565 456288 551221 560493 696062 635569 618189 786588 758949 784104 771514 773498 775815 817853 553398 576391 39167 670467 779811 682956 691112 798989 398138 511047 701611 472095 696053 696698 696716 722993 696675 702347 720470 599763 606212 589771 625750 772836 696687 401935 681699 761483 572825 613579 567688 627032 461634 650228 707332 493933 523044 649905 400569 826158 469418 473562 792351 438046 470360 475574 581028 724331 818697 819454 821507 817520 820978 821004 821475 567861 699108 671242 695074 698195 716786 660270 700171 549401 629650 585290 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.77%) |
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 39167 396869 398138 400569 401935 404052 425935 429252 438046 456288 456565 461634 469418 470230 470360 472095 473562 475574 476765 491698 493933 511047 523044 535008 541946 543851 549401 551221 551263 553398 554642 560493 560911 564083 567688 567861 572825 576391 581028 585290 589771 599439 599763 606212 613415 613579 618189 622022 625750 627032 629650 635569 646325 647126 649905 650020 650228 660270 666476 670467 671242 681699 682956 691112 695074 696053 696062 696675 696687 696698 696716 698195 699108 700171 701611 702347 707332 712835 715874 716121 716786 720470 722993 724331 739688 758949 761483 765802 768013 771514 772836 773498 775815 779811 784104 786588 791579 792351 798746 798940 798989 817403 817519 817520 817853 818697 819221 819452 819454 819524 820564 820978 821004 821143 821168 821475 821507 821564 826158 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"минет улица"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс улиц"
]
|
||||||||||||||||||||||||||||||
|
1.57 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.