Query Metrics
7
Database Queries
7
Different statements
165.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.87 ms (84.38%) |
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 162043 170215 188028 233733 276441 370715 381752 382003 383377 385147 386142 387359 387556 388761 389147 389355 389611 390644 390728 390761 391875 395134 395137 395861 395914 395955 396034 397366 399639 401532 401921 402095 402137 402960 407339 408947 409077 409317 409904 409929 411419 411629 411864 413068 416886 419629 420151 421006 430240 443725 452376 456128 460151 465338 467497 468467 470214 470639 472628 476180 476280 476319 476327 477077 480305 482665 484635 488377 489388 505252 513728 519141 522614 523367 546255 546455 555092 555123 557171 558914 573726 584214 599909 620246 620255 644661 655153 664495 664954 665317 665379 665448 667195 667474 667555 667878 668161 668174 670471 714175 721463 724084 730072 734699 748479 754436 756223 758417 759980 766777 773346 775989 784297 787298 796920 801093 801173 813578 817799 819018 ] |
||||||||||||||||||||||||||||||
|
17.11 ms (10.32%) |
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 396034 385147 668161 387556 420151 419629 730072 775989 387359 443725 465338 519141 381752 546255 411864 452376 555092 724084 748479 162043 409077 664495 476327 276441 599909 734699 773346 402960 756223 480305 413068 819018 817799 664954 170215 395955 401921 644661 714175 399639 476319 402095 395134 477077 787298 233733 796920 430240 555123 467497 389611 468467 409929 470214 620255 395914 411629 382003 665379 411419 546455 408947 409317 522614 505252 421006 409904 370715 476180 766777 386142 395137 472628 620246 407339 557171 584214 188028 665317 665448 667474 667878 390644 484635 395861 668174 513728 489388 655153 758417 784297 416886 523367 558914 667555 401532 391875 456128 573726 402137 754436 389355 670471 397366 383377 813578 460151 801093 488377 667195 759980 801173 470639 721463 390728 390761 388761 476280 389147 482665 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.51%) |
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 162043 170215 188028 233733 276441 370715 381752 382003 383377 385147 386142 387359 387556 388761 389147 389355 389611 390644 390728 390761 391875 395134 395137 395861 395914 395955 396034 397366 399639 401532 401921 402095 402137 402960 407339 408947 409077 409317 409904 409929 411419 411629 411864 413068 416886 419629 420151 421006 430240 443725 452376 456128 460151 465338 467497 468467 470214 470639 472628 476180 476280 476319 476327 477077 480305 482665 484635 488377 489388 505252 513728 519141 522614 523367 546255 546455 555092 555123 557171 558914 573726 584214 599909 620246 620255 644661 655153 664495 664954 665317 665379 665448 667195 667474 667555 667878 668161 668174 670471 714175 721463 724084 730072 734699 748479 754436 756223 758417 759980 766777 773346 775989 784297 787298 796920 801093 801173 813578 817799 819018 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая mature минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde mature blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"беловолосая 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.