Рефлексия на тему: Выбор методов обучения

INFO:
URL: /zakazy/191255
GET type_work=191255
GET lang=
IP: 3.15.22.24_3.15.22.24


DEBUG:

Выполнение запроса PDO:
SELECT TRUE FROM `hatsker_blocks` WHERE `ip` = ? AND `expired_time` > NOW();
Параметры запроса:
array (
0 => '3.15.22.24',
)
Время выполнения - 0.0004880428314209


Выполнение запроса PDO:
SELECT `ip` FROM `hatsker_ips` WHERE `ip` = ?;
Параметры запроса:
array (
0 => '3.15.22.24',
)
Время выполнения - 0.00043606758117676

Инициализация класса members
Инициализация класса tlist
Подключение к sql web_mysql
Выполнение sql запроса - select d.id,d.tkey,d.name from tlist as d, tlist_parts as p where p.tkey='type_user' and d.parent=p.id order by d.pos
Время выполнения - 0.0003sec
Selected - 3
Инициализация класса tlist
Выполнение sql запроса - select d.id,d.tkey,d.name from tlist as d, tlist_parts as p where p.tkey='stage_author' and d.parent=p.id order by d.pos
Время выполнения - 0.0003sec
Selected - 6
Выполнение sql запроса - SELECT id, label FROM w5domains WHERE active=1
Время выполнения - 0.0002sec
Selected - 2
Инициализация класса doc
Выполнение sql запроса - SELECT text FROM doc WHERE tkey='zakazy'
Время выполнения - 0.0002sec
Selected - 0

Выполнение запроса PDO:
SELECT `p`.`value`, `p`.`descr` FROM `pref` `p`
INNER JOIN `pref_parts` `pp` ON (`p`.`parent` = `pp`.`id`)
WHERE `p`.`tkey` = ? AND `pp`.`tkey` = ? LIMIT 1
Параметры запроса:
array (
0 => 'alarm_on_tkey',
1 => 'system',
)
Время выполнения - 0.00048303604125977


Выполнение запроса PDO:
SELECT `p`.`value`, `p`.`descr` FROM `pref` `p`
INNER JOIN `pref_parts` `pp` ON (`p`.`parent` = `pp`.`id`)
WHERE `p`.`tkey` = ? AND `pp`.`tkey` = ? LIMIT 1
Параметры запроса:
array (
0 => 'max_count_page',
1 => 'order_options',
)
Время выполнения - 0.00057101249694824


Выполнение запроса PDO:
SELECT COUNT(1) AS `n` FROM `filials` WHERE `active` = 'Y';
Время выполнения - 0.00051999092102051


Выполнение запроса PDO:
SELECT COUNT(1) AS `n` FROM `filials` WHERE `active` = 'Y' AND `is_office` = 'Y';
Время выполнения - 0.00059700012207031


Выполнение запроса PDO:
SELECT DISTINCT
`f`.`id` AS `f_id`,
`f`.`fkey` AS `f_fkey`,
`f`.`name` AS `f_name`,
`f`.`address` AS `f_address`,
`f`.`phone` AS `f_phone`,
`f`.`email` AS `f_email`,
`f`.`descr` AS `f_descr`,
`f`.`is_foreign` AS `f_is_foreign`,
`f`.`active` AS `f_active`,
`f`.`subdomain` AS `f_subdomain`,
`f`.`is_office` AS `f_is_office`,
`c`.`id` AS `c_id`,
`c`.`name` AS `c_name`,
`c`.`text` AS `c_text`,
`c`.`title` AS `c_title`,
`c`.`keywords` AS `c_keywords`,
`c`.`description` AS `c_description`

FROM `filials` `f`
LEFT JOIN `city` `c` ON `f`.`city_id` = `c`.`id`
WHERE `f`.`active` = 'Y'

ORDER BY
`c`.`name` ASC,
`f`.`name` ASC
Время выполнения - 0.0024089813232422


Выполнение запроса PDO:
SELECT
`p`.`id` AS `p_id`,
`p`.`parent` AS `p_parent`,
`p`.`tkey` AS `p_tkey`,
`p`.`value` AS `p_value`,
`pp`.`tkey` AS `pp_tkey`
FROM `pref` `p`
INNER JOIN `pref_parts` `pp` ON `p`.`parent` = `pp`.`id`
WHERE
`pp`.`tkey` IN ('arkhangelsk_contacts','astrahan_contacts','barnaul_contacts','belgorod_contacts','bryansk_contacts','velikiy-novgorod_contacts','vladivostok_contacts','vladkav_contacts','vladimir_contacts','volgograd_contacts','vologda_contacts','voronezh_contacts','grozny_contacts','ek_contacts','ivanovo_contacts','izhevsk_contacts','irkutsk_contacts','joshkar-ola_contacts','kazan_contacts','kaliningrad_contacts','kaluga_contacts','kemerovo_contacts','kirov_contacts','krasnodar_contacts','krasnoyarsk_contacts','kursk_contacts','kyzyl_contacts','lipeck_contacts','magas_contacts','magnitogorsk_contacts','mhchkl_contacts','msk_contacts','murmansk_contacts','naberezhnye-chelny_contacts','nalchik_contacts','nizhnevartovsk_contacts','nnov_contacts','novokuznetsk_contacts','nsk_contacts','omsk_contacts','orel_contacts','orenburg_contacts','penza_contacts','perm_contacts','petrozavodsk_contacts','podolsk_contacts','rostov_contacts','ryazan_contacts','samara_contacts','spb_contacts','saransk_contacts','saratov_contacts','sevastopol_contacts','sochi_contacts','stvrp_contacts','surgut_contacts','syktyvkar_contacts','tver_contacts','togliatti_contacts','tomsk_contacts','tyumen_contacts','ulan-ude_contacts','ulyanovsk_contacts','ufa_contacts','hanty-mansiysk_contacts','cheboksary_contacts','chelyabinsk_contacts','cherepovec_contacts','cherk_contacts','elista_contacts','yakutsk_contacts','yaroslavl_contacts');
Время выполнения - 0.0024938583374023

Выполнение sql запроса - SELECT `filial_key` FROM `filialkey_geocity` WHERE `geo_city` = 'Columbus' LIMIT 1;
Время выполнения - 0.0004sec
Selected - 0

Выполнение запроса PDO:
SELECT
`p`.`tkey`,
`p`.`value`,
`p`.`descr`
FROM `pref` `p`
INNER JOIN `pref_parts` `pp` ON `p`.`parent` = `pp`.`id`
WHERE `pp`.`tkey` = 'contacts';
Время выполнения - 0.00086212158203125


Выполнение запроса PDO:
SELECT `price` FROM `calculator_minimums` WHERE `worktype` = ? LIMIT 1;
Параметры запроса:
array (
0 => 0,
)
Время выполнения - 0.00064921379089355


Выполнение запроса PDO:
SELECT `p`.`value`, `p`.`descr` FROM `pref` `p`
INNER JOIN `pref_parts` `pp` ON (`p`.`parent` = `pp`.`id`)
WHERE `p`.`tkey` = ? AND `pp`.`tkey` = ? LIMIT 1
Параметры запроса:
array (
0 => 'min_price',
1 => 'calc',
)
Время выполнения - 0.00089907646179199


Выполнение запроса PDO:
SELECT `p`.`value`, `p`.`descr` FROM `pref` `p`
INNER JOIN `pref_parts` `pp` ON (`p`.`parent` = `pp`.`id`)
WHERE `p`.`tkey` = ? AND `pp`.`tkey` = ? LIMIT 1
Параметры запроса:
array (
0 => 'company_bornyear',
1 => 'contacts',
)
Время выполнения - 0.00076794624328613


Выполнение запроса PDO:
SELECT MAX(`id`) AS `id` FROM `orders`;
Время выполнения - 0.00043511390686035


Выполнение запроса PDO:
SELECT `filial_id` FROM `members` WHERE `id` = ?
Параметры запроса:
array (
0 => 0,
)
Время выполнения - 0.000579833984375


Выполнение запроса PDO:
SELECT
`d`.`ptitle`,
`d`.`pdescription`,
`d`.`pkeywords`,
`d`.`text`,
`d`.`title`,
`d`.`crumb`
FROM
`doc` `d`
WHERE
`tkey` = ?;
Параметры запроса:
array (
0 => 'zakazy',
)
Время выполнения - 0.00078892707824707


Выполнение запроса PDO:
SELECT `id`, `title`, `subtitle`, `text`, `url`, `meta_title`, `meta_description`, `meta_keywords`, `crumb`, `active`
FROM `seotext`
WHERE 1 AND `url` = :url AND `active` = :active

Параметры запроса:
array (
'url' => 'www|/zakazy/191255',
'active' => 1,
)
Время выполнения - 0.0054709911346436


Выполнение запроса PDO:
SELECT `id`, `title`, `subtitle`, `text`, `url`, `meta_title`, `meta_description`, `meta_keywords`, `crumb`, `active`
FROM `seotext`
WHERE 1 AND `url` = :url AND `active` = :active

Параметры запроса:
array (
'url' => '*|/zakazy/191255',
'active' => 1,
)
Время выполнения - 0.005295991897583


Выполнение запроса PDO:
SELECT wt.tkey, wt.name FROM orders_feed of
LEFT JOIN orders o ON o.id = of.id_order
LEFT JOIN worktypes wt ON wt.tkey = o.type_work GROUP BY wt.id
Время выполнения - 0.94797205924988


Выполнение запроса PDO:
SELECT o.type_work, app.name, app.tkey FROM orders_feed `of`
LEFT JOIN orders o ON o.id = `of`.id_order
LEFT JOIN author_predmets_parts app on o.predmet_id = app.id
LEFT JOIN author_predmets_parts app2 on app.parent = app2.id
WHERE of.deleted = 0 AND o.type_work IN('kurs','diplom','refer') GROUP BY app.tkey ORDER BY app.name
Время выполнения - 0.96929502487183

Выполнение sql запроса - UPDATE orders_feed SET views = views + 1 WHERE id_order = 191255
Время выполнения - 0.0012sec
Updated - 1
Выполнение sql запроса - SELECT FOUND_ROWS()
Время выполнения - 0.0003sec
Selected - 1
Выполнение sql запроса - SELECT SQL_CALC_FOUND_ROWS o.*,
of.views,
o.finish_data,
of.id AS id_order_rand,
of.count_page AS new_count_page,
of.originality AS new_originality,
of.summa AS new_summa_high,
of.min_summa AS new_summa_low,
w.name as worktype_name,
w.suffix_pattern as worktype_suffix,
app2.name as predmets_area_name,
app.tkey as predmet_tkey,
pf.descr as originality,
pf2.value as co_provider,
pf3.descr as warranty
FROM orders_feed `of`
LEFT JOIN orders o ON o.id = `of`.id_order
LEFT JOIN orders_extradata oe ON oe.order_id=o.id
LEFT JOIN pref pf ON pf.id = oe.client_originality
LEFT JOIN pref pf2 ON pf2.id = oe.co_provider
LEFT JOIN pref pf3 ON pf3.id = oe.extended_warranty
LEFT JOIN worktypes w on o.worktype_id = w.id
LEFT JOIN author_predmets_parts app on o.predmet_id = app.id
LEFT JOIN author_predmets_parts app2 on app.parent = app2.id
WHERE of.deleted = 0 AND o.id = 191255
GROUP BY o.id
ORDER BY of.views DESC LIMIT 20 OFFSET 0
Время выполнения - 0.0008sec
Selected - 1

Выполнение запроса PDO:
SELECT `tkey`, `name` FROM `author_predmets_parts` WHERE active='Y' AND parent > 0 ORDER BY `pos` ASC, `name` ASC
Время выполнения - 0.006227970123291

Выполнение sql запроса - SELECT * FROM feedback WHERE order_id = 191255
AND puclic = "Y"
SQL_ERROR: Unknown column 'puclic' in 'where clause'
Выполнение sql запроса - SELECT f.* FROM orders o
JOIN orders o2 ON o.predmet_id = o2.predmet_id AND o.worktype_id = o2.worktype_id
JOIN feedback f on o2.id = f.order_id AND f.public="Y"
WHERE o.id =191255 LIMIT 5
Время выполнения - 0.0012sec
Selected - 5
Выполнение sql запроса - SELECT * FROM orders_feed ofeed
LEFT JOIN orders o ON o.id = ofeed.id_order
WHERE ofeed.id IN((SELECT id FROM orders_feed WHERE id_order = 191255)-1, (SELECT id FROM orders_feed WHERE id_order = 191255)+1)
Время выполнения - 0.0005sec
Selected - 2
Выполнение sql запроса - SELECT o.*,
ofeed.views,
ofeed.count_page AS new_count_page,
ofeed.originality AS new_originality,
ofeed.summa AS new_summa_high,
ofeed.min_summa AS new_summa_low,
w.name as worktype_name,
w.suffix_pattern as worktype_suffix,
app2.name as predmets_area_name,
pf.descr as originality,
pf2.value as co_provider,
pf3.descr as warranty
FROM orders_feed ofeed
LEFT JOIN orders o ON o.id = ofeed.id_order
LEFT JOIN orders_extradata oe ON oe.order_id=o.id
LEFT JOIN pref pf ON pf.id = oe.client_originality
LEFT JOIN pref pf2 ON pf2.id = oe.co_provider
LEFT JOIN pref pf3 ON pf3.id = oe.extended_warranty
LEFT JOIN worktypes w on o.worktype_id = w.id
LEFT JOIN author_predmets_parts app on o.predmet_id = app.id
LEFT JOIN author_predmets_parts app2 on app.parent = app2.id
WHERE o.predmet_id = 398 LIMIT 5;

Время выполнения - 0.0010sec
Selected - 5

Выполнение запроса PDO:
SELECT
`wt`.`id`,
`wt`.`tkey`,
`wt`.`name`,
`wt`.`visible`,
`wt`.`is_client_originality`
FROM
`worktypes` `wt`
WHERE 1 AND `wt`.`visible` IN("all")
ORDER BY `wt`.`name` ASC;
Время выполнения - 0.00062704086303711


Выполнение запроса PDO:
SELECT `id`,`active`,`article_key`,`article_title`,`article_text`,`meta_title`,`meta_description`,`meta_keywords`,
`crumb`,`predmet_id`,`predmet_key`,`predmet_group_id`,`predmet_group_area_id`,`popular`,`author_name`,`article_date`
FROM `spravochnik`
WHERE 1 AND `active` = :active AND `predmet_key` = :predmet_key
ORDER BY RAND() ASC

Параметры запроса:
array (
'active' => 1,
'predmet_key' => 'Pedagogika',
)
Время выполнения - 0.010045051574707


Выполнение запроса PDO:
SELECT cp.url_name, cp.name,c.type_work FROM catalog c
JOIN catalog_parts cp on c.parent = cp.id
WHERE c.active = 'Y' AND c.type_work NOT IN('dissertatsija','disser_part','magisterskaya','statya-vak','statya_rinc','nauchnaya_statya','article_simple','dorabotka','povorig','chertezhi','chertezhi_a0','chertezhi_a1','chertezhi_a2','prezentacija','chertezhi_a3','chertezhi_a4','annotaciya','recenziya','otchet_prak','aspirant_referat','graficheskoe_izobrazhenie','programm','recenziya','oformlenie','free_plan','tezisnyi_plan') AND cp.active = 'Y' AND cp.parent>0 GROUP BY predmet_id, c.type_work ORDER BY cp.name
Время выполнения - 0.54176497459412


Выполнение запроса PDO:
SELECT
#DISTINCT

`c`.`id` AS `c_id`,
`c`.`name` AS `c_name`,
`c`.`type_work` AS `c_type_work`,
`c`.`count_page` AS `c_count_page`,
`c`.`count_sources` AS `c_count_sources`,
`c`.`data` AS `c_data`,
`c`.`price` AS `c_price`,
`c`.`copyright` AS `c_copyright`,
`c`.`active` AS `c_active`,
`c`.`vuz` AS `c_vuz`,
`c`.`number_kurs` AS `c_number_kurs`,
`c`.`originality` AS `c_originality`,
`c`.`operator` AS `c_operator`,
`c`.`author` AS `c_author`,
`c`.`comments` AS `c_comments`,
`c`.`status` AS `c_status`,
`cv`.`views` AS `c_views`,
`c`.`price_calc` AS `c_price_calc`,
`m`.`name` AS `m_name`,
`m`.`workplace` AS `m_workplace`,
(SELECT COUNT(*) FROM basket_parts WHERE basket_parts.work = c.id) AS bp_count,
`p`.`id` AS `predmet_id`,
`p`.`predmet_id` AS `predmet_id_citiarticles`,
`p`.`name` AS `predmet_name`,
`p`.`url_name` AS `predmet_url_name`,
`pg`.`id` AS `predmet_group_id`,
`pg`.`name` AS `predmet_group_name`,
`pg`.`url_name` AS `predmet_group_url_name`
FROM `catalog` `c`

INNER JOIN `catalog_parts` `p` ON `p`.`id` = `c`.`parent`
INNER JOIN `catalog_parts` `pg` ON `pg`.`id` = `p`.`parent` LEFT JOIN `members` `m` ON `m`.`id` = `c`.`author` LEFT JOIN `catalog_views` `cv` ON `cv`.`id_catalog` = `c`.`id`
WHERE 1
AND `c`.`active` = 'Y' AND `p`.`active` = 'Y' AND `pg`.`active` = 'Y' AND `p`.`parent` > 0 AND `pg`.`parent` = 0 AND `p`.`url_name` = :predmet

ORDER BY `c`.`name` ASC
LIMIT 0, 5;
Параметры запроса:
array (
':predmet' => 'Pedagogika',
)
Время выполнения - 0.036427021026611


Выполнение запроса PDO:
SELECT
#DISTINCT
COUNT(1) as `count`
FROM `catalog` `c`

INNER JOIN `catalog_parts` `p` ON `p`.`id` = `c`.`parent`
INNER JOIN `catalog_parts` `pg` ON `pg`.`id` = `p`.`parent` LEFT JOIN `members` `m` ON `m`.`id` = `c`.`author` LEFT JOIN `catalog_views` `cv` ON `cv`.`id_catalog` = `c`.`id`
WHERE 1
AND `c`.`active` = 'Y' AND `p`.`active` = 'Y' AND `pg`.`active` = 'Y' AND `p`.`parent` > 0 AND `pg`.`parent` = 0 AND `p`.`url_name` = :predmet

ORDER BY `c`.`name` ASC
;
Параметры запроса:
array (
':predmet' => 'Pedagogika',
)
Время выполнения - 0.019593954086304


Выполнение запроса PDO:
select tkey, name from worktypes
Время выполнения - 0.00063085556030273

Инициализация класса action_site

Выполнение запроса PDO:
SELECT
`f`.`id`,
`f`.`name`,
`fs`.`address`,
`fs`.`phone`,
`fs`.`work_time_from`,
`fs`.`work_time_to`,
`fs`.`break_time_from`,
`fs`.`break_time_to`,
`fs`.`email` `email`,
`fwd`.`day` `days`
FROM
`filials` `f`
INNER JOIN `filial_shedule` `fs` ON `f`.`id` = `fs`.`filial_id`
LEFT JOIN `filial_work_days` `fwd` ON `f`.`id` = `fwd`.`filial_id`
WHERE
`f`.`active` = 'Y' AND `f`.`fkey` = ?
Параметры запроса:
array (
0 => 'msk',
)
Время выполнения - 0.00050187110900879


Выполнение запроса PDO:
SELECT `p`.`value`, `p`.`descr` FROM `pref` `p`
INNER JOIN `pref_parts` `pp` ON (`p`.`parent` = `pp`.`id`)
WHERE `p`.`tkey` = ? AND `pp`.`tkey` = ? LIMIT 1
Параметры запроса:
array (
0 => 'show_mask_info',
1 => 'site_info',
)
Время выполнения - 0.0004429817199707

Выполнение sql запроса - SELECT tkey, predmet FROM cityarticles WHERE parent =(SELECT id FROM cityarticles WHERE tkey = 'kurs') ORDER BY predmet
Время выполнения - 0.0031sec
Selected - 894


ERROR: SELECT * FROM feedback WHERE order_id = 191255
AND puclic = "Y" - SELECT * FROM feedback WHERE order_id = 191255
AND puclic = "Y"
ERROR: error_sql_sql_error Unknown column 'puclic' in 'where clause' - error_sql_sql_error Unknown column 'puclic' in 'where clause'


--------

--------
[[Всего различных запросов:35]
--------
[sql_execute][Количество: 1| Время: 0.0002sec| Максимальное: 0.0002sec]
'SELECT id, label FROM w5domains WHERE active=1'
--------
[sql_execute][Количество: 1| Время: 0.0002sec| Максимальное: 0.0002sec]
'SELECT text FROM doc WHERE tkey=\'zakazy\''
--------
[sql_execute][Количество: 1| Время: 0.0003sec| Максимальное: 0.0003sec]
'select d.id,d.tkey,d.name from tlist as d, tlist_parts as p where p.tkey=\'stage_author\' and d.parent=p.id order by d.pos'
--------
[sql_execute][Количество: 1| Время: 0.0003sec| Максимальное: 0.0003sec]
'select d.id,d.tkey,d.name from tlist as d, tlist_parts as p where p.tkey=\'type_user\' and d.parent=p.id order by d.pos'
--------
[sql_execute][Количество: 1| Время: 0.0003sec| Максимальное: 0.0003sec]
'SELECT FOUND_ROWS()'
--------
[sql_execute][Количество: 1| Время: 0.0004sec| Максимальное: 0.0004sec]
'SELECT `filial_key` FROM `filialkey_geocity` WHERE `geo_city` = \'Columbus\' LIMIT 1;'
--------
[db_class][Количество: 1| Время: 0.00043511390686035| Максимальное: 0.00043511390686035]
'SELECT MAX(`id`) AS `id` FROM `orders`;'
--------
[db_class][Количество: 1| Время: 0.00043606758117676| Максимальное: 0.00043606758117676]
'SELECT `ip` FROM `hatsker_ips` WHERE `ip` = ?;'
--------
[db_class][Количество: 1| Время: 0.0004880428314209| Максимальное: 0.0004880428314209]
'SELECT TRUE FROM `hatsker_blocks` WHERE `ip` = ? AND `expired_time` > NOW();'
--------
[sql_execute][Количество: 1| Время: 0.0005sec| Максимальное: 0.0005sec]
'SELECT * FROM orders_feed ofeed
LEFT JOIN orders o ON o.id = ofeed.id_order
WHERE ofeed.id IN((SELECT id FROM orders_feed WHERE id_order = 191255)-1, (SELECT id FROM orders_feed WHERE id_order = 191255)+1)'
--------
[db_class][Количество: 1| Время: 0.00050187110900879| Максимальное: 0.00050187110900879]
'SELECT
`f`.`id`,
`f`.`name`,
`fs`.`address`,
`fs`.`phone`,
`fs`.`work_time_from`,
`fs`.`work_time_to`,
`fs`.`break_time_from`,
`fs`.`break_time_to`,
`fs`.`email` `email`,
`fwd`.`day` `days`
FROM
`filials` `f`
INNER JOIN `filial_shedule` `fs` ON `f`.`id` = `fs`.`filial_id`
LEFT JOIN `filial_work_days` `fwd` ON `f`.`id` = `fwd`.`filial_id`
WHERE
`f`.`active` = \'Y\' AND `f`.`fkey` = ?'
--------
[db_class][Количество: 1| Время: 0.00051999092102051| Максимальное: 0.00051999092102051]
'SELECT COUNT(1) AS `n` FROM `filials` WHERE `active` = \'Y\';'
--------
[db_class][Количество: 1| Время: 0.000579833984375| Максимальное: 0.000579833984375]
'SELECT `filial_id` FROM `members` WHERE `id` = ?'
--------
[db_class][Количество: 1| Время: 0.00059700012207031| Максимальное: 0.00059700012207031]
'SELECT COUNT(1) AS `n` FROM `filials` WHERE `active` = \'Y\' AND `is_office` = \'Y\';'
--------
[db_class][Количество: 1| Время: 0.00062704086303711| Максимальное: 0.00062704086303711]
'SELECT
`wt`.`id`,
`wt`.`tkey`,
`wt`.`name`,
`wt`.`visible`,
`wt`.`is_client_originality`
FROM
`worktypes` `wt`
WHERE 1 AND `wt`.`visible` IN("all")
ORDER BY `wt`.`name` ASC;'
--------
[db_class][Количество: 1| Время: 0.00063085556030273| Максимальное: 0.00063085556030273]
'select tkey, name from worktypes'
--------
[db_class][Количество: 1| Время: 0.00064921379089355| Максимальное: 0.00064921379089355]
'SELECT `price` FROM `calculator_minimums` WHERE `worktype` = ? LIMIT 1;'
--------
[db_class][Количество: 1| Время: 0.00078892707824707| Максимальное: 0.00078892707824707]
'SELECT
`d`.`ptitle`,
`d`.`pdescription`,
`d`.`pkeywords`,
`d`.`text`,
`d`.`title`,
`d`.`crumb`
FROM
`doc` `d`
WHERE
`tkey` = ?;'
--------
[sql_execute][Количество: 1| Время: 0.0008sec| Максимальное: 0.0008sec]
'SELECT SQL_CALC_FOUND_ROWS o.*,
of.views,
o.finish_data,
of.id AS id_order_rand,
of.count_page AS new_count_page,
of.originality AS new_originality,
of.summa AS new_summa_high,
of.min_summa AS new_summa_low,
w.name as worktype_name,
w.suffix_pattern as worktype_suffix,
app2.name as predmets_area_name,
app.tkey as predmet_tkey,
pf.descr as originality,
pf2.value as co_provider,
pf3.descr as warranty
FROM orders_feed `of`
LEFT JOIN orders o ON o.id = `of`.id_order
LEFT JOIN orders_extradata oe ON oe.order_id=o.id
LEFT JOIN pref pf ON pf.id = oe.client_originality
LEFT JOIN pref pf2 ON pf2.id = oe.co_provider
LEFT JOIN pref pf3 ON pf3.id = oe.extended_warranty
LEFT JOIN worktypes w on o.worktype_id = w.id
LEFT JOIN author_predmets_parts app on o.predmet_id = app.id
LEFT JOIN author_predmets_parts app2 on app.parent = app2.id
WHERE of.deleted = 0 AND o.id = 191255
GROUP BY o.id
ORDER BY of.views DESC LIMIT 20 OFFSET 0'
--------
[db_class][Количество: 1| Время: 0.00086212158203125| Максимальное: 0.00086212158203125]
'SELECT
`p`.`tkey`,
`p`.`value`,
`p`.`descr`
FROM `pref` `p`
INNER JOIN `pref_parts` `pp` ON `p`.`parent` = `pp`.`id`
WHERE `pp`.`tkey` = \'contacts\';'
--------
[sql_execute][Количество: 1| Время: 0.0010sec| Максимальное: 0.0010sec]
'SELECT o.*,
ofeed.views,
ofeed.count_page AS new_count_page,
ofeed.originality AS new_originality,
ofeed.summa AS new_summa_high,
ofeed.min_summa AS new_summa_low,
w.name as worktype_name,
w.suffix_pattern as worktype_suffix,
app2.name as predmets_area_name,
pf.descr as originality,
pf2.value as co_provider,
pf3.descr as warranty
FROM orders_feed ofeed
LEFT JOIN orders o ON o.id = ofeed.id_order
LEFT JOIN orders_extradata oe ON oe.order_id=o.id
LEFT JOIN pref pf ON pf.id = oe.client_originality
LEFT JOIN pref pf2 ON pf2.id = oe.co_provider
LEFT JOIN pref pf3 ON pf3.id = oe.extended_warranty
LEFT JOIN worktypes w on o.worktype_id = w.id
LEFT JOIN author_predmets_parts app on o.predmet_id = app.id
LEFT JOIN author_predmets_parts app2 on app.parent = app2.id
WHERE o.predmet_id = 398 LIMIT 5;
'
--------
[sql_execute][Количество: 1| Время: 0.0012sec| Максимальное: 0.0012sec]
'UPDATE orders_feed SET views = views + 1 WHERE id_order = 191255'
--------
[sql_execute][Количество: 1| Время: 0.0012sec| Максимальное: 0.0012sec]
'SELECT f.* FROM orders o
JOIN orders o2 ON o.predmet_id = o2.predmet_id AND o.worktype_id = o2.worktype_id
JOIN feedback f on o2.id = f.order_id AND f.public="Y"
WHERE o.id =191255 LIMIT 5'
--------
[db_class][Количество: 1| Время: 0.0024089813232422| Максимальное: 0.0024089813232422]
'SELECT DISTINCT
`f`.`id` AS `f_id`,
`f`.`fkey` AS `f_fkey`,
`f`.`name` AS `f_name`,
`f`.`address` AS `f_address`,
`f`.`phone` AS `f_phone`,
`f`.`email` AS `f_email`,
`f`.`descr` AS `f_descr`,
`f`.`is_foreign` AS `f_is_foreign`,
`f`.`active` AS `f_active`,
`f`.`subdomain` AS `f_subdomain`,
`f`.`is_office` AS `f_is_office`,
`c`.`id` AS `c_id`,
`c`.`name` AS `c_name`,
`c`.`text` AS `c_text`,
`c`.`title` AS `c_title`,
`c`.`keywords` AS `c_keywords`,
`c`.`description` AS `c_description`

FROM `filials` `f`
LEFT JOIN `city` `c` ON `f`.`city_id` = `c`.`id`
WHERE `f`.`active` = \'Y\'

ORDER BY
`c`.`name` ASC,
`f`.`name` ASC'
--------
[db_class][Количество: 1| Время: 0.0024938583374023| Максимальное: 0.0024938583374023]
'SELECT
`p`.`id` AS `p_id`,
`p`.`parent` AS `p_parent`,
`p`.`tkey` AS `p_tkey`,
`p`.`value` AS `p_value`,
`pp`.`tkey` AS `pp_tkey`
FROM `pref` `p`
INNER JOIN `pref_parts` `pp` ON `p`.`parent` = `pp`.`id`
WHERE
`pp`.`tkey` IN (\'arkhangelsk_contacts\',\'astrahan_contacts\',\'barnaul_contacts\',\'belgorod_contacts\',\'bryansk_contacts\',\'velikiy-novgorod_contacts\',\'vladivostok_contacts\',\'vladkav_contacts\',\'vladimir_contacts\',\'volgograd_contacts\',\'vologda_contacts\',\'voronezh_contacts\',\'grozny_contacts\',\'ek_contacts\',\'ivanovo_contacts\',\'izhevsk_contacts\',\'irkutsk_contacts\',\'joshkar-ola_contacts\',\'kazan_contacts\',\'kaliningrad_contacts\',\'kaluga_contacts\',\'kemerovo_contacts\',\'kirov_contacts\',\'krasnodar_contacts\',\'krasnoyarsk_contacts\',\'kursk_contacts\',\'kyzyl_contacts\',\'lipeck_contacts\',\'magas_contacts\',\'magnitogorsk_contacts\',\'mhchkl_contacts\',\'msk_contacts\',\'murmansk_contacts\',\'naberezhnye-chelny_contacts\',\'nalchik_contacts\',\'nizhnevartovsk_contacts\',\'nnov_contacts\',\'novokuznetsk_contacts\',\'nsk_contacts\',\'omsk_contacts\',\'orel_contacts\',\'orenburg_contacts\',\'penza_contacts\',\'perm_contacts\',\'petrozavodsk_contacts\',\'podolsk_contacts\',\'rostov_contacts\',\'ryazan_contacts\',\'samara_contacts\',\'spb_contacts\',\'saransk_contacts\',\'saratov_contacts\',\'sevastopol_contacts\',\'sochi_contacts\',\'stvrp_contacts\',\'surgut_contacts\',\'syktyvkar_contacts\',\'tver_contacts\',\'togliatti_contacts\',\'tomsk_contacts\',\'tyumen_contacts\',\'ulan-ude_contacts\',\'ulyanovsk_contacts\',\'ufa_contacts\',\'hanty-mansiysk_contacts\',\'cheboksary_contacts\',\'chelyabinsk_contacts\',\'cherepovec_contacts\',\'cherk_contacts\',\'elista_contacts\',\'yakutsk_contacts\',\'yaroslavl_contacts\');'
--------
[sql_execute][Количество: 1| Время: 0.0031sec| Максимальное: 0.0031sec]
'SELECT tkey, predmet FROM cityarticles WHERE parent =(SELECT id FROM cityarticles WHERE tkey = \'kurs\') ORDER BY predmet'
--------
[db_class][Количество: 5| Время: 0.0031640529632568| Максимальное: 0.00089907646179199]
'SELECT `p`.`value`, `p`.`descr` FROM `pref` `p`
INNER JOIN `pref_parts` `pp` ON (`p`.`parent` = `pp`.`id`)
WHERE `p`.`tkey` = ? AND `pp`.`tkey` = ? LIMIT 1'
--------
[db_class][Количество: 1| Время: 0.006227970123291| Максимальное: 0.006227970123291]
'SELECT `tkey`, `name` FROM `author_predmets_parts` WHERE active=\'Y\' AND parent > 0 ORDER BY `pos` ASC, `name` ASC'
--------
[db_class][Количество: 1| Время: 0.010045051574707| Максимальное: 0.010045051574707]
'SELECT `id`,`active`,`article_key`,`article_title`,`article_text`,`meta_title`,`meta_description`,`meta_keywords`,
`crumb`,`predmet_id`,`predmet_key`,`predmet_group_id`,`predmet_group_area_id`,`popular`,`author_name`,`article_date`
FROM `spravochnik`
WHERE 1 AND `active` = :active AND `predmet_key` = :predmet_key
ORDER BY RAND() ASC
'
--------
[db_class][Количество: 2| Время: 0.010766983032227| Максимальное: 0.0054709911346436]
'SELECT `id`, `title`, `subtitle`, `text`, `url`, `meta_title`, `meta_description`, `meta_keywords`, `crumb`, `active`
FROM `seotext`
WHERE 1 AND `url` = :url AND `active` = :active
'
--------
[db_class][Количество: 1| Время: 0.019593954086304| Максимальное: 0.019593954086304]
'SELECT
#DISTINCT
COUNT(1) as `count`
FROM `catalog` `c`

INNER JOIN `catalog_parts` `p` ON `p`.`id` = `c`.`parent`
INNER JOIN `catalog_parts` `pg` ON `pg`.`id` = `p`.`parent` LEFT JOIN `members` `m` ON `m`.`id` = `c`.`author` LEFT JOIN `catalog_views` `cv` ON `cv`.`id_catalog` = `c`.`id`
WHERE 1
AND `c`.`active` = \'Y\' AND `p`.`active` = \'Y\' AND `pg`.`active` = \'Y\' AND `p`.`parent` > 0 AND `pg`.`parent` = 0 AND `p`.`url_name` = :predmet

ORDER BY `c`.`name` ASC
;'
--------
[db_class][Количество: 1| Время: 0.036427021026611| Максимальное: 0.036427021026611]
'SELECT
#DISTINCT

`c`.`id` AS `c_id`,
`c`.`name` AS `c_name`,
`c`.`type_work` AS `c_type_work`,
`c`.`count_page` AS `c_count_page`,
`c`.`count_sources` AS `c_count_sources`,
`c`.`data` AS `c_data`,
`c`.`price` AS `c_price`,
`c`.`copyright` AS `c_copyright`,
`c`.`active` AS `c_active`,
`c`.`vuz` AS `c_vuz`,
`c`.`number_kurs` AS `c_number_kurs`,
`c`.`originality` AS `c_originality`,
`c`.`operator` AS `c_operator`,
`c`.`author` AS `c_author`,
`c`.`comments` AS `c_comments`,
`c`.`status` AS `c_status`,
`cv`.`views` AS `c_views`,
`c`.`price_calc` AS `c_price_calc`,
`m`.`name` AS `m_name`,
`m`.`workplace` AS `m_workplace`,
(SELECT COUNT(*) FROM basket_parts WHERE basket_parts.work = c.id) AS bp_count,
`p`.`id` AS `predmet_id`,
`p`.`predmet_id` AS `predmet_id_citiarticles`,
`p`.`name` AS `predmet_name`,
`p`.`url_name` AS `predmet_url_name`,
`pg`.`id` AS `predmet_group_id`,
`pg`.`name` AS `predmet_group_name`,
`pg`.`url_name` AS `predmet_group_url_name`
FROM `catalog` `c`

INNER JOIN `catalog_parts` `p` ON `p`.`id` = `c`.`parent`
INNER JOIN `catalog_parts` `pg` ON `pg`.`id` = `p`.`parent` LEFT JOIN `members` `m` ON `m`.`id` = `c`.`author` LEFT JOIN `catalog_views` `cv` ON `cv`.`id_catalog` = `c`.`id`
WHERE 1
AND `c`.`active` = \'Y\' AND `p`.`active` = \'Y\' AND `pg`.`active` = \'Y\' AND `p`.`parent` > 0 AND `pg`.`parent` = 0 AND `p`.`url_name` = :predmet

ORDER BY `c`.`name` ASC
LIMIT 0, 5;'
--------
[db_class][Количество: 1| Время: 0.54176497459412| Максимальное: 0.54176497459412]
'SELECT cp.url_name, cp.name,c.type_work FROM catalog c
JOIN catalog_parts cp on c.parent = cp.id
WHERE c.active = \'Y\' AND c.type_work NOT IN(\'dissertatsija\',\'disser_part\',\'magisterskaya\',\'statya-vak\',\'statya_rinc\',\'nauchnaya_statya\',\'article_simple\',\'dorabotka\',\'povorig\',\'chertezhi\',\'chertezhi_a0\',\'chertezhi_a1\',\'chertezhi_a2\',\'prezentacija\',\'chertezhi_a3\',\'chertezhi_a4\',\'annotaciya\',\'recenziya\',\'otchet_prak\',\'aspirant_referat\',\'graficheskoe_izobrazhenie\',\'programm\',\'recenziya\',\'oformlenie\',\'free_plan\',\'tezisnyi_plan\') AND cp.active = \'Y\' AND cp.parent>0 GROUP BY predmet_id, c.type_work ORDER BY cp.name'
--------
[db_class][Количество: 1| Время: 0.94797205924988| Максимальное: 0.94797205924988]
'SELECT wt.tkey, wt.name FROM orders_feed of
LEFT JOIN orders o ON o.id = of.id_order
LEFT JOIN worktypes wt ON wt.tkey = o.type_work GROUP BY wt.id'
--------
[db_class][Количество: 1| Время: 0.96929502487183| Максимальное: 0.96929502487183]
'SELECT o.type_work, app.name, app.tkey FROM orders_feed `of`
LEFT JOIN orders o ON o.id = `of`.id_order
LEFT JOIN author_predmets_parts app on o.predmet_id = app.id
LEFT JOIN author_predmets_parts app2 on app.parent = app2.id
WHERE of.deleted = 0 AND o.type_work IN(\'kurs\',\'diplom\',\'refer\') GROUP BY app.tkey ORDER BY app.name'
--------

--------
SQL count: 12
PDO count: 30
Executing time - 2.6042sec
07.11.2024 08:46:49