Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`

[]

SELECT
  `lang_id`,
  `code`,
  `name`,
  `icon`
FROM
  `lang`

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`;

SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1

[
  "старая в очках"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?
LIMIT
  1

SELECT `trend_id` FROM `trend` WHERE `subject` = 'старая в очках' LIMIT 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  456915
  463764
  512539
  562355
  776312
  739535
  483107
  516744
  491473
  510742
  469595
  615978
  482527
  506803
  512384
  485726
  559117
  575676
  559579
  549234
  467507
  477890
  554389
  698312
  538485
  529271
  467043
  515257
  507658
  601063
  449170
  558003
  474663
  504922
  567909
  713176
  590872
  489950
  464957
  524900
  558286
  559569
  526843
  467009
  526435
  625167
  524141
  504208
  450510
  458327
  492097
  534312
  588375
  506801
  518960
  562995
  609953
  591216
  527447
  485454
  464139
  684305
  492267
  483802
  563479
  605496
  520445
  498722
  527245
  730798
  533613
  590408
  591314
  507681
  590404
  624109
  517048
  513951
  590448
  584720
  561576
  430018
  434601
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )

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`=1 LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=2 WHERE p.post_id IN (456915, 463764, 512539, 562355, 776312, 739535, 483107, 516744, 491473, 510742, 469595, 615978, 482527, 506803, 512384, 485726, 559117, 575676, 559579, 549234, 467507, 477890, 554389, 698312, 538485, 529271, 467043, 515257, 507658, 601063, 449170, 558003, 474663, 504922, 567909, 713176, 590872, 489950, 464957, 524900, 558286, 559569, 526843, 467009, 526435, 625167, 524141, 504208, 450510, 458327, 492097, 534312, 588375, 506801, 518960, 562995, 609953, 591216, 527447, 485454, 464139, 684305, 492267, 483802, 563479, 605496, 520445, 498722, 527245, 730798, 533613, 590408, 591314, 507681, 590404, 624109, 517048, 513951, 590448, 584720, 561576, 430018, 434601);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  430018
  434601
  449170
  450510
  456915
  458327
  463764
  464139
  464957
  467009
  467043
  467507
  469595
  474663
  477890
  482527
  483107
  483802
  485454
  485726
  489950
  491473
  492097
  492267
  498722
  504208
  504922
  506801
  506803
  507658
  507681
  510742
  512384
  512539
  513951
  515257
  516744
  517048
  518960
  520445
  524141
  524900
  526435
  526843
  527245
  527447
  529271
  533613
  534312
  538485
  549234
  554389
  558003
  558286
  559117
  559569
  559579
  561576
  562355
  562995
  563479
  567909
  575676
  584720
  588375
  590404
  590408
  590448
  590872
  591216
  591314
  601063
  605496
  609953
  615978
  624109
  625167
  684305
  698312
  713176
  730798
  739535
  776312
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )

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=1 LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=2 WHERE pht.post_id IN (430018, 434601, 449170, 450510, 456915, 458327, 463764, 464139, 464957, 467009, 467043, 467507, 469595, 474663, 477890, 482527, 483107, 483802, 485454, 485726, 489950, 491473, 492097, 492267, 498722, 504208, 504922, 506801, 506803, 507658, 507681, 510742, 512384, 512539, 513951, 515257, 516744, 517048, 518960, 520445, 524141, 524900, 526435, 526843, 527245, 527447, 529271, 533613, 534312, 538485, 549234, 554389, 558003, 558286, 559117, 559569, 559579, 561576, 562355, 562995, 563479, 567909, 575676, 584720, 588375, 590404, 590408, 590448, 590872, 591216, 591314, 601063, 605496, 609953, 615978, 624109, 625167, 684305, 698312, 713176, 730798, 739535, 776312);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  430018
  434601
  449170
  450510
  456915
  458327
  463764
  464139
  464957
  467009
  467043
  467507
  469595
  474663
  477890
  482527
  483107
  483802
  485454
  485726
  489950
  491473
  492097
  492267
  498722
  504208
  504922
  506801
  506803
  507658
  507681
  510742
  512384
  512539
  513951
  515257
  516744
  517048
  518960
  520445
  524141
  524900
  526435
  526843
  527245
  527447
  529271
  533613
  534312
  538485
  549234
  554389
  558003
  558286
  559117
  559569
  559579
  561576
  562355
  562995
  563479
  567909
  575676
  584720
  588375
  590404
  590408
  590448
  590872
  591216
  591314
  601063
  605496
  609953
  615978
  624109
  625167
  684305
  698312
  713176
  730798
  739535
  776312
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )

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=1 LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=2 WHERE phc.post_id IN (430018, 434601, 449170, 450510, 456915, 458327, 463764, 464139, 464957, 467009, 467043, 467507, 469595, 474663, 477890, 482527, 483107, 483802, 485454, 485726, 489950, 491473, 492097, 492267, 498722, 504208, 504922, 506801, 506803, 507658, 507681, 510742, 512384, 512539, 513951, 515257, 516744, 517048, 518960, 520445, 524141, 524900, 526435, 526843, 527245, 527447, 529271, 533613, 534312, 538485, 549234, 554389, 558003, 558286, 559117, 559569, 559579, 561576, 562355, 562995, 563479, 567909, 575676, 584720, 588375, 590404, 590408, 590448, 590872, 591216, 591314, 601063, 605496, 609953, 615978, 624109, 625167, 684305, 698312, 713176, 730798, 739535, 776312);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "старая женщин очкастые"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'старая женщин очкастые';

SELECT `trend_id` FROM `trend` WHERE `subject` = ?

[
  "старая женщин очкастые"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?

SELECT `trend_id` FROM `trend` WHERE `subject` = 'старая женщин очкастые';