Query Metrics
7
Database Queries
7
Different statements
233.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.86 ms (88.48%) |
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 398114 405683 410683 415859 416620 418127 418130 418149 418577 418817 420534 421366 425940 427122 428235 428305 432270 434349 434367 439169 442624 443245 446547 449020 449024 452826 454004 454007 455902 455918 465143 465670 466443 467064 467112 468495 469084 469096 469140 470453 470471 471155 475406 475426 475597 476663 476666 479351 480203 482751 482839 483762 487535 487537 488828 492906 499915 499917 502462 508154 513223 513793 514086 518183 518185 518187 518505 518915 522161 522165 526167 527912 534772 534777 550942 567054 577692 582580 583734 594113 596684 623300 629281 640948 664441 677147 680242 708714 730338 738446 738464 738471 738483 738485 738496 738518 739165 750426 752636 752664 752683 758343 758786 766825 766830 776209 777001 777012 782892 786610 796640 796675 806384 806425 806541 806695 807619 808321 812755 825878 ] |
||||||||||||||||||||||||||||||
|
17.15 ms (7.34%) |
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 806425 806541 806695 808321 730338 750426 738446 738483 758786 738464 738485 766830 758343 629281 640948 777001 786610 796675 812755 410683 454007 467064 416620 439169 442624 468495 480203 418127 421366 428305 476666 479351 475597 487537 488828 518505 482839 492906 526167 502462 415859 594113 434367 405683 432270 418130 418149 418577 443245 434349 420534 428235 825878 583734 482751 449024 454004 455902 467112 469084 475426 452826 449020 455918 470471 476663 508154 514086 522165 534777 499915 513793 527912 513223 518187 534772 469096 483762 550942 567054 582580 664441 677147 680242 708714 577692 596684 623300 806384 776209 777012 796640 752683 782892 738471 766825 738518 738496 739165 752636 752664 807619 475406 465670 469140 418817 466443 471155 427122 470453 446547 465143 518185 499917 518915 518183 487535 522161 398114 425940 ] |
||||||||||||||||||||||||||||||
|
3.35 ms (1.43%) |
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 398114 405683 410683 415859 416620 418127 418130 418149 418577 418817 420534 421366 425940 427122 428235 428305 432270 434349 434367 439169 442624 443245 446547 449020 449024 452826 454004 454007 455902 455918 465143 465670 466443 467064 467112 468495 469084 469096 469140 470453 470471 471155 475406 475426 475597 476663 476666 479351 480203 482751 482839 483762 487535 487537 488828 492906 499915 499917 502462 508154 513223 513793 514086 518183 518185 518187 518505 518915 522161 522165 526167 527912 534772 534777 550942 567054 577692 582580 583734 594113 596684 623300 629281 640948 664441 677147 680242 708714 730338 738446 738464 738471 738483 738485 738496 738518 739165 750426 752636 752664 752683 758343 758786 766825 766830 776209 777001 777012 782892 786610 796640 796675 806384 806425 806541 806695 807619 808321 812755 825878 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo sex machine"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло сексмашин"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.61%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.25 ms (0.54%) |
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.