Query Metrics
7
Database Queries
7
Different statements
207.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.60 ms (85.79%) |
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 73070 382434 390040 390574 391808 393789 401981 402131 408940 409383 411615 411690 413035 421841 423056 423684 426549 428769 429669 432510 438329 438759 439582 439599 439634 439745 440345 442844 443459 443635 446050 447040 447276 449191 449289 449677 449710 450239 450442 453651 453686 454444 455479 455923 456432 456738 457058 458285 458794 459612 459826 460325 460735 460810 460924 462314 462335 462398 463175 465074 466373 467628 467749 469110 469823 470019 470256 470593 470607 471407 471886 471959 472421 472870 476007 476628 478121 478293 478503 478530 479487 481159 483228 483371 485507 485750 486268 486750 486863 488164 490498 491468 495817 497344 499740 501425 503400 504165 504365 506255 507224 507717 508159 510174 511308 511826 512529 513583 514125 514155 517258 519336 522733 523597 525941 527203 529171 530216 543400 546626 ] |
||||||||||||||||||||||||||||||
|
20.50 ms (9.90%) |
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 462398 511826 530216 449191 470593 453686 499740 503400 488164 497344 413035 459826 511308 391808 443459 411690 438759 447040 465074 458794 479487 470607 486750 490498 527203 472870 543400 453651 456738 466373 450442 472421 438329 401981 409383 411615 478121 442844 523597 485750 529171 483228 449289 476628 439745 467749 501425 517258 504365 73070 408940 446050 504165 457058 460325 514125 393789 423684 510174 426549 478503 460810 456432 462335 449710 507224 513583 439582 455479 454444 450239 459612 491468 486268 519336 481159 382434 402131 423056 462314 463175 470019 439634 469110 470256 471959 421841 439599 460924 512529 507717 483371 522733 443635 471886 485507 449677 390040 486863 432510 440345 455923 469823 525941 476007 508159 478530 460735 390574 428769 429669 447276 506255 514155 495817 546626 471407 458285 467628 478293 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.20%) |
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 73070 382434 390040 390574 391808 393789 401981 402131 408940 409383 411615 411690 413035 421841 423056 423684 426549 428769 429669 432510 438329 438759 439582 439599 439634 439745 440345 442844 443459 443635 446050 447040 447276 449191 449289 449677 449710 450239 450442 453651 453686 454444 455479 455923 456432 456738 457058 458285 458794 459612 459826 460325 460735 460810 460924 462314 462335 462398 463175 465074 466373 467628 467749 469110 469823 470019 470256 470593 470607 471407 471886 471959 472421 472870 476007 476628 478121 478293 478503 478530 479487 481159 483228 483371 485507 485750 486268 486750 486863 488164 490498 491468 495817 497344 499740 501425 503400 504165 504365 506255 507224 507717 508159 510174 511308 511826 512529 513583 514125 514155 517258 519336 522733 523597 525941 527203 529171 530216 543400 546626 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в ротик жене"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.74%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"в ротик жен"
]
|
||||||||||||||||||||||||||||||
|
1.28 ms (0.62%) |
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.