Query Metrics
7
Database Queries
7
Different statements
377.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.49 ms (55.97%) |
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 187824 365995 383987 384373 391208 404468 404939 408601 423414 423989 425709 439926 447885 451813 452139 455210 457332 466329 468626 470624 484813 486283 486799 491393 492914 497583 504071 504168 507607 508019 516648 519608 522540 526202 532511 535578 536610 541780 541869 544868 545909 547929 550280 554351 556839 559178 561401 562824 564899 565903 566812 567725 568306 575706 576632 579812 586684 588276 592559 599917 602480 603648 604301 606727 609807 617770 622110 623120 629863 636998 640691 651090 651907 652879 653378 653726 661354 682075 682234 682273 683660 685479 686863 690831 694058 697266 699718 706658 707706 718376 726477 726478 726517 726532 726544 726549 726575 733886 733889 737124 744972 746990 748218 751026 770827 775261 775276 775982 780406 781459 785291 786114 786463 787957 788406 793704 796084 796105 796109 806395 ] |
||||||||||||||||||||||||||||||
|
141.79 ms (37.53%) |
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 187824 365995 383987 384373 391208 404468 404939 408601 423414 423989 425709 439926 447885 451813 452139 455210 457332 466329 468626 470624 484813 486283 486799 491393 492914 497583 504071 504168 507607 508019 516648 519608 522540 526202 532511 535578 536610 541780 541869 544868 545909 547929 550280 554351 556839 559178 561401 562824 564899 565903 566812 567725 568306 575706 576632 579812 586684 588276 592559 599917 602480 603648 604301 606727 609807 617770 622110 623120 629863 636998 640691 651090 651907 652879 653378 653726 661354 682075 682234 682273 683660 685479 686863 690831 694058 697266 699718 706658 707706 718376 726477 726478 726517 726532 726544 726549 726575 733886 733889 737124 744972 746990 748218 751026 770827 775261 775276 775982 780406 781459 785291 786114 786463 787957 788406 793704 796084 796105 796109 806395 ] |
||||||||||||||||||||||||||||||
|
17.65 ms (4.67%) |
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 544868 504071 545909 556839 786463 391208 457332 694058 599917 588276 423989 522540 561401 707706 793704 737124 726477 470624 535578 567725 575706 651090 606727 383987 486799 622110 423414 806395 559178 439926 384373 686863 746990 516648 187824 466329 550280 652879 661354 697266 706658 718376 699718 733889 751026 770827 775982 365995 497583 486283 404468 653378 586684 603648 785291 775261 425709 682234 536610 507607 579812 683660 566812 602480 775276 744972 564899 568306 541780 451813 504168 532511 682075 682273 562824 617770 592559 796105 796109 726532 781459 748218 623120 629863 519608 547929 609807 491393 690831 651907 640691 408601 604301 786114 780406 508019 404939 636998 733886 452139 447885 484813 468626 455210 492914 526202 565903 541869 554351 685479 787957 788406 726517 726478 726544 726575 726549 796084 576632 653726 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.52%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс два"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"сосет член двоим"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.38%) |
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.