Query Metrics
7
Database Queries
7
Different statements
189.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.61 ms (83.03%) |
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 123199 263335 365546 390530 391258 395182 396980 398949 401035 403378 407810 416436 416448 419133 423521 423585 423912 439405 442663 451853 457045 457633 457902 457913 458986 460362 465504 469959 475394 479204 479738 479788 485173 489853 491765 498550 501440 505097 507739 508378 508566 509009 509894 510250 510907 513382 518242 518634 520083 520936 520983 521696 525861 527072 527842 528533 529960 532774 534325 535840 535947 537142 538093 538421 538971 538986 540248 540426 544704 556677 562618 567481 571785 577087 582088 582944 583027 585734 587208 591979 592652 594219 595194 595208 604174 613780 615898 624287 632143 640314 646807 650540 653349 659199 670821 673797 677153 682929 682942 699444 712475 736790 741855 743843 748658 760454 787311 796372 803534 806834 808787 810059 819956 823858 828312 828525 828643 828669 828760 828827 ] |
||||||||||||||||||||||||||||||
|
21.40 ms (11.27%) |
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 465504 535840 712475 653349 592652 510907 538093 538986 457913 505097 760454 699444 806834 538421 439405 365546 828525 390530 123199 407810 583027 556677 594219 401035 451853 508378 520083 509009 527842 823858 416448 419133 398949 682929 479788 532774 528533 457045 534325 507739 460362 682942 489853 582088 659199 632143 457633 518242 540426 501440 567481 677153 650540 585734 591979 595194 595208 624287 808787 803534 810059 736790 741855 423585 828643 828669 819956 396980 469959 540248 571785 423521 416436 442663 479738 521696 562618 673797 423912 263335 498550 520936 525861 527072 538971 403378 457902 670821 787311 513382 520983 577087 613780 743843 828760 479204 828312 535947 646807 485173 391258 544704 748658 587208 796372 529960 508566 582944 640314 395182 510250 509894 518634 458986 604174 491765 475394 615898 828827 537142 ] |
||||||||||||||||||||||||||||||
|
3.42 ms (1.80%) |
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 123199 263335 365546 390530 391258 395182 396980 398949 401035 403378 407810 416436 416448 419133 423521 423585 423912 439405 442663 451853 457045 457633 457902 457913 458986 460362 465504 469959 475394 479204 479738 479788 485173 489853 491765 498550 501440 505097 507739 508378 508566 509009 509894 510250 510907 513382 518242 518634 520083 520936 520983 521696 525861 527072 527842 528533 529960 532774 534325 535840 535947 537142 538093 538421 538971 538986 540248 540426 544704 556677 562618 567481 571785 577087 582088 582944 583027 585734 587208 591979 592652 594219 595194 595208 604174 613780 615898 624287 632143 640314 646807 650540 653349 659199 670821 673797 677153 682929 682942 699444 712475 736790 741855 743843 748658 760454 787311 796372 803534 806834 808787 810059 819956 823858 828312 828525 828643 828669 828760 828827 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"riding ass big"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"riding жоп большие"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.27 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"riding жоп большие"
]
|
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.