Query Metrics
7
Database Queries
7
Different statements
143.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.11 ms (84.49%) |
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 4377 12307 14578 39301 52231 66866 72666 91560 156055 187856 188244 305976 358259 383482 384039 385826 389887 390139 391875 396041 396889 396967 397221 398753 399514 406073 439691 439728 439730 441003 442118 453291 455337 456194 462346 464372 465222 466023 468835 469359 472649 472670 472860 474710 476276 476354 485960 485985 495514 495814 497391 504464 505261 506318 506404 511412 516040 518735 524992 526455 531529 537257 539357 539516 539641 542569 544794 550216 554452 557137 565026 567113 567683 601589 618651 632367 660251 664610 676252 677511 697249 710769 714936 719864 720510 724447 726392 726493 728208 728366 734077 734090 734204 735929 738324 740121 741774 741778 742773 742889 747087 749907 754138 755991 758444 761436 774384 776865 781752 784185 784241 788345 788432 789192 791003 796513 801705 803498 825361 ] |
||||||||||||||||||||||||||||||
|
13.61 ms (9.49%) |
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 526455 485985 539516 476354 464372 720510 784185 776865 462346 465222 397221 187856 456194 676252 728208 439691 825361 539357 664610 719864 724447 740121 439728 455337 789192 788432 524992 384039 396041 52231 4377 39301 791003 601589 758444 618651 801705 726392 72666 796513 557137 441003 742889 542569 531529 660251 632367 495814 472860 439730 398753 774384 66866 741774 742773 734077 746729 91560 156055 472649 728366 389887 504464 697249 741778 735929 677511 505261 14578 442118 537257 305976 747087 550216 506404 749907 188244 390139 396967 495514 734090 734204 738324 474710 755991 511412 761436 714936 453291 358259 516040 468835 385826 565026 399514 396889 554452 788345 754138 784241 406073 472670 391875 803498 12307 544794 710769 539641 781752 476276 383482 469359 567113 726493 485960 497391 567683 506318 518735 466023 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.61%) |
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 4377 12307 14578 39301 52231 66866 72666 91560 156055 187856 188244 305976 358259 383482 384039 385826 389887 390139 391875 396041 396889 396967 397221 398753 399514 406073 439691 439728 439730 441003 442118 453291 455337 456194 462346 464372 465222 466023 468835 469359 472649 472670 472860 474710 476276 476354 485960 485985 495514 495814 497391 504464 505261 506318 506404 511412 516040 518735 524992 526455 531529 537257 539357 539516 539641 542569 544794 550216 554452 557137 565026 567113 567683 601589 618651 632367 660251 664610 676252 677511 697249 710769 714936 719864 720510 724447 726392 726493 728208 728366 734077 734090 734204 735929 738324 740121 741774 741778 742773 742889 747087 749907 754138 755991 758444 761436 774384 776865 781752 784185 784241 788345 788432 789192 791003 796513 801705 803498 825361 ] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"минет зрелка"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс зрелая женщин"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс зрелая женщин"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.