Query Metrics
7
Database Queries
7
Different statements
177.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.02 ms (85.65%) |
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 70167 147128 337234 383348 397120 398679 406658 407432 410428 414702 414808 418345 420136 423564 428764 438495 457845 466415 466685 469149 469189 473553 480099 486371 486684 490820 491466 496510 497386 497478 508800 509593 512832 513920 540253 557084 563382 568513 568516 570861 579390 588148 590254 600575 603615 603708 604457 606511 607277 608773 609233 613240 622651 629870 629887 632668 635179 636553 636557 652540 662062 662195 673664 675839 678182 678259 680373 682321 709445 710891 714166 714826 715543 718856 719040 727413 728131 728895 730088 731062 731317 731697 733789 734524 744842 747571 748816 749538 750224 752499 771538 772920 775163 775513 777567 777627 778619 779008 779015 779077 779084 781065 784103 786160 787614 790398 791067 793739 800029 801987 804675 807845 809634 810373 810736 816709 817209 820213 825173 ] |
||||||||||||||||||||||||||||||
|
14.95 ms (8.42%) |
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 414702 397120 469189 466415 715543 606511 744842 466685 680373 817209 414808 632668 762336 787614 383348 480099 410428 607277 714166 733789 622651 636553 748816 682321 540253 588148 457845 613240 407432 428764 418345 579390 714826 710891 791067 810373 568513 718856 662195 777627 779084 790398 727413 786160 801987 730088 734524 728131 749538 750224 752499 609233 438495 512832 771538 423564 496510 709445 652540 678182 604457 635179 629870 629887 497386 509593 673664 603615 508800 398679 816709 825173 469149 800029 497478 147128 70167 675839 810736 747571 778619 804675 563382 603708 820213 406658 590254 486684 570861 719040 678259 600575 775513 777567 779008 779015 793739 809634 779077 781065 784103 728895 731317 772920 731062 731697 636557 775163 807845 486371 513920 337234 557084 473553 420136 568516 490820 608773 491466 662062 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.63%) |
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 70167 147128 337234 383348 397120 398679 406658 407432 410428 414702 414808 418345 420136 423564 428764 438495 457845 466415 466685 469149 469189 473553 480099 486371 486684 490820 491466 496510 497386 497478 508800 509593 512832 513920 540253 557084 563382 568513 568516 570861 579390 588148 590254 600575 603615 603708 604457 606511 607277 608773 609233 613240 622651 629870 629887 632668 635179 636553 636557 652540 662062 662195 673664 675839 678182 678259 680373 682321 709445 710891 714166 714826 715543 718856 719040 727413 728131 728895 730088 731062 731317 731697 733789 734524 744842 747571 748816 749538 750224 752499 771538 772920 775163 775513 777567 777627 778619 779008 779015 779077 779084 781065 784103 786160 787614 790398 791067 793739 800029 801987 804675 807845 809634 810373 810736 816709 817209 820213 825173 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"отсос сперма подборка…"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс сперм подборк"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.