Query Metrics
7
Database Queries
7
Different statements
436.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.11 ms (48.16%) |
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 391600 395224 396360 398360 398622 402458 402866 418005 419196 419269 422348 423531 423963 424010 425474 425485 438042 438056 441156 442631 443617 445611 445747 448089 448177 452976 453092 455522 458013 458635 459378 462070 465097 468385 469715 470350 472090 473007 473320 474884 476489 477205 477590 477742 477790 478223 480178 484458 487599 487862 491888 492559 495459 497201 502975 507103 509548 509825 510497 510937 512987 514447 515899 515901 526155 526585 527223 527598 528437 529995 531062 533840 534926 537943 538768 540211 542144 543275 549026 549513 552955 553227 555485 563892 563969 569033 569153 570764 580217 580930 582944 583984 586178 599788 607698 617089 623949 624839 633209 656495 656533 656537 712549 714779 714884 720421 737588 743782 756276 757808 760912 761466 769013 773614 782376 785204 799864 819104 822232 ] |
||||||||||||||||||||||||||||||
|
200.22 ms (45.89%) |
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 391600 395224 396360 398360 398622 402458 402866 418005 419196 419269 422348 423531 423963 424010 425474 425485 438042 438056 441156 442631 443617 445611 445747 448089 448177 452976 453092 455522 458013 458635 459378 462070 465097 468385 469715 470350 472090 473007 473320 474884 476489 477205 477590 477742 477790 478223 480178 484458 487599 487862 491888 492559 495459 497201 502975 507103 509548 509825 510497 510937 512987 514447 515899 515901 526155 526585 527223 527598 528437 529995 531062 533840 534926 537943 538768 540211 542144 543275 549026 549513 552955 553227 555485 563892 563969 569033 569153 570764 580217 580930 582944 583984 586178 599788 607698 617089 623949 624839 633209 656495 656533 656537 712549 714779 714884 720421 737588 743782 756276 757808 760912 761466 769013 773614 782376 785204 799864 819104 822232 ] |
||||||||||||||||||||||||||||||
|
17.96 ms (4.12%) |
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 617089 425474 458635 656533 599788 418005 448177 537943 424010 462070 480178 474884 477205 510937 402866 540211 515899 714884 623949 782376 799864 760912 773614 756276 402458 583984 553227 398360 419269 476489 543275 737588 465097 438056 484458 491888 497201 487862 470350 487599 419196 423963 822232 819104 445611 453092 465188 529995 533840 534926 512987 563969 720421 656537 586178 624839 607698 757808 761466 785204 769013 441156 452976 472090 445747 448089 514447 477742 526155 438042 443617 549026 442631 455522 468385 555485 580930 509825 549513 569153 391600 515901 422348 477590 527223 477790 714779 633209 473007 473320 478223 528437 495459 552955 502975 538768 570764 458013 569033 527598 459378 531062 580217 469715 396360 582944 395224 398622 423531 492559 510497 509548 563892 656495 712549 743782 425485 542144 507103 526585 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"creampie public"
]
|
||||||||||||||||||||||||||||||
|
2.28 ms (0.52%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"creampie на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"creampie на улиц"
]
|
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.