Dotaz cislo:1
SELECT Name, Value FROM _config

Dotaz cislo:2
SELECT * FROM _language WHERE Id=1
select properties of object language
Dotaz cislo:3
SELECT * FROM template_page2lang WHERE Domain = 'dev.ai-shop.cz'
select properties of object template_page
Dotaz cislo:4
SELECT * FROM redirects WHERE URLOld='-53'
select id of inserted redirects from db
Dotaz cislo:5
SELECT * FROM virtual_directory2lang WHERE Name LIKE '-53'
select properties of object virtual_directory2lang
Dotaz cislo:6
SELECT * FROM virtual_directory WHERE Id=5403
select properties of object virtual_directory
Dotaz cislo:7
SELECT * FROM virtual_directory2lang WHERE IdDirectory = 5403
select properties of object VirtualDirectory2lang::=Get
Dotaz cislo:8
SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '5403'
select properties of object virtual_directpry_set
Dotaz cislo:9
SELECT * FROM _language WHERE Id=2
select properties of object language
Dotaz cislo:10
SELECT * FROM virtual_directory WHERE Id=5403
select properties of object virtual_directory
Dotaz cislo:11
SELECT * FROM virtual_directory2lang WHERE IdDirectory=5403 AND IdLanguage=2
select properties of object virtual_directory2lang
Dotaz cislo:12
SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '5403'
select properties of object virtual_directpry_set
Dotaz cislo:13
SELECT * FROM exchange WHERE Id='112';
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsExchange.php on line 186 in method Cexchange::loadById
Dotaz cislo:14
SELECT Id, CONCAT(Name,' ',Surname) as Login,LogPassword,LogPasswordType, LogHash FROM security_user SU WHERE ((LogName='!Annonym') AND Flags&1) OR (LogHash ='' AND Loghash IS NOT NULL AND Loghash <>'' AND LogHashExpire > NOW() )
login user
Dotaz cislo:15
SELECT su.*, c.IdCostType as CostTypeId, c.Rabat as CompanyDiscount, sct.Discount as CostTypeDiscount, c.Flags & 128=128 as CompanyIndividualPrice, sct.ViewPriceWithVat, a.IdState FROM security_user su LEFT JOIN company2user c2u ON c2u.IdUser = su.Id /*AND c2u.IdType = 1*/ LEFT JOIN company c ON c.Id=c2u.IdCompany LEFT JOIN address a ON a.Id=c.IdPayementAddress LEFT JOIN shop_cost_type sct ON sct.Id=c.IdCostType WHERE su.Id=2 ORDER BY c2u.IdType LIMIT 0, 1
select properties of object security_user
Dotaz cislo:16
SELECT * FROM security_user2group WHERE IdUser=2
select groups of security_user
Dotaz cislo:17
call getRightsForUser(2, 52)
load rights
Dotaz cislo:18
SELECT * FROM company2user WHERE (1=1) AND IdUser = '2'
select properties of object company2user
Dotaz cislo:19
SELECT * FROM company WHERE Id=1
select properties of object company
Dotaz cislo:20
SELECT * FROM company2user WHERE (1=1) AND IdCompany = '1'
select properties of object company2user
Dotaz cislo:21
SELECT su.*, c.IdCostType as CostTypeId, c.Rabat as CompanyDiscount, sct.Discount as CostTypeDiscount, c.Flags & 128=128 as CompanyIndividualPrice, sct.ViewPriceWithVat, a.IdState FROM security_user su LEFT JOIN company2user c2u ON c2u.IdUser = su.Id /*AND c2u.IdType = 1*/ LEFT JOIN company c ON c.Id=c2u.IdCompany LEFT JOIN address a ON a.Id=c.IdPayementAddress LEFT JOIN shop_cost_type sct ON sct.Id=c.IdCostType WHERE su.Id=2 ORDER BY c2u.IdType LIMIT 0, 1
select properties of object security_user
Dotaz cislo:22
SELECT * FROM security_user2group WHERE IdUser=2
select groups of security_user
Dotaz cislo:23
SELECT * FROM template_page
select properties of object template_page
Dotaz cislo:24
SELECT * FROM template_page WHERE Id=29
select properties of object template_page
Dotaz cislo:25
SELECT * FROM template_page2lang WHERE IdPage=29 AND IdLanguage=2
select properties of object template_page
AiShop | Toys
Dotaz cislo:314
SELECT * FROM section WHERE Id=237
select properties of object section
Dotaz cislo:315
SELECT * FROM section_sec2lang WHERE IdSection=237 AND IdLanguage=2
select properties of object section_sec2lang
Dotaz cislo:316
SELECT * FROM section WHERE Id=263
select properties of object section
Dotaz cislo:317
SELECT * FROM section_sec2lang WHERE IdSection=263 AND IdLanguage=2
select properties of object section_sec2lang

Dotaz cislo:318
call getRightsForUser(2, 78)
load rights
Dotaz cislo:319
SELECT s.Id, s.IdParent as IdParent, s2l.Title as Title , '' as TargetTarget , s2l.Link as Name , s2l.Flags FROM menu_items s INNER JOIN menu_items2lang s2l ON s.Id=s2l.IdMenuItem AND s2l.IdLanguage = 2 AND s2l.Flags & 1 /*INNER JOIN virtual_directory vd ON vd.IdSecuritySection=s.IdSecuritySection AND vd.IdItem=s.IdItem INNER JOIN virtual_directory2lang vd2l ON vd.Id = vd2l.IdDirectory AND vd2l.IdLanguage=2*/ WHERE s.IdParent=1 AND s.Id IN (0, 1, 255, 256, 257, 258, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 284, 286, 287, 288, 289, 290, 291, 292, 294, 295, 296, 297, 298, 299, 300) ORDER BY colOrder LIMIT 7

Dotaz cislo:326
SELECT * FROM section WHERE Id=263
select properties of object section
Dotaz cislo:327
SELECT * FROM section_sec2lang WHERE IdSection=263 AND IdLanguage=2
select properties of object section_sec2lang

Dotaz cislo:336
SELECT v2l.Name, v2l.IdTargetType FROM virtual_directory v INNER JOIN virtual_directory2lang v2l ON v.Id=v2l.IdDirectory AND v2l.IdLanguage=2 WHERE v.IdItem=1 AND v.IdSecuritySection = 33
select id of inserted virtual_directory from db
Dotaz cislo:341
call getRightsForUser(2, 61)
load rights
Dotaz cislo:342
SELECT * FROM banner_creator WHERE Id=6
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsBannerCreator.php on line 143 in method CBannerCreator::load
Dotaz cislo:343
SELECT * FROM section WHERE Id=190
select properties of object section
Dotaz cislo:344
SELECT * FROM section_sec2lang WHERE IdSection=190 AND IdLanguage=2
select properties of object section_sec2lang
Dotaz cislo:345
SELECT * FROM section s INNER JOIN section_sec2lang s2l ON s2l.IdSection = s.Id AND s2l.IdLanguage=2 AND s2l.Flags & 1=1 WHERE IdParent=190 ORDER BY colOrder LIMIT 3
section by parent /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsSection.php on line 395 in method CSection::getActiveByParent

Warning: Trying to access array offset on value of type null in /mnt/storage1/vhosts/ai-shop.cz/web/dev/_themes_files/aishop-8/theme-parts/data-section/benefits.php on line 43

Warning: Trying to access array offset on value of type null in /mnt/storage1/vhosts/ai-shop.cz/web/dev/_themes_files/aishop-8/theme-parts/data-section/benefits.php on line 43

Warning: Trying to access array offset on value of type null in /mnt/storage1/vhosts/ai-shop.cz/web/dev/_themes_files/aishop-8/theme-parts/data-section/benefits.php on line 43


Warning: Trying to access array offset on value of type null in /mnt/storage1/vhosts/ai-shop.cz/web/dev/_themes_files/aishop-8/theme-parts/data-section/benefits.php on line 49

Warning: Trying to access array offset on value of type null in /mnt/storage1/vhosts/ai-shop.cz/web/dev/_themes_files/aishop-8/theme-parts/data-section/benefits.php on line 49

Warning: Trying to access array offset on value of type null in /mnt/storage1/vhosts/ai-shop.cz/web/dev/_themes_files/aishop-8/theme-parts/data-section/benefits.php on line 49


Warning: Trying to access array offset on value of type null in /mnt/storage1/vhosts/ai-shop.cz/web/dev/_themes_files/aishop-8/theme-parts/data-section/benefits.php on line 50

Warning: Trying to access array offset on value of type null in /mnt/storage1/vhosts/ai-shop.cz/web/dev/_themes_files/aishop-8/theme-parts/data-section/benefits.php on line 50

Warning: Trying to access array offset on value of type null in /mnt/storage1/vhosts/ai-shop.cz/web/dev/_themes_files/aishop-8/theme-parts/data-section/benefits.php on line 50


Warning: Trying to access array offset on value of type null in /mnt/storage1/vhosts/ai-shop.cz/web/dev/_themes_files/aishop-8/theme-parts/data-section/benefits.php on line 43

Warning: Trying to access array offset on value of type null in /mnt/storage1/vhosts/ai-shop.cz/web/dev/_themes_files/aishop-8/theme-parts/data-section/benefits.php on line 43

Warning: Trying to access array offset on value of type null in /mnt/storage1/vhosts/ai-shop.cz/web/dev/_themes_files/aishop-8/theme-parts/data-section/benefits.php on line 43


Warning: Trying to access array offset on value of type null in /mnt/storage1/vhosts/ai-shop.cz/web/dev/_themes_files/aishop-8/theme-parts/data-section/benefits.php on line 49

Warning: Trying to access array offset on value of type null in /mnt/storage1/vhosts/ai-shop.cz/web/dev/_themes_files/aishop-8/theme-parts/data-section/benefits.php on line 49

Warning: Trying to access array offset on value of type null in /mnt/storage1/vhosts/ai-shop.cz/web/dev/_themes_files/aishop-8/theme-parts/data-section/benefits.php on line 49


Warning: Trying to access array offset on value of type null in /mnt/storage1/vhosts/ai-shop.cz/web/dev/_themes_files/aishop-8/theme-parts/data-section/benefits.php on line 50

Warning: Trying to access array offset on value of type null in /mnt/storage1/vhosts/ai-shop.cz/web/dev/_themes_files/aishop-8/theme-parts/data-section/benefits.php on line 50

Warning: Trying to access array offset on value of type null in /mnt/storage1/vhosts/ai-shop.cz/web/dev/_themes_files/aishop-8/theme-parts/data-section/benefits.php on line 50

Dotaz cislo:26
SELECT DISTINCT t.Id, t2l.Name, t.Color FROM shop_cat_tree t INNER JOIN shop_cat_tree2lang t2l ON t2l.IdCat = t.Id AND t2l.IdLanguage = 2 AND (t2l.Flags & 1) AND (t2l.Flags & 8) LEFT JOIN shop_cat2img t2i ON t2i.IdCategory = t.Id ORDER BY t.colOrder
fulltext in shop cats
Dotaz cislo:27
SELECT * FROM shop_cat2img WHERE (1=1) AND IdCategory = '410' AND Flags & '4' ORDER BY colOrder
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopCat.php on line 1388 in method CShopCat2Img::get
Dotaz cislo:28
SELECT * FROM images WHERE Id=1501
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Dotaz cislo:29
SELECT v2l.Name, v2l.IdTargetType FROM virtual_directory v INNER JOIN virtual_directory2lang v2l ON v.Id=v2l.IdDirectory AND v2l.IdLanguage=2 WHERE v.IdItem=410 AND v.IdSecuritySection = 16
select id of inserted virtual_directory from db
Dotaz cislo:30
call sp_shop_article_list_subarticles( 2, false, 1, 2, 1, 0, 0.00, 0.00, 0, '', '0', '0', 132, 0, 0, '', 4194304, '', 0, 99993, 1 /*smer razeni*/, true, true, 0, 0, 2, 1);
nebylo zadano
Dotaz cislo:31
call sp_shop_article_list_subarticles( 2, false, 1, 2, 1, 0, 0.00, 0.00, 0, '', '0', '0', 132, 0, 0, '', 4194304, '', 0, 99993, 1 /*smer razeni*/, true, true, 0, 4, 1, 1);
function DoSql() in PAGING file pag.php
    Dotaz cislo:32
    SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1827
    nebylo zadano
    Dotaz cislo:33
    SELECT * FROM shop_cat_tree WHERE Id=92
    select properties of object shop category
    Dotaz cislo:34
    SELECT * FROM shop_cat_tree2lang WHERE IdCat=92 AND IdLanguage=1
    select properties of object shop_cat_tree2lang
    Dotaz cislo:35
    SELECT * FROM virtual_directory WHERE IdItem = 92 AND IdSecuritySection = 16
    select properties of object VirtualDirectory::=Get
    Dotaz cislo:36
    SELECT * FROM virtual_directory2lang WHERE IdDirectory=7331 AND IdLanguage=1
    select properties of object virtual_directory2lang
    Dotaz cislo:37
    SELECT * FROM shop_cost_vat WHERE Id=8
    select properties of object shop cost vat
    Dotaz cislo:38
    SELECT * FROM images WHERE Id=925
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
    Dotaz cislo:39
    SELECT * FROM shop_storage WHERE Id=3
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3445 in method CShopStorage::load
    Dotaz cislo:40
    SELECT * FROM shop_storage2lang WHERE IdStorage = '3' ORDER BY Name
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3646 in method CShopStorage2Lang::get
    Dotaz cislo:41
    SELECT * FROM shop_storage_count WHERE IdStorage=3 AND CountFrom<=0 AND CountTo>=0
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3732 in method CShopStorageCount::getValue
  • : ab1827
     
     
    11,82 €
    Dotaz cislo:42
    SELECT * FROM shop_pack WHERE (1=1) AND IdArticle LIKE '1827'
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 2311 in method CShopPack::get
    Dotaz cislo:43
    SELECT * FROM images WHERE Id=1327
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
    External store
  • Dotaz cislo:44
    SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1822
    nebylo zadano
    Dotaz cislo:45
    SELECT * FROM shop_cat_tree WHERE Id=91
    select properties of object shop category
    Dotaz cislo:46
    SELECT * FROM shop_cat_tree2lang WHERE IdCat=91 AND IdLanguage=1
    select properties of object shop_cat_tree2lang
    Dotaz cislo:47
    SELECT * FROM virtual_directory WHERE IdItem = 91 AND IdSecuritySection = 16
    select properties of object VirtualDirectory::=Get
    Dotaz cislo:48
    SELECT * FROM virtual_directory2lang WHERE IdDirectory=7391 AND IdLanguage=1
    select properties of object virtual_directory2lang
    Dotaz cislo:49
    SELECT * FROM images WHERE Id=914
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
    Dotaz cislo:50
    SELECT * FROM shop_storage WHERE Id=1
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3445 in method CShopStorage::load
    Dotaz cislo:51
    SELECT * FROM shop_storage2lang WHERE IdStorage = '1' ORDER BY Name
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3646 in method CShopStorage2Lang::get
    Dotaz cislo:52
    SELECT * FROM shop_storage_count WHERE IdStorage=1 AND CountFrom<=1 AND CountTo>=1
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3732 in method CShopStorageCount::getValue
  • Dotaz cislo:53
    SELECT * FROM shop_art2flag WHERE IdArticle=1822 AND ((TimeFrom=CURRENT_DATE OR (TimeTo IS NULL))
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 10714 in method CShopArt2Flag::getActiveForArticle
    Dotaz cislo:54
    SELECT * FROM shop_flag WHERE Id=2
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 9899 in method CShopFlag::load
    Dotaz cislo:55
    SELECT * FROM shop_flag2lang WHERE IdFlag =2 AND IdLanguage =2
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 10187 in method CShopFlag2Lang::load
    Dotaz cislo:56
    SELECT * FROM shop_flag2cat WHERE IdFlag = '2' ORDER BY colOrder ASC
    select properties of object CShopFlag2Cat
    Dotaz cislo:57
    SELECT * FROM images WHERE Id=628
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
    Dotaz cislo:58
    SELECT * FROM shop_flag WHERE Id=3
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 9899 in method CShopFlag::load
    Dotaz cislo:59
    SELECT * FROM shop_flag2lang WHERE IdFlag =3 AND IdLanguage =2
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 10187 in method CShopFlag2Lang::load
    Dotaz cislo:60
    SELECT * FROM shop_flag2cat WHERE IdFlag = '3' ORDER BY colOrder ASC
    select properties of object CShopFlag2Cat
    Dotaz cislo:61
    SELECT * FROM images WHERE Id=1038
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
    Dotaz cislo:62
    SELECT * FROM shop_flag WHERE Id=4
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 9899 in method CShopFlag::load
    Dotaz cislo:63
    SELECT * FROM shop_flag2lang WHERE IdFlag =4 AND IdLanguage =2
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 10187 in method CShopFlag2Lang::load
    Dotaz cislo:64
    SELECT * FROM shop_flag2cat WHERE IdFlag = '4' ORDER BY colOrder ASC
    select properties of object CShopFlag2Cat
    : dph21
     
     
    46,66 €
    Dotaz cislo:65
    SELECT * FROM shop_pack WHERE (1=1) AND IdArticle LIKE '1822'
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 2311 in method CShopPack::get
    Dotaz cislo:66
    SELECT * FROM images WHERE Id=611
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
    In Store
  • Dotaz cislo:67
    SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1821
    nebylo zadano
    Dotaz cislo:68
    SELECT * FROM shop_cat_tree WHERE Id=91
    select properties of object shop category
    Dotaz cislo:69
    SELECT * FROM shop_cat_tree2lang WHERE IdCat=91 AND IdLanguage=1
    select properties of object shop_cat_tree2lang
    Dotaz cislo:70
    SELECT * FROM virtual_directory WHERE IdItem = 91 AND IdSecuritySection = 16
    select properties of object VirtualDirectory::=Get
    Dotaz cislo:71
    SELECT * FROM virtual_directory2lang WHERE IdDirectory=7391 AND IdLanguage=1
    select properties of object virtual_directory2lang
    Dotaz cislo:72
    SELECT * FROM shop_producer WHERE Id=16
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 213 in method CShopProducer::load
    Dotaz cislo:73
    SELECT * FROM _language ORDER BY colOrder ASC
    select properties of object language
    Dotaz cislo:74
    SELECT * FROM shop_producer2lang WHERE IdProducer=16 AND IdLanguage=1
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 488 in method CShopProducer2Lang::load
    Dotaz cislo:75
    SELECT * FROM shop_producer2lang WHERE IdProducer=16 AND IdLanguage=2
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 488 in method CShopProducer2Lang::load
    Dotaz cislo:76
    SELECT * FROM shop_producer2lang WHERE IdProducer=16 AND IdLanguage=5
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 488 in method CShopProducer2Lang::load
    Dotaz cislo:77
    SELECT * FROM virtual_directory WHERE IdItem = 16 AND IdSecuritySection = 65
    select properties of object VirtualDirectory::=Get
    Dotaz cislo:78
    SELECT * FROM virtual_directory2lang WHERE IdDirectory=7408 AND IdLanguage=2
    select properties of object virtual_directory2lang
    Dotaz cislo:79
    SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7408'
    select properties of object virtual_directpry_set
    Dotaz cislo:80
    SELECT * FROM virtual_directory WHERE Id=7408
    select properties of object virtual_directory
    Dotaz cislo:81
    SELECT * FROM virtual_directory2lang WHERE IdDirectory = 7408
    select properties of object VirtualDirectory2lang::=Get
    Dotaz cislo:82
    SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7408'
    select properties of object virtual_directpry_set
    Dotaz cislo:83
    SELECT * FROM images WHERE Id=916
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
    Dotaz cislo:84
    SELECT * FROM shop_storage_count WHERE IdStorage=3 AND CountFrom<=0 AND CountTo>=0
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3732 in method CShopStorageCount::getValue
  • : C3PO
     
     
    3,2 €
    Dotaz cislo:85
    SELECT * FROM shop_pack WHERE (1=1) AND IdArticle LIKE '1821'
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 2311 in method CShopPack::get
    External store
  • Dotaz cislo:86
    SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1817
    nebylo zadano
    Dotaz cislo:87
    SELECT * FROM shop_cat_tree WHERE Id=89
    select properties of object shop category
    Dotaz cislo:88
    SELECT * FROM shop_cat_tree2lang WHERE IdCat=89 AND IdLanguage=1
    select properties of object shop_cat_tree2lang
    Dotaz cislo:89
    SELECT * FROM virtual_directory WHERE IdItem = 89 AND IdSecuritySection = 16
    select properties of object VirtualDirectory::=Get
    Dotaz cislo:90
    SELECT * FROM virtual_directory2lang WHERE IdDirectory=7400 AND IdLanguage=1
    select properties of object virtual_directory2lang
    Dotaz cislo:91
    SELECT * FROM shop_cat_tree WHERE Id=87
    select properties of object shop category
    Dotaz cislo:92
    SELECT * FROM shop_cat_tree2lang WHERE IdCat=87 AND IdLanguage=1
    select properties of object shop_cat_tree2lang
    Dotaz cislo:93
    SELECT * FROM virtual_directory WHERE IdItem = 87 AND IdSecuritySection = 16
    select properties of object VirtualDirectory::=Get
    Dotaz cislo:94
    SELECT * FROM virtual_directory2lang WHERE IdDirectory=7282 AND IdLanguage=1
    select properties of object virtual_directory2lang
    Dotaz cislo:95
    SELECT * FROM images WHERE Id=906
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
    Dotaz cislo:96
    SELECT * FROM shop_storage_count WHERE IdStorage=1 AND CountFrom<=77 AND CountTo>=77
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3732 in method CShopStorageCount::getValue
  • : ab1817
     
     
    2,07 €
    Dotaz cislo:97
    SELECT * FROM shop_pack WHERE (1=1) AND IdArticle LIKE '1817'
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 2311 in method CShopPack::get
    In Store
Dotaz cislo:98
SELECT * FROM section WHERE Id=249
select properties of object section
Dotaz cislo:99
SELECT * FROM section_sec2lang WHERE IdSection=249 AND IdLanguage=2
select properties of object section_sec2lang
Dotaz cislo:100
call getRightsForUser(2, 36)
load rights
Dotaz cislo:101
SELECT * FROM section WHERE Id=251
select properties of object section
Dotaz cislo:102
SELECT * FROM section_sec2lang WHERE IdSection=251 AND IdLanguage=2
select properties of object section_sec2lang
Dotaz cislo:103
call sp_shop_article_list_subarticles( 2, false, 1, 2, 1, 0, 0.00, 0.00, 0, '', '0', '0', 132, 0, 0, '', 128, '', 0, 0, 0 /*smer razeni*/, true, true, 0, 0, 2, 1);
nebylo zadano
Dotaz cislo:104
call sp_shop_article_list_subarticles( 2, false, 1, 2, 1, 0, 0.00, 0.00, 0, '', '0', '0', 132, 0, 0, '', 128, '', 0, 0, 0 /*smer razeni*/, true, true, 0, 4, 1, 1);
function DoSql() in PAGING file pag.php
    Dotaz cislo:105
    SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1814
    nebylo zadano
    Dotaz cislo:106
    SELECT * FROM shop_cat_tree WHERE Id=90
    select properties of object shop category
    Dotaz cislo:107
    SELECT * FROM shop_cat_tree2lang WHERE IdCat=90 AND IdLanguage=1
    select properties of object shop_cat_tree2lang
    Dotaz cislo:108
    SELECT * FROM virtual_directory WHERE IdItem = 90 AND IdSecuritySection = 16
    select properties of object VirtualDirectory::=Get
    Dotaz cislo:109
    SELECT * FROM virtual_directory2lang WHERE IdDirectory=7389 AND IdLanguage=1
    select properties of object virtual_directory2lang
    Dotaz cislo:110
    SELECT * FROM shop_producer WHERE Id=14
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 213 in method CShopProducer::load
    Dotaz cislo:111
    SELECT * FROM _language ORDER BY colOrder ASC
    select properties of object language
    Dotaz cislo:112
    SELECT * FROM shop_producer2lang WHERE IdProducer=14 AND IdLanguage=1
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 488 in method CShopProducer2Lang::load
    Dotaz cislo:113
    SELECT * FROM shop_producer2lang WHERE IdProducer=14 AND IdLanguage=2
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 488 in method CShopProducer2Lang::load
    Dotaz cislo:114
    SELECT * FROM shop_producer2lang WHERE IdProducer=14 AND IdLanguage=5
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 488 in method CShopProducer2Lang::load
    Dotaz cislo:115
    SELECT * FROM virtual_directory WHERE IdItem = 14 AND IdSecuritySection = 65
    select properties of object VirtualDirectory::=Get
    Dotaz cislo:116
    SELECT * FROM virtual_directory2lang WHERE IdDirectory=7356 AND IdLanguage=2
    select properties of object virtual_directory2lang
    Dotaz cislo:117
    SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7356'
    select properties of object virtual_directpry_set
    Dotaz cislo:118
    SELECT * FROM virtual_directory WHERE Id=7356
    select properties of object virtual_directory
    Dotaz cislo:119
    SELECT * FROM virtual_directory2lang WHERE IdDirectory = 7356
    select properties of object VirtualDirectory2lang::=Get
    Dotaz cislo:120
    SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7356'
    select properties of object virtual_directpry_set
    Dotaz cislo:121
    SELECT * FROM shop_cost_vat WHERE Id=8
    select properties of object shop cost vat
    Dotaz cislo:122
    SELECT * FROM images WHERE Id=903
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
    Dotaz cislo:123
    SELECT * FROM shop_storage WHERE Id=1
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3445 in method CShopStorage::load
    Dotaz cislo:124
    SELECT * FROM shop_storage2lang WHERE IdStorage = '1' ORDER BY Name
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3646 in method CShopStorage2Lang::get
    Dotaz cislo:125
    SELECT * FROM shop_storage_count WHERE IdStorage=1 AND CountFrom<=1 AND CountTo>=1
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3732 in method CShopStorageCount::getValue
  • : ab1814
     
     
    1,08 €
    Dotaz cislo:126
    SELECT * FROM shop_pack WHERE (1=1) AND IdArticle LIKE '1814'
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 2311 in method CShopPack::get
    Dotaz cislo:127
    SELECT * FROM images WHERE Id=611
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
    In Store
  • Dotaz cislo:128
    SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1813
    nebylo zadano
    Dotaz cislo:129
    SELECT * FROM shop_cat_tree WHERE Id=90
    select properties of object shop category
    Dotaz cislo:130
    SELECT * FROM shop_cat_tree2lang WHERE IdCat=90 AND IdLanguage=1
    select properties of object shop_cat_tree2lang
    Dotaz cislo:131
    SELECT * FROM virtual_directory WHERE IdItem = 90 AND IdSecuritySection = 16
    select properties of object VirtualDirectory::=Get
    Dotaz cislo:132
    SELECT * FROM virtual_directory2lang WHERE IdDirectory=7389 AND IdLanguage=1
    select properties of object virtual_directory2lang
    Dotaz cislo:133
    SELECT * FROM images WHERE Id=901
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
    Dotaz cislo:134
    SELECT * FROM shop_storage WHERE Id=3
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3445 in method CShopStorage::load
    Dotaz cislo:135
    SELECT * FROM shop_storage2lang WHERE IdStorage = '3' ORDER BY Name
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3646 in method CShopStorage2Lang::get
    Dotaz cislo:136
    SELECT * FROM shop_storage_count WHERE IdStorage=3 AND CountFrom<=0 AND CountTo>=0
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3732 in method CShopStorageCount::getValue
  • : ab1813
     
     
    1,18 €
    Dotaz cislo:137
    SELECT * FROM shop_pack WHERE (1=1) AND IdArticle LIKE '1813'
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 2311 in method CShopPack::get
    Dotaz cislo:138
    SELECT * FROM images WHERE Id=1327
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
    External store
  • Dotaz cislo:139
    SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1931
    nebylo zadano
    Dotaz cislo:140
    SELECT * FROM shop_cat_tree WHERE Id=87
    select properties of object shop category
    Dotaz cislo:141
    SELECT * FROM shop_cat_tree2lang WHERE IdCat=87 AND IdLanguage=1
    select properties of object shop_cat_tree2lang
    Dotaz cislo:142
    SELECT * FROM virtual_directory WHERE IdItem = 87 AND IdSecuritySection = 16
    select properties of object VirtualDirectory::=Get
    Dotaz cislo:143
    SELECT * FROM virtual_directory2lang WHERE IdDirectory=7282 AND IdLanguage=1
    select properties of object virtual_directory2lang
    Dotaz cislo:144
    SELECT * FROM shop_producer WHERE Id=14
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 213 in method CShopProducer::load
    Dotaz cislo:145
    SELECT * FROM _language ORDER BY colOrder ASC
    select properties of object language
    Dotaz cislo:146
    SELECT * FROM shop_producer2lang WHERE IdProducer=14 AND IdLanguage=1
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 488 in method CShopProducer2Lang::load
    Dotaz cislo:147
    SELECT * FROM shop_producer2lang WHERE IdProducer=14 AND IdLanguage=2
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 488 in method CShopProducer2Lang::load
    Dotaz cislo:148
    SELECT * FROM shop_producer2lang WHERE IdProducer=14 AND IdLanguage=5
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 488 in method CShopProducer2Lang::load
    Dotaz cislo:149
    SELECT * FROM virtual_directory WHERE IdItem = 14 AND IdSecuritySection = 65
    select properties of object VirtualDirectory::=Get
    Dotaz cislo:150
    SELECT * FROM virtual_directory2lang WHERE IdDirectory=7356 AND IdLanguage=2
    select properties of object virtual_directory2lang
    Dotaz cislo:151
    SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7356'
    select properties of object virtual_directpry_set
    Dotaz cislo:152
    SELECT * FROM virtual_directory WHERE Id=7356
    select properties of object virtual_directory
    Dotaz cislo:153
    SELECT * FROM virtual_directory2lang WHERE IdDirectory = 7356
    select properties of object VirtualDirectory2lang::=Get
    Dotaz cislo:154
    SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7356'
    select properties of object virtual_directpry_set
    Dotaz cislo:155
    SELECT * FROM images WHERE Id=1099
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
    Dotaz cislo:156
    SELECT * FROM shop_storage_count WHERE IdStorage=3 AND CountFrom<=0 AND CountTo>=0
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3732 in method CShopStorageCount::getValue
  • : AiviAiviab1810
     
     
    1,87 €
    Dotaz cislo:157
    SELECT * FROM shop_pack WHERE (1=1) AND IdArticle LIKE '1931'
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 2311 in method CShopPack::get
    External store
  • Dotaz cislo:158
    SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1930
    nebylo zadano
    Dotaz cislo:159
    SELECT * FROM shop_cat_tree WHERE Id=87
    select properties of object shop category
    Dotaz cislo:160
    SELECT * FROM shop_cat_tree2lang WHERE IdCat=87 AND IdLanguage=1
    select properties of object shop_cat_tree2lang
    Dotaz cislo:161
    SELECT * FROM virtual_directory WHERE IdItem = 87 AND IdSecuritySection = 16
    select properties of object VirtualDirectory::=Get
    Dotaz cislo:162
    SELECT * FROM virtual_directory2lang WHERE IdDirectory=7282 AND IdLanguage=1
    select properties of object virtual_directory2lang
    Dotaz cislo:163
    SELECT * FROM shop_producer WHERE Id=14
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 213 in method CShopProducer::load
    Dotaz cislo:164
    SELECT * FROM _language ORDER BY colOrder ASC
    select properties of object language
    Dotaz cislo:165
    SELECT * FROM shop_producer2lang WHERE IdProducer=14 AND IdLanguage=1
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 488 in method CShopProducer2Lang::load
    Dotaz cislo:166
    SELECT * FROM shop_producer2lang WHERE IdProducer=14 AND IdLanguage=2
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 488 in method CShopProducer2Lang::load
    Dotaz cislo:167
    SELECT * FROM shop_producer2lang WHERE IdProducer=14 AND IdLanguage=5
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 488 in method CShopProducer2Lang::load
    Dotaz cislo:168
    SELECT * FROM virtual_directory WHERE IdItem = 14 AND IdSecuritySection = 65
    select properties of object VirtualDirectory::=Get
    Dotaz cislo:169
    SELECT * FROM virtual_directory2lang WHERE IdDirectory=7356 AND IdLanguage=2
    select properties of object virtual_directory2lang
    Dotaz cislo:170
    SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7356'
    select properties of object virtual_directpry_set
    Dotaz cislo:171
    SELECT * FROM virtual_directory WHERE Id=7356
    select properties of object virtual_directory
    Dotaz cislo:172
    SELECT * FROM virtual_directory2lang WHERE IdDirectory = 7356
    select properties of object VirtualDirectory2lang::=Get
    Dotaz cislo:173
    SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7356'
    select properties of object virtual_directpry_set
    Dotaz cislo:174
    SELECT * FROM images WHERE Id=1098
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
    Dotaz cislo:175
    SELECT * FROM shop_storage_count WHERE IdStorage=3 AND CountFrom<=0 AND CountTo>=0
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3732 in method CShopStorageCount::getValue
  • : AiviAiviab1809
     
     
    1,87 €
    Dotaz cislo:176
    SELECT * FROM shop_pack WHERE (1=1) AND IdArticle LIKE '1930'
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 2311 in method CShopPack::get
    External store
Dotaz cislo:177
SELECT * FROM section WHERE Id=262
select properties of object section
Dotaz cislo:178
SELECT * FROM section_sec2lang WHERE IdSection=262 AND IdLanguage=2
select properties of object section_sec2lang
Dotaz cislo:179
SELECT al.Name, CASE WHEN a.IdParent = 0 THEN al.ShortName ELSE '' END AS ShortName , al.Description, al.Flags as LangFlags, al.SubName, a.*, a2i.IdImage, a2i2.IdImage as IdImageParent, mu.Value as MUName, vd2l.Name as DirectoryName, sum(oi.Count) as Cnt, true as IdFlag FROM shop_article a INNER JOIN shop_art2lang al ON al.IdArticle=a.Id AND al.IdLanguage = 2 INNER JOIN shop_order_items oi ON a.Id=oi.IdArticle INNER JOIN shop_cost sc ON sc.IdArticle=oi.IdArticle AND sc.IdType=3 AND sc.value>0 INNER JOIN shop_order o ON o.Id=oi.IdOrder AND date_sub(CURDATE(), INTERVAL 30 DAY) <= o.InsertTime AND o.Status >= 11 LEFT JOIN shop_art2img a2i ON a2i.IdArticle=a.Id AND a2i.colOrder = (SELECT MIN(colOrder) FROM shop_art2img WHERE IdArticle=a.Id ORDER BY colOrder LIMIT 1) LEFT JOIN shop_art2img a2i2 ON a2i2.IdArticle=a.IdParent AND a2i2.colOrder = (SELECT MIN(colOrder) FROM shop_art2img WHERE IdArticle=a.IdParent ORDER BY colOrder LIMIT 1) LEFT JOIN shop_mu mu ON mu.Id=a.IdMU AND mu.IdLanguage=2 INNER JOIN virtual_directory vd ON vd.IdSecuritySection = 17 AND vd.IdItem = a.Id INNER JOIN virtual_directory2lang vd2l ON vd.Id = vd2l.IdDirectory AND vd2l.IdLanguage=2 WHERE al.Flags&1 GROUP BY IFNULL(a.IdParent, a.Id) ORDER BY Cnt DESC, a.Id DESC LIMIT 0, 10

Dotaz cislo:180
SELECT * FROM shop_article WHERE Id=1905
select properties of object shop article
Dotaz cislo:181
SELECT * FROM shop_art2lang WHERE IdArticle = 1905 AND IdLanguage = 2
select shop_art2lang
Dotaz cislo:182
SELECT * FROM shop_art2cat WHERE IdArticle = '1905'
select properties of object CShopArt2Cat
Dotaz cislo:183
SELECT * FROM shop_art2serie WHERE IdArticle = '1905'
select properties of object CShopArt2Cat
Dotaz cislo:184
SELECT * FROM shop_art2img WHERE shop_art2img.IdArticle = '1905' ORDER BY colOrder
select properties of object CShopArt2Img
Dotaz cislo:185
SELECT * FROM shop_art2file WHERE IdArticle = '1905' ORDER BY colOrder
select properties of object CShopArt2File
Dotaz cislo:186
SELECT * FROM shop_attributes WHERE IdArticle = '1905' ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:187
SELECT * FROM shop_attributes2lang WHERE IdAttribute = 580 AND IdLanguage = 2
select properties of object shop_attributes2lang
Dotaz cislo:188
SELECT * FROM shop_attributes2lang WHERE IdAttribute = 583 AND IdLanguage = 2
select properties of object shop_attributes2lang
Dotaz cislo:189
SELECT * FROM shop_attributes2lang WHERE IdAttribute = 581 AND IdLanguage = 2
select properties of object shop_attributes2lang
Dotaz cislo:190
SELECT * FROM shop_attributes2lang WHERE IdAttribute = 635 AND IdLanguage = 2
select properties of object shop_attributes2lang
Dotaz cislo:191
SELECT * FROM shop_art2flag WHERE IdArticle = '1905' ORDER BY RAND()
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 10694 in method CShopArt2Flag::get
Dotaz cislo:192
SELECT * FROM shop_art2vat WHERE IdArticle = '1905'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 11764 in method CShopArt2Vat::get
Dotaz cislo:193
SELECT * FROM shop_anchor WHERE IdArticle = '1905' ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:194
SELECT * FROM shop_anchor2lang WHERE IdAnchor=1 AND IdLanguage=2
select properties of object shop_attributes2lang
Dotaz cislo:195
SELECT * FROM virtual_directory WHERE IdItem = 1905 AND IdSecuritySection = 17
select properties of object VirtualDirectory::=Get
Dotaz cislo:196
SELECT * FROM virtual_directory2lang WHERE IdDirectory=5627 AND IdLanguage=2
select properties of object virtual_directory2lang
Dotaz cislo:197
SELECT Value FROM shop_cost_vat WHERE Id=( SELECT IFNULL(a2v.IdVat, a.IdVat) FROM shop_article a LEFT JOIN shop_art2vat a2v ON a2v.IdArticle=a.Id AND a2v.IdState=132 WHERE Id=1905)
nebylo zadano
Dotaz cislo:198
SELECT (c.Value*IF(a.Flags&256, 1,((100-ct.Discount)/100))) as UsersCost, (c2.Value*IF(a.Flags&256, 1,((100-ct.Discount)/100))) as CountCost, a.Flags, a.Id FROM shop_article a LEFT JOIN shop_cost c ON c.IdArticle=a.Id AND c.IdCompany IS NULL AND c.MinCount IS NULL AND c.IdCompany IS NULL AND c.IdType=3 LEFT JOIN shop_cost_type ct ON ct.Id=c.IdType LEFT JOIN shop_cost c2 ON c2.IdArticle=a.Id AND c2.MinCount<=1 AND c2.IdCompany IS NULL WHERE (a.Id=1905 OR a.IdParent=1905) AND c.ValueWithVAT>0 ORDER BY c2.Value ASC, c.Value ASC LIMIT 0,1
select vat to article
Dotaz cislo:199
SELECT * FROM shop_discount WHERE (1=1) AND IdArticle = '1905' AND IdCostType = '3' AND TimeFrom < '2025-07-05 21:55:07' AND TimeTo > '2025-07-05 21:55:07' AND Flags & '1'
select properties of object shop_discount_quantity
Dotaz cislo:200
SELECT * FROM shop_cost_vat WHERE Id=8
select properties of object shop cost vat
Dotaz cislo:201
SELECT * FROM shop_cost WHERE (1=1) AND IdArticle = 1905 AND IdType = 3 AND IdCompany IS NULL
select properties of object CShopCost
Dotaz cislo:202
SELECT * FROM shop_article WHERE Id=1821
select properties of object shop article
Dotaz cislo:203
SELECT * FROM shop_art2lang WHERE IdArticle = 1821 AND IdLanguage = 2
select shop_art2lang
Dotaz cislo:204
SELECT * FROM shop_art2cat WHERE IdArticle = '1821'
select properties of object CShopArt2Cat
Dotaz cislo:205
SELECT * FROM shop_art2serie WHERE IdArticle = '1821'
select properties of object CShopArt2Cat
Dotaz cislo:206
SELECT * FROM shop_art2img WHERE shop_art2img.IdArticle = '1821' ORDER BY colOrder
select properties of object CShopArt2Img
Dotaz cislo:207
SELECT * FROM shop_art2file WHERE IdArticle = '1821' ORDER BY colOrder
select properties of object CShopArt2File
Dotaz cislo:208
SELECT * FROM shop_attributes WHERE IdArticle = '1821' ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:209
SELECT * FROM shop_art2flag WHERE IdArticle = '1821' ORDER BY RAND()
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 10694 in method CShopArt2Flag::get
Dotaz cislo:210
SELECT * FROM shop_art2vat WHERE IdArticle = '1821'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 11764 in method CShopArt2Vat::get
Dotaz cislo:211
SELECT * FROM shop_anchor WHERE IdArticle = '1821' ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:212
SELECT * FROM virtual_directory WHERE IdItem = 1821 AND IdSecuritySection = 17
select properties of object VirtualDirectory::=Get
Dotaz cislo:213
SELECT * FROM virtual_directory2lang WHERE IdDirectory=5461 AND IdLanguage=2
select properties of object virtual_directory2lang
Dotaz cislo:214
SELECT Value FROM shop_cost_vat WHERE Id=( SELECT IFNULL(a2v.IdVat, a.IdVat) FROM shop_article a LEFT JOIN shop_art2vat a2v ON a2v.IdArticle=a.Id AND a2v.IdState=132 WHERE Id=1821)
nebylo zadano
Dotaz cislo:215
SELECT (c.Value*IF(a.Flags&256, 1,((100-ct.Discount)/100))) as UsersCost, (c2.Value*IF(a.Flags&256, 1,((100-ct.Discount)/100))) as CountCost, a.Flags, a.Id FROM shop_article a LEFT JOIN shop_cost c ON c.IdArticle=a.Id AND c.IdCompany IS NULL AND c.MinCount IS NULL AND c.IdCompany IS NULL AND c.IdType=3 LEFT JOIN shop_cost_type ct ON ct.Id=c.IdType LEFT JOIN shop_cost c2 ON c2.IdArticle=a.Id AND c2.MinCount<=1 AND c2.IdCompany IS NULL WHERE (a.Id=1821 OR a.IdParent=1821) AND c.ValueWithVAT>0 ORDER BY c2.Value ASC, c.Value ASC LIMIT 0,1
select vat to article
Dotaz cislo:216
SELECT * FROM shop_discount WHERE (1=1) AND IdArticle = '1821' AND IdCostType = '3' AND TimeFrom < '2025-07-05 21:55:07' AND TimeTo > '2025-07-05 21:55:07' AND Flags & '1'
select properties of object shop_discount_quantity
Dotaz cislo:217
SELECT * FROM shop_cost WHERE (1=1) AND IdArticle = 1821 AND IdType = 3 AND IdCompany IS NULL
select properties of object CShopCost
Dotaz cislo:218
SELECT * FROM shop_article WHERE Id=1817
select properties of object shop article
Dotaz cislo:219
SELECT * FROM shop_art2lang WHERE IdArticle = 1817 AND IdLanguage = 2
select shop_art2lang
Dotaz cislo:220
SELECT * FROM shop_art2cat WHERE IdArticle = '1817'
select properties of object CShopArt2Cat
Dotaz cislo:221
SELECT * FROM shop_art2serie WHERE IdArticle = '1817'
select properties of object CShopArt2Cat
Dotaz cislo:222
SELECT * FROM shop_art2img WHERE shop_art2img.IdArticle = '1817' ORDER BY colOrder
select properties of object CShopArt2Img
Dotaz cislo:223
SELECT * FROM shop_art2file WHERE IdArticle = '1817' ORDER BY colOrder
select properties of object CShopArt2File
Dotaz cislo:224
SELECT * FROM shop_attributes WHERE IdArticle = '1817' ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:225
SELECT * FROM shop_attributes2lang WHERE IdAttribute = 668 AND IdLanguage = 2
select properties of object shop_attributes2lang
Dotaz cislo:226
SELECT * FROM shop_art2flag WHERE IdArticle = '1817' ORDER BY RAND()
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 10694 in method CShopArt2Flag::get
Dotaz cislo:227
SELECT * FROM shop_art2vat WHERE IdArticle = '1817'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 11764 in method CShopArt2Vat::get
Dotaz cislo:228
SELECT * FROM shop_anchor WHERE IdArticle = '1817' ORDER BY colOrder
select properties of object CShopAttributes
Dotaz cislo:229
SELECT * FROM virtual_directory WHERE IdItem = 1817 AND IdSecuritySection = 17
select properties of object VirtualDirectory::=Get
Dotaz cislo:230
SELECT * FROM virtual_directory2lang WHERE IdDirectory=5457 AND IdLanguage=2
select properties of object virtual_directory2lang
Dotaz cislo:231
SELECT Value FROM shop_cost_vat WHERE Id=( SELECT IFNULL(a2v.IdVat, a.IdVat) FROM shop_article a LEFT JOIN shop_art2vat a2v ON a2v.IdArticle=a.Id AND a2v.IdState=132 WHERE Id=1817)
nebylo zadano
Dotaz cislo:232
SELECT (c.Value*IF(a.Flags&256, 1,((100-ct.Discount)/100))) as UsersCost, (c2.Value*IF(a.Flags&256, 1,((100-ct.Discount)/100))) as CountCost, a.Flags, a.Id FROM shop_article a LEFT JOIN shop_cost c ON c.IdArticle=a.Id AND c.IdCompany IS NULL AND c.MinCount IS NULL AND c.IdCompany IS NULL AND c.IdType=3 LEFT JOIN shop_cost_type ct ON ct.Id=c.IdType LEFT JOIN shop_cost c2 ON c2.IdArticle=a.Id AND c2.MinCount<=1 AND c2.IdCompany IS NULL WHERE (a.Id=1817 OR a.IdParent=1817) AND c.ValueWithVAT>0 ORDER BY c2.Value ASC, c.Value ASC LIMIT 0,1
select vat to article
Dotaz cislo:233
SELECT * FROM shop_discount WHERE (1=1) AND IdArticle = '1817' AND IdCostType = '3' AND TimeFrom < '2025-07-05 21:55:07' AND TimeTo > '2025-07-05 21:55:07' AND Flags & '1'
select properties of object shop_discount_quantity
Dotaz cislo:234
SELECT * FROM shop_cost WHERE (1=1) AND IdArticle = 1817 AND IdType = 3 AND IdCompany IS NULL
select properties of object CShopCost
    Dotaz cislo:235
    SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1905
    nebylo zadano
    Dotaz cislo:236
    SELECT * FROM shop_cat_tree WHERE Id=87
    select properties of object shop category
    Dotaz cislo:237
    SELECT * FROM shop_cat_tree2lang WHERE IdCat=87 AND IdLanguage=1
    select properties of object shop_cat_tree2lang
    Dotaz cislo:238
    SELECT * FROM virtual_directory WHERE IdItem = 87 AND IdSecuritySection = 16
    select properties of object VirtualDirectory::=Get
    Dotaz cislo:239
    SELECT * FROM virtual_directory2lang WHERE IdDirectory=7282 AND IdLanguage=1
    select properties of object virtual_directory2lang
    Dotaz cislo:240
    SELECT * FROM shop_producer WHERE Id=14
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 213 in method CShopProducer::load
    Dotaz cislo:241
    SELECT * FROM _language ORDER BY colOrder ASC
    select properties of object language
    Dotaz cislo:242
    SELECT * FROM shop_producer2lang WHERE IdProducer=14 AND IdLanguage=1
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 488 in method CShopProducer2Lang::load
    Dotaz cislo:243
    SELECT * FROM shop_producer2lang WHERE IdProducer=14 AND IdLanguage=2
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 488 in method CShopProducer2Lang::load
    Dotaz cislo:244
    SELECT * FROM shop_producer2lang WHERE IdProducer=14 AND IdLanguage=5
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 488 in method CShopProducer2Lang::load
    Dotaz cislo:245
    SELECT * FROM virtual_directory WHERE IdItem = 14 AND IdSecuritySection = 65
    select properties of object VirtualDirectory::=Get
    Dotaz cislo:246
    SELECT * FROM virtual_directory2lang WHERE IdDirectory=7356 AND IdLanguage=2
    select properties of object virtual_directory2lang
    Dotaz cislo:247
    SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7356'
    select properties of object virtual_directpry_set
    Dotaz cislo:248
    SELECT * FROM virtual_directory WHERE Id=7356
    select properties of object virtual_directory
    Dotaz cislo:249
    SELECT * FROM virtual_directory2lang WHERE IdDirectory = 7356
    select properties of object VirtualDirectory2lang::=Get
    Dotaz cislo:250
    SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7356'
    select properties of object virtual_directpry_set
    Dotaz cislo:251
    SELECT * FROM shop_cost_vat WHERE Id=8
    select properties of object shop cost vat
    Dotaz cislo:252
    SELECT * FROM images WHERE Id=928
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
    Dotaz cislo:253
    SELECT * FROM shop_storage WHERE Id=1
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3445 in method CShopStorage::load
    Dotaz cislo:254
    SELECT * FROM shop_storage2lang WHERE IdStorage = '1' ORDER BY Name
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3646 in method CShopStorage2Lang::get
    Dotaz cislo:255
    SELECT * FROM shop_storage_count WHERE IdStorage=1 AND CountFrom<=199 AND CountTo>=199
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3732 in method CShopStorageCount::getValue
  • 57,84 €
    20%
    Dotaz cislo:256
    SELECT * FROM shop_art2flag WHERE IdArticle=1905 AND ((TimeFrom=CURRENT_DATE OR (TimeTo IS NULL))
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 10714 in method CShopArt2Flag::getActiveForArticle
    Dotaz cislo:257
    SELECT * FROM shop_flag WHERE Id=2
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 9899 in method CShopFlag::load
    Dotaz cislo:258
    SELECT * FROM shop_flag2lang WHERE IdFlag =2 AND IdLanguage =2
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 10187 in method CShopFlag2Lang::load
    Dotaz cislo:259
    SELECT * FROM shop_flag2cat WHERE IdFlag = '2' ORDER BY colOrder ASC
    select properties of object CShopFlag2Cat
    Dotaz cislo:260
    SELECT * FROM images WHERE Id=628
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
    Dotaz cislo:261
    SELECT * FROM shop_flag WHERE Id=3
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 9899 in method CShopFlag::load
    Dotaz cislo:262
    SELECT * FROM shop_flag2lang WHERE IdFlag =3 AND IdLanguage =2
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 10187 in method CShopFlag2Lang::load
    Dotaz cislo:263
    SELECT * FROM shop_flag2cat WHERE IdFlag = '3' ORDER BY colOrder ASC
    select properties of object CShopFlag2Cat
    Dotaz cislo:264
    SELECT * FROM images WHERE Id=1038
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
    Dotaz cislo:265
    SELECT * FROM shop_flag WHERE Id=5
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 9899 in method CShopFlag::load
    Dotaz cislo:266
    SELECT * FROM shop_flag2lang WHERE IdFlag =5 AND IdLanguage =2
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 10187 in method CShopFlag2Lang::load
    Dotaz cislo:267
    SELECT * FROM shop_flag2cat WHERE IdFlag = '5' ORDER BY colOrder ASC
    select properties of object CShopFlag2Cat
    Das VW auto
    : testimport
     
    57,84 €
    46,27 €
    Dotaz cislo:268
    SELECT * FROM shop_pack WHERE (1=1) AND IdArticle LIKE '1905'
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 2311 in method CShopPack::get
    Dotaz cislo:269
    SELECT * FROM images WHERE Id=611
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
    In Store
  • Dotaz cislo:270
    SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1821
    nebylo zadano
    Dotaz cislo:271
    SELECT * FROM shop_cat_tree WHERE Id=91
    select properties of object shop category
    Dotaz cislo:272
    SELECT * FROM shop_cat_tree2lang WHERE IdCat=91 AND IdLanguage=1
    select properties of object shop_cat_tree2lang
    Dotaz cislo:273
    SELECT * FROM virtual_directory WHERE IdItem = 91 AND IdSecuritySection = 16
    select properties of object VirtualDirectory::=Get
    Dotaz cislo:274
    SELECT * FROM virtual_directory2lang WHERE IdDirectory=7391 AND IdLanguage=1
    select properties of object virtual_directory2lang
    Dotaz cislo:275
    SELECT * FROM shop_producer WHERE Id=16
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 213 in method CShopProducer::load
    Dotaz cislo:276
    SELECT * FROM _language ORDER BY colOrder ASC
    select properties of object language
    Dotaz cislo:277
    SELECT * FROM shop_producer2lang WHERE IdProducer=16 AND IdLanguage=1
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 488 in method CShopProducer2Lang::load
    Dotaz cislo:278
    SELECT * FROM shop_producer2lang WHERE IdProducer=16 AND IdLanguage=2
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 488 in method CShopProducer2Lang::load
    Dotaz cislo:279
    SELECT * FROM shop_producer2lang WHERE IdProducer=16 AND IdLanguage=5
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 488 in method CShopProducer2Lang::load
    Dotaz cislo:280
    SELECT * FROM virtual_directory WHERE IdItem = 16 AND IdSecuritySection = 65
    select properties of object VirtualDirectory::=Get
    Dotaz cislo:281
    SELECT * FROM virtual_directory2lang WHERE IdDirectory=7408 AND IdLanguage=2
    select properties of object virtual_directory2lang
    Dotaz cislo:282
    SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7408'
    select properties of object virtual_directpry_set
    Dotaz cislo:283
    SELECT * FROM virtual_directory WHERE Id=7408
    select properties of object virtual_directory
    Dotaz cislo:284
    SELECT * FROM virtual_directory2lang WHERE IdDirectory = 7408
    select properties of object VirtualDirectory2lang::=Get
    Dotaz cislo:285
    SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7408'
    select properties of object virtual_directpry_set
    Dotaz cislo:286
    SELECT * FROM images WHERE Id=916
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
    Dotaz cislo:287
    SELECT * FROM shop_storage WHERE Id=3
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3445 in method CShopStorage::load
    Dotaz cislo:288
    SELECT * FROM shop_storage2lang WHERE IdStorage = '3' ORDER BY Name
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3646 in method CShopStorage2Lang::get
    Dotaz cislo:289
    SELECT * FROM shop_storage_count WHERE IdStorage=3 AND CountFrom<=0 AND CountTo>=0
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3732 in method CShopStorageCount::getValue
  • Dotaz cislo:290
    SELECT * FROM shop_art2flag WHERE IdArticle=1821 AND ((TimeFrom=CURRENT_DATE OR (TimeTo IS NULL))
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 10714 in method CShopArt2Flag::getActiveForArticle
    : C3PO
     
     
    3,2 €
    Dotaz cislo:291
    SELECT * FROM shop_pack WHERE (1=1) AND IdArticle LIKE '1821'
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 2311 in method CShopPack::get
    Dotaz cislo:292
    SELECT * FROM images WHERE Id=1327
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
    External store
  • Dotaz cislo:293
    SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1817
    nebylo zadano
    Dotaz cislo:294
    SELECT * FROM shop_cat_tree WHERE Id=89
    select properties of object shop category
    Dotaz cislo:295
    SELECT * FROM shop_cat_tree2lang WHERE IdCat=89 AND IdLanguage=1
    select properties of object shop_cat_tree2lang
    Dotaz cislo:296
    SELECT * FROM virtual_directory WHERE IdItem = 89 AND IdSecuritySection = 16
    select properties of object VirtualDirectory::=Get
    Dotaz cislo:297
    SELECT * FROM virtual_directory2lang WHERE IdDirectory=7400 AND IdLanguage=1
    select properties of object virtual_directory2lang
    Dotaz cislo:298
    SELECT * FROM shop_cat_tree WHERE Id=87
    select properties of object shop category
    Dotaz cislo:299
    SELECT * FROM shop_cat_tree2lang WHERE IdCat=87 AND IdLanguage=1
    select properties of object shop_cat_tree2lang
    Dotaz cislo:300
    SELECT * FROM virtual_directory WHERE IdItem = 87 AND IdSecuritySection = 16
    select properties of object VirtualDirectory::=Get
    Dotaz cislo:301
    SELECT * FROM virtual_directory2lang WHERE IdDirectory=7282 AND IdLanguage=1
    select properties of object virtual_directory2lang
    Dotaz cislo:302
    SELECT * FROM images WHERE Id=906
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
    Dotaz cislo:303
    SELECT * FROM shop_storage_count WHERE IdStorage=1 AND CountFrom<=77 AND CountTo>=77
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 3732 in method CShopStorageCount::getValue
  • Dotaz cislo:304
    SELECT * FROM shop_art2flag WHERE IdArticle=1817 AND ((TimeFrom=CURRENT_DATE OR (TimeTo IS NULL))
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 10714 in method CShopArt2Flag::getActiveForArticle
    : ab1817
     
     
    2,07 €
    Dotaz cislo:305
    SELECT * FROM shop_pack WHERE (1=1) AND IdArticle LIKE '1817'
    question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 2311 in method CShopPack::get
    In Store
Dotaz cislo:306
call getRightsForUser(2, 18)
load rights

Dotaz cislo:307
SELECT DISTINCT news.*, n2l.*, DATE_FORMAT(news.Date,'%d.%m.%Y') as date, i.Filename, i.isBig, i.Alt FROM news INNER JOIN news2lang n2l ON n2l.IdNews = news.Id AND n2l.IdLanguage = 2 AND n2l.Flags & 1 INNER JOIN news2cat c ON c.IdNews=news.Id LEFT JOIN images i ON i.Id=news.IdImage WHERE 1=1 AND now() < DateTo AND now() > DateFrom AND news.Flags & 1 ORDER BY news.Date DESC LIMIT 4
selct news from db
Dotaz cislo:308
call getRightsForUser(2, 17)
load rights

Dotaz cislo:309
SELECT * FROM shop_heureka WHERE (1=1) AND Flags & 1 AND (Plus<>'' OR Minus<>'' OR Summary<>'') ORDER BY Inserted DESC LIMIT 4
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsHeurekaOvereno.php on line 870 in method CShopHeureka::get
Ověřený zákazník
14.01.2025
má objednávka produktů byla velmi rychle vyřízená
rychlost, spolehlivost
Ověřený zákazník
13.01.2025
Velký výběr
Dobré ceny
Bleskově dodani
Ověřený zákazník
13.01.2025
Rychlé dodání..
Ověřený zákazník
11.01.2025
Rychlé bezproblémové dodání

Dotaz cislo:310
SELECT * FROM section WHERE Id=224
select properties of object section
Dotaz cislo:311
SELECT * FROM section_sec2lang WHERE IdSection=224 AND IdLanguage=2
select properties of object section_sec2lang
Dotaz cislo:312
SELECT * FROM section WHERE Id=266
select properties of object section
Dotaz cislo:313
SELECT * FROM section_sec2lang WHERE IdSection=266 AND IdLanguage=2
select properties of object section_sec2lang

Dotaz cislo:350
call getRightsForUser(2, 34)
load rights
Dotaz cislo:351
SELECT v2l.Name, v2l.IdTargetType FROM virtual_directory v INNER JOIN virtual_directory2lang v2l ON v.Id=v2l.IdDirectory AND v2l.IdLanguage=2 WHERE v.IdItem=169 AND v.IdSecuritySection = 1
select id of inserted virtual_directory from db