Query Metrics
7
Database Queries
7
Different statements
186.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.89 ms (83.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 392687 424765 424770 429708 438316 439210 440708 441094 443255 445351 446785 449406 450250 450255 452773 452803 452810 453996 454000 458124 458765 460465 466226 466384 467075 468241 468665 469131 469199 469285 470032 470726 471124 471764 472706 473368 473533 474847 475414 476314 479107 486775 486831 490384 500914 507691 511274 513501 513522 513537 515354 516807 517511 517735 518008 526191 526556 527890 529326 530481 532729 537091 541850 543189 544831 547480 551494 552800 554489 558261 578146 580638 581173 583238 592573 597839 601789 604109 604198 604667 604782 607509 607541 609885 612962 622385 623193 628641 629808 633485 662876 669074 704907 707556 716550 718785 722392 740833 749259 751582 751615 752672 752767 763739 766335 781849 784221 785856 786881 791504 796057 800307 802029 803492 804765 805120 806140 806327 808655 810118 ] |
||||||||||||||||||||||||||||||
|
20.39 ms (10.92%) |
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 474847 530481 537091 511274 526191 460465 466384 473368 547480 578146 580638 707556 716550 552800 604782 607541 604109 607509 623193 612962 785856 800307 804765 806140 803492 806327 752672 796057 749259 751582 751615 740833 752767 763739 704907 781849 786881 791504 802029 810118 458124 452810 445351 470032 470726 513537 513501 443255 446785 486775 471124 476314 516807 469131 583238 592573 604198 604667 439210 469199 458765 454000 453996 486831 452773 507691 554489 622385 452803 475414 424770 440708 441094 429708 424765 450250 468665 469285 473533 449406 468241 471764 472706 500914 515354 527890 517511 532729 529326 517735 518008 467075 551494 558261 541850 543189 544831 581173 662876 669074 718785 609885 629808 601789 628641 597839 808655 805120 766335 633485 722392 784221 479107 392687 438316 466226 450255 513522 526556 490384 ] |
||||||||||||||||||||||||||||||
|
3.37 ms (1.80%) |
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 392687 424765 424770 429708 438316 439210 440708 441094 443255 445351 446785 449406 450250 450255 452773 452803 452810 453996 454000 458124 458765 460465 466226 466384 467075 468241 468665 469131 469199 469285 470032 470726 471124 471764 472706 473368 473533 474847 475414 476314 479107 486775 486831 490384 500914 507691 511274 513501 513522 513537 515354 516807 517511 517735 518008 526191 526556 527890 529326 530481 532729 537091 541850 543189 544831 547480 551494 552800 554489 558261 578146 580638 581173 583238 592573 597839 601789 604109 604198 604667 604782 607509 607541 609885 612962 622385 623193 628641 629808 633485 662876 669074 704907 707556 716550 718785 722392 740833 749259 751582 751615 752672 752767 763739 766335 781849 784221 785856 786881 791504 796057 800307 802029 803492 804765 805120 806140 806327 808655 810118 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature tattoo solo"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature татуированные соло"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.79%) |
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.