Query Metrics
7
Database Queries
7
Different statements
354.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.89 ms (59.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy natural"
]
|
||||||||||||||||||||||||||||||
|
119.14 ms (33.60%) |
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 385469 387287 399408 400100 400478 401881 403556 407313 410366 413078 415444 425579 425958 427368 429025 429704 430806 431205 443165 443756 444776 445058 447705 451750 455798 456005 456883 457792 460003 460257 460954 461106 463108 464144 464598 465095 466918 470289 470612 471387 471827 474593 474852 475907 481096 484439 485319 485433 485556 489207 489423 489844 490339 490515 490646 491901 491970 492470 493083 494146 494394 495886 496644 502791 505641 511797 511798 512210 518150 518479 519262 519818 520859 522375 525178 525193 525491 526162 542831 546351 547610 549367 551976 551992 552020 561602 564601 565051 566259 566329 572372 572548 585103 586220 587813 591549 594253 596566 598586 600436 604670 611366 612855 617193 617385 617391 622977 623551 625497 637737 665142 675541 687378 695140 768157 776008 792817 793671 808406 815543 ] |
||||||||||||||||||||||||||||||
|
17.83 ms (5.03%) |
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 547610 552020 561602 586220 604670 617391 622977 625497 587813 598586 611366 612855 617193 617385 596566 623551 793671 808406 768157 776008 792817 407313 425958 431205 385469 400478 425579 470612 471827 400100 502791 512210 491970 495886 493083 518150 401881 429704 466918 675541 591549 485433 485556 551992 443756 443165 456005 399408 444776 490515 461106 518479 475907 470289 464598 489844 490339 687378 637737 489207 410366 463108 465095 455798 526162 565051 600436 594253 481096 494146 484439 474593 460003 474852 519818 505641 695140 665142 490646 387287 403556 445058 415444 429025 430806 413078 427368 585103 815543 456883 457792 460257 460954 485319 464144 471387 492470 447705 451750 511797 519262 520859 525178 525193 525491 494394 496644 511798 522375 489423 491901 542831 572548 546351 551976 564601 566259 566329 549367 572372 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (0.89%) |
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 385469 387287 399408 400100 400478 401881 403556 407313 410366 413078 415444 425579 425958 427368 429025 429704 430806 431205 443165 443756 444776 445058 447705 451750 455798 456005 456883 457792 460003 460257 460954 461106 463108 464144 464598 465095 466918 470289 470612 471387 471827 474593 474852 475907 481096 484439 485319 485433 485556 489207 489423 489844 490339 490515 490646 491901 491970 492470 493083 494146 494394 495886 496644 502791 505641 511797 511798 512210 518150 518479 519262 519818 520859 522375 525178 525193 525491 526162 542831 546351 547610 549367 551976 551992 552020 561602 564601 565051 566259 566329 572372 572548 585103 586220 587813 591549 594253 596566 598586 600436 604670 611366 612855 617193 617385 617391 622977 623551 625497 637737 665142 675541 687378 695140 768157 776008 792817 793671 808406 815543 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая натуральная натуральные"
]
|
||||||||||||||||||||||||||||||
|
1.34 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.