Query Metrics
7
Database Queries
7
Different statements
170.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.67 ms (86.46%) |
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 143195 194286 338249 382812 395679 397220 398947 404341 407801 408437 413995 415734 430411 442238 445064 451929 451931 451991 452299 457645 462695 464418 465340 466213 471056 474095 475859 476234 478829 479096 482761 485267 486126 490430 494516 502903 502995 517723 524165 526028 526655 531427 543943 544493 546947 549799 552309 555921 563133 563169 563193 563212 563453 565097 579308 603200 604997 606387 613483 633528 650662 663460 678734 694181 698251 715536 716072 718472 718839 721954 722179 724033 725118 726423 726671 726827 728452 729091 729180 730072 731777 733276 733819 734371 744825 748231 759693 759982 762777 770853 770949 781447 781780 785607 794703 794803 795104 800298 800345 800347 800387 800557 802430 802870 804447 807192 808533 813922 815446 815876 815940 816059 818163 818468 819515 820148 820155 820840 824621 825255 ] |
||||||||||||||||||||||||||||||
|
13.12 ms (7.68%) |
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 475859 476234 552309 563212 563169 694181 678734 718839 663460 555921 563193 563453 633528 781780 726827 770853 731777 748231 730072 716072 781447 794803 408437 465340 526655 451929 143195 816059 825255 820155 526028 579308 603200 802430 795104 800347 800557 729091 734371 800387 733819 770949 726671 715536 722179 800298 338249 474095 549799 194286 413995 442238 452299 478829 486126 517723 502995 524165 451931 451991 485267 502903 546947 544493 563133 606387 728452 462695 479096 466213 490430 494516 397220 407801 815446 815876 818163 820148 813922 818468 820840 824621 464418 531427 543943 565097 650662 718472 698251 613483 604997 794703 802870 807192 808533 759693 724033 725118 744825 729180 762777 726423 733276 759982 721954 785607 800345 804447 398947 382812 395679 404341 415734 430411 445064 815940 819515 457645 471056 482761 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.70%) |
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 143195 194286 338249 382812 395679 397220 398947 404341 407801 408437 413995 415734 430411 442238 445064 451929 451931 451991 452299 457645 462695 464418 465340 466213 471056 474095 475859 476234 478829 479096 482761 485267 486126 490430 494516 502903 502995 517723 524165 526028 526655 531427 543943 544493 546947 549799 552309 555921 563133 563169 563193 563212 563453 565097 579308 603200 604997 606387 613483 633528 650662 663460 678734 694181 698251 715536 716072 718472 718839 721954 722179 724033 725118 726423 726671 726827 728452 729091 729180 730072 731777 733276 733819 734371 744825 748231 759693 759982 762777 770853 770949 781447 781780 785607 794703 794803 795104 800298 800345 800347 800387 800557 802430 802870 804447 807192 808533 813922 815446 815876 815940 816059 818163 818468 819515 820148 820155 820840 824621 825255 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"facesitting mature"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"фейсситтинг mature"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фейсситтинг mature"
]
|
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.