Query Metrics
7
Database Queries
7
Different statements
195.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.27 ms (87.06%) |
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 387623 387655 417252 487541 490312 491128 496632 516356 517280 529927 547816 549102 553088 554724 562403 564364 589922 590029 594499 595009 600861 600881 602831 606000 606421 607487 609702 610161 611144 612520 612578 616422 616565 617563 622703 625483 627125 629453 631224 636075 637309 637869 637956 644190 648329 649588 650096 653009 653340 655511 660035 664700 672708 675397 677877 680294 681355 684516 684847 687145 692524 696209 696223 698099 698797 700590 700647 701605 703016 703979 705398 705478 707229 708933 710074 711617 713651 716104 718867 719854 724444 734601 734783 735297 738944 740281 740844 747992 749606 749710 750518 753649 754267 758066 758104 759821 766400 767853 768555 768613 771658 778479 778800 778888 779266 779415 780264 780409 783630 791114 793732 802918 803951 809728 809985 817679 819152 827893 ] |
||||||||||||||||||||||||||||||
|
15.28 ms (7.81%) |
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 809985 724444 734783 740281 749710 754267 766400 767853 753649 768613 770150 735297 738944 740844 749606 750518 758066 758104 759821 771658 772918 716104 718867 719854 778800 778888 779415 780264 780409 791114 793732 803951 809728 653009 680294 417252 616422 594499 516356 387623 817679 819152 802918 387655 827893 490312 487541 491128 517280 529927 496632 562403 547816 655511 660035 664700 677877 700590 700647 703979 705478 710074 648329 653340 692524 696209 696223 701605 703016 705398 707229 708933 649588 650096 672708 675397 681355 684516 684847 687145 711617 713651 549102 553088 554724 564364 600861 606000 606421 617563 625483 629453 637869 637956 589922 595009 602831 611144 616565 590029 600881 607487 612520 637309 644190 609702 610161 627125 631224 636075 778479 779266 783630 768555 747992 734601 612578 622703 698099 698797 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.49%) |
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 387623 387655 417252 487541 490312 491128 496632 516356 517280 529927 547816 549102 553088 554724 562403 564364 589922 590029 594499 595009 600861 600881 602831 606000 606421 607487 609702 610161 611144 612520 612578 616422 616565 617563 622703 625483 627125 629453 631224 636075 637309 637869 637956 644190 648329 649588 650096 653009 653340 655511 660035 664700 672708 675397 677877 680294 681355 684516 684847 687145 692524 696209 696223 698099 698797 700590 700647 701605 703016 703979 705398 705478 707229 708933 710074 711617 713651 716104 718867 719854 724444 734601 734783 735297 738944 740281 740844 747992 749606 749710 750518 753649 754267 758066 758104 759821 766400 767853 768555 768613 771658 778479 778800 778888 779266 779415 780264 780409 783630 791114 793732 802918 803951 809728 809985 817679 819152 827893 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur horny"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск horny"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск horny"
]
|
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.