Query Metrics
7
Database Queries
7
Different statements
113.81 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.91 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.00 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"throat fuck mature"
]
|
||||||||||||||||||||||||||||||
| 3 | 11.84 ms |
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 719806 825244 495517 710393 453710 823170 716630 719408 743015 754278 327378 658481 744400 731449 663461 397214 451466 726366 734090 734297 746208 758058 790232 824915 738324 802295 390492 716703 665264 719802 495520 800731 415845 742987 471164 439593 800747 413101 530247 593033 737963 727018 470347 563110 761291 818504 528362 744520 445439 797119 510988 546259 773474 449178 477454 513552 327421 750827 447785 439607 816249 595101 801292 807177 623306 677828 629213 517451 494172 515678 488155 494513 516998 508195 516327 467683 444869 453688 453730 455772 475960 536481 458555 586616 526895 497935 ] |
||||||||||||||||||||||||||||||
| 4 | 2.90 ms |
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 327378 327421 390492 397214 413101 415845 439593 439607 444869 445439 447785 449178 451466 453688 453710 453730 455772 458555 467683 470347 471164 475960 477454 488155 494172 494513 495517 495520 497935 508195 510988 513552 515678 516327 516998 517451 526895 528362 530247 536481 546259 563110 586616 593033 595101 623306 629213 658481 663461 665264 677828 710393 716630 716703 719408 719802 719806 726366 727018 731449 734090 734297 737963 738324 742987 743015 744400 744520 746208 750827 754278 758058 761291 773474 790232 797119 800731 800747 801292 802295 807177 816249 818504 823170 824915 825244 ] |
||||||||||||||||||||||||||||||
| 5 | 91.84 ms |
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 327378 327421 390492 397214 413101 415845 439593 439607 444869 445439 447785 449178 451466 453688 453710 453730 455772 458555 467683 470347 471164 475960 477454 488155 494172 494513 495517 495520 497935 508195 510988 513552 515678 516327 516998 517451 526895 528362 530247 536481 546259 563110 586616 593033 595101 623306 629213 658481 663461 665264 677828 710393 716630 716703 719408 719802 719806 726366 727018 731449 734090 734297 737963 738324 742987 743015 744400 744520 746208 750827 754278 758058 761291 773474 790232 797119 800731 800747 801292 802295 807177 816249 818504 823170 824915 825244 ] |
||||||||||||||||||||||||||||||
| 6 | 1.73 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"throat секс mature"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.59 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"throat секс mature"
]
|
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.