Query Metrics
7
Database Queries
7
Different statements
369.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.52 ms (57.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"азиатк большие сиськ анал"
]
|
||||||||||||||||||||||||||||||
|
126.83 ms (34.32%) |
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 396635 405174 414126 420050 421056 422514 422957 422996 423060 428944 429369 447426 448821 451867 457890 463798 464138 464651 468666 468705 469066 469200 472567 475313 491248 495066 497557 499044 503110 511336 516219 517864 519497 522795 526168 528308 529129 531196 532264 533065 534528 534987 536340 536681 537909 541854 542207 542798 545607 547241 558380 562003 562842 565265 565274 566007 566789 566908 567127 567776 571232 575300 580235 580255 583936 583996 597142 597242 597244 597246 600490 604429 609991 614401 616328 619177 621029 630280 630529 630533 636371 640534 643415 647311 662846 665762 665930 666968 670197 670625 679087 680130 680498 694192 694563 697369 699694 704156 706949 708476 717835 721795 722776 737127 752700 758648 759365 761464 765714 776935 801880 805413 808325 810829 810840 815019 815270 816259 820767 826182 ] |
||||||||||||||||||||||||||||||
|
21.62 ms (5.85%) |
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 699694 826182 542207 423060 721795 665762 694192 708476 761464 621029 670625 801880 808325 565274 495066 491248 447426 558380 666968 464651 815270 665930 694563 697369 776935 810829 630533 414126 517864 497557 420050 503110 583996 475313 706949 758648 805413 566908 468666 451867 422957 562842 662846 616328 531196 469066 457890 526168 580255 499044 567776 679087 647311 630529 597242 580235 537909 463798 604429 567127 816259 571232 609991 717835 528308 547241 759365 566007 533065 529129 765714 566789 522795 815019 542798 597246 643415 469200 575300 405174 429369 597142 640534 536340 536681 630280 752700 511336 583936 565265 722776 597244 464138 619177 810840 396635 428944 670197 534528 541854 532264 519497 422996 468705 820767 704156 680130 636371 737127 680498 545607 448821 534987 421056 422514 614401 600490 562003 472567 516219 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (0.86%) |
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 396635 405174 414126 420050 421056 422514 422957 422996 423060 428944 429369 447426 448821 451867 457890 463798 464138 464651 468666 468705 469066 469200 472567 475313 491248 495066 497557 499044 503110 511336 516219 517864 519497 522795 526168 528308 529129 531196 532264 533065 534528 534987 536340 536681 537909 541854 542207 542798 545607 547241 558380 562003 562842 565265 565274 566007 566789 566908 567127 567776 571232 575300 580235 580255 583936 583996 597142 597242 597244 597246 600490 604429 609991 614401 616328 619177 621029 630280 630529 630533 636371 640534 643415 647311 662846 665762 665930 666968 670197 670625 679087 680130 680498 694192 694563 697369 699694 704156 706949 708476 717835 721795 722776 737127 752700 758648 759365 761464 765714 776935 801880 805413 808325 810829 810840 815019 815270 816259 820767 826182 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian-big-tits anal"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.45%) |
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.