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='webove-stranky-test-article-without-variants-1'
select id of inserted redirects from db Dotaz cislo:5 SELECT *
FROM virtual_directory2lang
WHERE Name LIKE 'webove-stranky-test-article-without-variants-1' select properties of object virtual_directory2lang Dotaz cislo:6 SELECT *
FROM virtual_directory
WHERE Id=5575 select properties of object virtual_directory Dotaz cislo:7 SELECT *
FROM virtual_directory2lang WHERE IdDirectory = 5575 select properties of object VirtualDirectory2lang::=Get Dotaz cislo:8 SELECT s.*
FROM virtual_directory_set s
WHERE s.IdDirectory = '5575' 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=5575 select properties of object virtual_directory Dotaz cislo:11 SELECT * FROM virtual_directory2lang
WHERE IdDirectory=5575 AND
IdLanguage=2 select properties of object virtual_directory2lang Dotaz cislo:12 SELECT s.*
FROM virtual_directory_set s
WHERE s.IdDirectory = '5575' 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 | Quality E-Shop
Dotaz cislo:84 SELECT *
FROM section
WHERE Id=237 select properties of object section Dotaz cislo:85 SELECT * FROM section_sec2lang
WHERE IdSection=237 AND
IdLanguage=2 select properties of object section_sec2lang
Dotaz cislo:86 SELECT *
FROM section
WHERE Id=263 select properties of object section Dotaz cislo:87 SELECT * FROM section_sec2lang
WHERE IdSection=263 AND
IdLanguage=2 select properties of object section_sec2lang
Dotaz cislo:88 call getRightsForUser(2, 78) load rights Dotaz cislo:89 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 6
Dotaz cislo:92 SELECT *
FROM section
WHERE Id=263 select properties of object section Dotaz cislo:93 SELECT * FROM section_sec2lang
WHERE IdSection=263 AND
IdLanguage=2 select properties of object section_sec2lang
Dotaz cislo:94 SELECT * FROM virtual_directory2lang
WHERE IdDirectory=6127 AND
IdLanguage=2 select properties of object virtual_directory2lang Dotaz cislo:95 SELECT * FROM virtual_directory2lang
WHERE IdDirectory=2163 AND
IdLanguage=2 select properties of object virtual_directory2lang
Dotaz cislo:97 SELECT *
FROM _language WHERE (1=1) AND Flags & '1'
ORDER BY colOrder ASC select properties of object language
Dotaz cislo:98 SELECT *
FROM exchange WHERE (1=1) AND Flags & '1'
ORDER BY colOrder ASC question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsExchange.php on line 312 in method Cexchange::get
Dotaz cislo:99 SELECT *
FROM section
WHERE Id=119 select properties of object section Dotaz cislo:100 SELECT * FROM section_sec2lang
WHERE IdSection=119 AND
IdLanguage=2 select properties of object section_sec2lang
Dotaz cislo:102 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:103 SELECT c.Id as Id, c.IdParent, CASE WHEN c2l.ShortName != '' THEN c2l.ShortName ELSE c2l.Name END AS Name, vd2l.`Name` as VD, i.Filename as Img, /*i2.Filename as Img2,*/ c.Color, c2l.Flags FlagsLang
FROM shop_cat_tree c
INNER JOIN shop_cat_tree2lang c2l ON c.Id=c2l.IdCat AND c2l.Flags & 1 = 1 AND c2l.IdLanguage = 2
INNER JOIN virtual_directory vd ON vd.IdSecuritySection=16 AND c.Id=vd.IdItem
INNER JOIN virtual_directory2lang vd2l ON vd2l.IdDirectory=vd.Id AND vd2l.IdLanguage=2
LEFT JOIN shop_cat2img c2i ON c2i.IdCategory = c.Id AND c2i.Flags & 4
LEFT JOIN images i ON i.Id = c2i.IdImage
/*LEFT JOIN shop_cat2img c2i2 ON c2i2.IdCategory = c.Id AND c2i2.Flags & 1
LEFT JOIN images i2 ON i2.Id = c2i2.IdImage*/
WHERE
/*c.IdParent<>0
AND ((c.Id in () AND c.IdParent=0) OR (c.IdParent<>0 AND c.IdParent<>0))
AND c.Id in () AND c.Flags & 1 AND*/ c2l.Name<>''
ORDER BY /*c.IdParent,*/ c.colOrder
Dotaz cislo:104 SELECT i2l.* FROM menu_items i INNER JOIN menu_items2lang i2l ON i.Id=i2l.IdMenuItem AND i2l.IdLanguage=2 AND i2l.Flags & 1 WHERE i.IdParent=268 ORDER BY colOrder nebylo zadano Dotaz cislo:105 SELECT *
FROM images
WHERE Id=1299 question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load Dotaz cislo:106 SELECT *
FROM images
WHERE Id=1287 question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Dotaz cislo:110 SELECT t1.*, t2.*
FROM shop_producer t1
INNER JOIN shop_producer2lang t2 ON t2.IdProducer = t1.Id AND t2.IdLanguage = 2
ORDER BY t2.Name question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 322 in method CShopProducer::get Dotaz cislo:111 SELECT *
FROM shop_producer2lang WHERE IdProducer = '14'
select properties of object shop_search2art_cat Dotaz cislo:112 SELECT *
FROM shop_producer2lang WHERE IdProducer = '16'
select properties of object shop_search2art_cat
Dotaz cislo:113 SELECT *
FROM section
WHERE Id=201 select properties of object section Dotaz cislo:114 SELECT * FROM section_sec2lang
WHERE IdSection=201 AND
IdLanguage=2 select properties of object section_sec2lang
Dotaz cislo:115 SELECT *
FROM section
WHERE Id=17 select properties of object section Dotaz cislo:116 SELECT * FROM section_sec2lang
WHERE IdSection=17 AND
IdLanguage=2 select properties of object section_sec2lang
Dotaz cislo:26 SELECT *
FROM shop_article
WHERE Id=1879 select properties of object shop article Dotaz cislo:27 SELECT *
FROM shop_art2lang
WHERE IdArticle = 1879 AND
IdLanguage = 2 select shop_art2lang Dotaz cislo:28 SELECT *
FROM shop_art2cat WHERE IdArticle = '1879' select properties of object CShopArt2Cat Dotaz cislo:29 SELECT *
FROM shop_art2serie WHERE IdArticle = '1879' select properties of object CShopArt2Cat Dotaz cislo:30 SELECT *
FROM shop_art2img WHERE shop_art2img.IdArticle = '1879'
ORDER BY colOrder select properties of object CShopArt2Img Dotaz cislo:31 SELECT *
FROM shop_art2file WHERE IdArticle = '1879'
ORDER BY colOrder select properties of object CShopArt2File Dotaz cislo:32 SELECT *
FROM shop_attributes WHERE IdArticle = '1879'
ORDER BY colOrder select properties of object CShopAttributes Dotaz cislo:33 SELECT *
FROM shop_art2flag WHERE IdArticle = '1879' 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:34 SELECT *
FROM shop_art2vat WHERE IdArticle = '1879'
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShopArt.php on line 11764 in method CShopArt2Vat::get Dotaz cislo:35 SELECT *
FROM shop_anchor WHERE IdArticle = '1879'
ORDER BY colOrder select properties of object CShopAttributes Dotaz cislo:36 SELECT *
FROM virtual_directory WHERE IdItem = 1879 AND IdSecuritySection = 17 select properties of object VirtualDirectory::=Get Dotaz cislo:37 SELECT * FROM virtual_directory2lang
WHERE IdDirectory=5575 AND
IdLanguage=2 select properties of object virtual_directory2lang Dotaz cislo:38 SELECT *
FROM shop_mu
WHERE Id=2 AND
IdLanguage=2 select properties of object CShopMU Dotaz cislo:39 SELECT count(Id) as cnt FROM shop_article WHERE IdParent=1879 nebylo zadano Dotaz cislo:40 SELECT *
FROM shop_cat_tree
WHERE Id=86 select properties of object shop category Dotaz cislo:41 SELECT * FROM shop_cat_tree2lang
WHERE IdCat=86 AND
IdLanguage=1 select properties of object shop_cat_tree2lang Dotaz cislo:42 SELECT *
FROM virtual_directory WHERE IdItem = 86 AND IdSecuritySection = 16 select properties of object VirtualDirectory::=Get Dotaz cislo:43 SELECT * FROM virtual_directory2lang
WHERE IdDirectory=7409 AND
IdLanguage=1 select properties of object virtual_directory2lang Dotaz cislo:44 SELECT *
FROM shop_cost_vat
WHERE Id=8 select properties of object shop cost vat Dotaz cislo:45 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:46 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:47 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=1879) nebylo zadano Dotaz cislo:48 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=1879 OR a.IdParent=1879) AND c.ValueWithVAT>0
ORDER BY c2.Value ASC, c.Value ASC
LIMIT 0,1 select vat to article Dotaz cislo:49 SELECT *
FROM shop_discount WHERE (1=1) AND IdArticle = '1879' AND IdCostType = '3' AND TimeFrom < '2025-07-06 01:43:28' AND TimeTo > '2025-07-06 01:43:28' AND Flags & '1' select properties of object shop_discount_quantity Dotaz cislo:50 SELECT *
FROM shop_cost WHERE (1=1) AND IdArticle = 1879 AND IdType = 3 AND IdCompany IS NULL select properties of object CShopCost
Dotaz cislo:51 SELECT kat2.Name as nazev,
kat1.IdParent as idParent,
kat1.Id as id, 1 as ShowItem
FROM shop_cat_tree kat1
INNER JOIN shop_cat_tree2lang kat2 ON kat2.IdCat = kat1.Id
WHERE kat1.Id = 86 AND IdLanguage = 2 AND kat2.Flags&1 GROUP BY idParent
ORDER BY nazev kategorie_v ceste CWriteTreePath Dotaz cislo:52 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=86 AND
v.IdSecuritySection = 16
select id of inserted virtual_directory from db
Dotaz cislo:82 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=3
ORDER BY c2u.IdType
LIMIT 0, 1
select properties of object security_user Dotaz cislo:83 SELECT *
FROM security_user2group
WHERE IdUser=3 select groups of security_user
Jméno Příjmení
+420 777 721 282
Dotaz cislo:117 call getRightsForUser(2, 34) load rights
Dotaz cislo:118 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
Dotaz cislo:119 SELECT *
FROM section
WHERE Id=130 select properties of object section Dotaz cislo:120 SELECT * FROM section_sec2lang
WHERE IdSection=130 AND
IdLanguage=2 select properties of object section_sec2lang
+420 777 721 282