Query Metrics
7
Database Queries
7
Different statements
197.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.49 ms (90.37%) |
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 116949 205430 382426 382732 384342 384979 386051 386965 389165 390932 392974 423637 506474 507263 518314 539520 540355 543750 549329 552019 556262 558023 563452 566881 566923 568051 569906 572378 573631 612085 615539 619448 623555 627547 659113 665453 669435 675462 675811 679057 679391 692625 698048 720964 721317 722764 722810 723346 724659 725378 727111 736373 737357 738907 740253 741465 741992 742953 743013 743884 743955 746146 746160 747799 748631 748727 748947 751632 752112 752912 753359 753400 753431 753912 754195 754505 754654 754954 755856 757556 765208 766314 766899 768286 771210 771875 771904 773198 774087 774091 775133 775621 789971 791992 793558 793607 795378 799398 800480 804044 804348 808719 809671 809904 810591 812079 813447 813794 816941 817830 820019 820782 821093 822007 822227 822837 822988 823272 825766 826631 ] |
||||||||||||||||||||||||||||||
|
9.24 ms (4.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 793607 799398 795378 800480 804044 813447 743013 743884 746160 748947 754195 793558 804348 808719 809671 751632 753400 768286 771210 724659 740253 752112 753431 753912 754654 774087 742953 753359 774091 741465 752912 754954 755856 766314 775133 789971 812079 382426 390932 116949 384979 205430 722810 675811 748631 757556 765208 766899 738907 389165 810591 623555 556262 771904 743955 543750 549329 568051 569906 572378 659113 675462 679057 692625 669435 665453 698048 722764 723346 563452 566923 573631 612085 615539 809904 725378 736373 746146 754505 721317 775621 823272 679391 619448 741992 791992 737357 747799 748727 727111 771875 773198 627547 720964 423637 384342 506474 386051 382732 392974 386965 816941 820019 826631 822007 822837 825766 817830 822988 813794 820782 821093 822227 518314 539520 507263 540355 566881 552019 558023 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.39%) |
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 116949 205430 382426 382732 384342 384979 386051 386965 389165 390932 392974 423637 506474 507263 518314 539520 540355 543750 549329 552019 556262 558023 563452 566881 566923 568051 569906 572378 573631 612085 615539 619448 623555 627547 659113 665453 669435 675462 675811 679057 679391 692625 698048 720964 721317 722764 722810 723346 724659 725378 727111 736373 737357 738907 740253 741465 741992 742953 743013 743884 743955 746146 746160 747799 748631 748727 748947 751632 752112 752912 753359 753400 753431 753912 754195 754505 754654 754954 755856 757556 765208 766314 766899 768286 771210 771875 771904 773198 774087 774091 775133 775621 789971 791992 793558 793607 795378 799398 800480 804044 804348 808719 809671 809904 810591 812079 813447 813794 816941 817830 820019 820782 821093 822007 822227 822837 822988 823272 825766 826631 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy small"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy маленькая"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy маленькая"
]
|
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.