SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001597s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.48' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=G6A&search=1' [ RunTime:0.016424s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001414s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000486s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001667s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.48' ) [ RunTime:0.000274s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001078s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000198s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001232s ]
SELECT * FROM `stock_search` WHERE `partno` = 'G6A' LIMIT 1 [ RunTime:0.002016s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-08-30 14:35:22' WHERE `partno` = 'G6A' [ RunTime:0.002100s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002549s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'G6A%' OR `brand` LIKE 'G6A%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011318s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15376089 LIMIT 5 [ RunTime:0.006992s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15376089 ORDER BY `minOrder` ASC [ RunTime:0.004093s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15376089 ORDER BY `unit` DESC [ RunTime:0.000498s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15376089 LIMIT 2 [ RunTime:0.000429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15376089 ORDER BY `minOrder` ASC [ RunTime:0.002661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17155769 LIMIT 5 [ RunTime:0.019596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17155769 ORDER BY `minOrder` ASC [ RunTime:0.004601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17155769 ORDER BY `unit` DESC [ RunTime:0.004635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17155769 LIMIT 2 [ RunTime:0.010175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17155769 ORDER BY `minOrder` ASC [ RunTime:0.000489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15377250 LIMIT 5 [ RunTime:0.003289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15377250 ORDER BY `minOrder` ASC [ RunTime:0.002655s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15377250 ORDER BY `unit` DESC [ RunTime:0.007697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15377250 LIMIT 2 [ RunTime:0.001601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15377250 ORDER BY `minOrder` ASC [ RunTime:0.000505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17155766 LIMIT 5 [ RunTime:0.009607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17155766 ORDER BY `minOrder` ASC [ RunTime:0.004088s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17155766 ORDER BY `unit` DESC [ RunTime:0.008288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17155766 LIMIT 2 [ RunTime:0.019559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17155766 ORDER BY `minOrder` ASC [ RunTime:0.002898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17155771 LIMIT 5 [ RunTime:0.001366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17155771 ORDER BY `minOrder` ASC [ RunTime:0.003213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17155771 ORDER BY `unit` DESC [ RunTime:0.001213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17155771 LIMIT 2 [ RunTime:0.000972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17155771 ORDER BY `minOrder` ASC [ RunTime:0.000440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15377255 LIMIT 5 [ RunTime:0.001015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15377255 ORDER BY `minOrder` ASC [ RunTime:0.007260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15377255 ORDER BY `unit` DESC [ RunTime:0.009734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15377255 LIMIT 2 [ RunTime:0.014780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15377255 ORDER BY `minOrder` ASC [ RunTime:0.001780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17155767 LIMIT 5 [ RunTime:0.000770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17155767 ORDER BY `minOrder` ASC [ RunTime:0.001791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17155767 ORDER BY `unit` DESC [ RunTime:0.000722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17155767 LIMIT 2 [ RunTime:0.000680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17155767 ORDER BY `minOrder` ASC [ RunTime:0.003057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15377256 LIMIT 5 [ RunTime:0.004186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15377256 ORDER BY `minOrder` ASC [ RunTime:0.012693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15377256 ORDER BY `unit` DESC [ RunTime:0.008361s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15377256 LIMIT 2 [ RunTime:0.011962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15377256 ORDER BY `minOrder` ASC [ RunTime:0.008102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12261259 LIMIT 5 [ RunTime:0.019546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12261259 ORDER BY `minOrder` ASC [ RunTime:0.003561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12261259 ORDER BY `unit` DESC [ RunTime:0.001463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12261259 LIMIT 2 [ RunTime:0.000711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12261259 ORDER BY `minOrder` ASC [ RunTime:0.010116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15376090 LIMIT 5 [ RunTime:0.009574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15376090 ORDER BY `minOrder` ASC [ RunTime:0.002499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15376090 ORDER BY `unit` DESC [ RunTime:0.000662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15376090 LIMIT 2 [ RunTime:0.000724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15376090 ORDER BY `minOrder` ASC [ RunTime:0.012161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17156785 LIMIT 5 [ RunTime:0.001218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17156785 ORDER BY `minOrder` ASC [ RunTime:0.010316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17156785 ORDER BY `unit` DESC [ RunTime:0.000572s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17156785 LIMIT 2 [ RunTime:0.010029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17156785 ORDER BY `minOrder` ASC [ RunTime:0.000396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15377837 LIMIT 5 [ RunTime:0.000884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15377837 ORDER BY `minOrder` ASC [ RunTime:0.000996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15377837 ORDER BY `unit` DESC [ RunTime:0.005926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15377837 LIMIT 2 [ RunTime:0.007417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15377837 ORDER BY `minOrder` ASC [ RunTime:0.002748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12260938 LIMIT 5 [ RunTime:0.001465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12260938 ORDER BY `minOrder` ASC [ RunTime:0.016852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12260938 ORDER BY `unit` DESC [ RunTime:0.004447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12260938 LIMIT 2 [ RunTime:0.012297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12260938 ORDER BY `minOrder` ASC [ RunTime:0.000506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15377257 LIMIT 5 [ RunTime:0.000694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15377257 ORDER BY `minOrder` ASC [ RunTime:0.010830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15377257 ORDER BY `unit` DESC [ RunTime:0.006117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15377257 LIMIT 2 [ RunTime:0.001889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15377257 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15377835 LIMIT 5 [ RunTime:0.000633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15377835 ORDER BY `minOrder` ASC [ RunTime:0.001525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15377835 ORDER BY `unit` DESC [ RunTime:0.001248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15377835 LIMIT 2 [ RunTime:0.007741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15377835 ORDER BY `minOrder` ASC [ RunTime:0.000478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12260934 LIMIT 5 [ RunTime:0.003118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12260934 ORDER BY `minOrder` ASC [ RunTime:0.015184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12260934 ORDER BY `unit` DESC [ RunTime:0.004731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12260934 LIMIT 2 [ RunTime:0.000625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12260934 ORDER BY `minOrder` ASC [ RunTime:0.001537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17154747 LIMIT 5 [ RunTime:0.003331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17154747 ORDER BY `minOrder` ASC [ RunTime:0.000651s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17154747 ORDER BY `unit` DESC [ RunTime:0.001952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17154747 LIMIT 2 [ RunTime:0.001074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17154747 ORDER BY `minOrder` ASC [ RunTime:0.000905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15377834 LIMIT 5 [ RunTime:0.000606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15377834 ORDER BY `minOrder` ASC [ RunTime:0.003304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15377834 ORDER BY `unit` DESC [ RunTime:0.001424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15377834 LIMIT 2 [ RunTime:0.007384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15377834 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17156787 LIMIT 5 [ RunTime:0.002985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17156787 ORDER BY `minOrder` ASC [ RunTime:0.001611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17156787 ORDER BY `unit` DESC [ RunTime:0.000954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17156787 LIMIT 2 [ RunTime:0.000585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17156787 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17156791 LIMIT 5 [ RunTime:0.000630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17156791 ORDER BY `minOrder` ASC [ RunTime:0.000609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17156791 ORDER BY `unit` DESC [ RunTime:0.008154s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17156791 LIMIT 2 [ RunTime:0.002743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17156791 ORDER BY `minOrder` ASC [ RunTime:0.003985s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'G6A%' OR `brand` LIKE 'G6A%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32211964 LIMIT 5 [ RunTime:0.000700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32211964 ORDER BY `minOrder` ASC [ RunTime:0.001504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32211964 ORDER BY `unit` DESC [ RunTime:0.000628s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32211964 LIMIT 2 [ RunTime:0.000573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32211964 ORDER BY `minOrder` ASC [ RunTime:0.001577s ]
select * from pdf where partno='g6ak-274p-st40-us-dc24' and brandshort='omron electronics' limit 1 [ RunTime:0.001527s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002794s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'g6ak-274p-st40-us-dc24' OR `brand` LIKE 'omron electronics%' ) ) LIMIT 1 [ RunTime:0.001313s ]
SELECT `id` FROM `stock` WHERE `id` <> 32211964 AND `partno` = 'g6ak-274p-st40-us-dc24' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron electronics%' ) [ RunTime:0.001485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32211588 LIMIT 5 [ RunTime:0.005504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32211588 ORDER BY `minOrder` ASC [ RunTime:0.004600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32211588 ORDER BY `unit` DESC [ RunTime:0.000753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32211588 LIMIT 2 [ RunTime:0.000484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32211588 ORDER BY `minOrder` ASC [ RunTime:0.000306s ]
select * from pdf where partno='g6ak-274p-stlt-us-dc12' and brandshort='omron electronics' limit 1 [ RunTime:0.000600s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'g6ak-274p-stlt-us-dc12' OR `brand` LIKE 'omron electronics%' ) ) LIMIT 1 [ RunTime:0.007505s ]
SELECT `id` FROM `stock` WHERE `id` <> 32211588 AND `partno` = 'g6ak-274p-stlt-us-dc12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron electronics%' ) [ RunTime:0.003396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32211390 LIMIT 5 [ RunTime:0.000564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32211390 ORDER BY `minOrder` ASC [ RunTime:0.003939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32211390 ORDER BY `unit` DESC [ RunTime:0.004314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32211390 LIMIT 2 [ RunTime:0.008261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32211390 ORDER BY `minOrder` ASC [ RunTime:0.016351s ]
select * from pdf where partno='g6a-234p-st40-us-dc12' and brandshort='omron electronics' limit 1 [ RunTime:0.004306s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'g6a-234p-st40-us-dc12' OR `brand` LIKE 'omron electronics%' ) ) LIMIT 1 [ RunTime:0.000917s ]
SELECT `id` FROM `stock` WHERE `id` <> 32211390 AND `partno` = 'g6a-234p-st40-us-dc12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron electronics%' ) [ RunTime:0.008801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32211297 LIMIT 5 [ RunTime:0.010577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32211297 ORDER BY `minOrder` ASC [ RunTime:0.007763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32211297 ORDER BY `unit` DESC [ RunTime:0.001173s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32211297 LIMIT 2 [ RunTime:0.005523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32211297 ORDER BY `minOrder` ASC [ RunTime:0.000448s ]
select * from pdf where partno='g6ak-274p-st40-us-dc12' and brandshort='omron electronics' limit 1 [ RunTime:0.001254s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'g6ak-274p-st40-us-dc12' OR `brand` LIKE 'omron electronics%' ) ) LIMIT 1 [ RunTime:0.004121s ]
SELECT `id` FROM `stock` WHERE `id` <> 32211297 AND `partno` = 'g6ak-274p-st40-us-dc12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron electronics%' ) [ RunTime:0.008077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32211963 LIMIT 5 [ RunTime:0.000651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32211963 ORDER BY `minOrder` ASC [ RunTime:0.000767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32211963 ORDER BY `unit` DESC [ RunTime:0.000625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32211963 LIMIT 2 [ RunTime:0.005934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32211963 ORDER BY `minOrder` ASC [ RunTime:0.000464s ]
select * from pdf where partno='g6a-2-h-dc5' and brandshort='omron electronics' limit 1 [ RunTime:0.004056s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'g6a-2-h-dc5' OR `brand` LIKE 'omron electronics%' ) ) LIMIT 1 [ RunTime:0.000799s ]
SELECT `id` FROM `stock` WHERE `id` <> 32211963 AND `partno` = 'g6a-2-h-dc5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron electronics%' ) [ RunTime:0.000806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32211966 LIMIT 5 [ RunTime:0.000647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32211966 ORDER BY `minOrder` ASC [ RunTime:0.003192s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32211966 ORDER BY `unit` DESC [ RunTime:0.009855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32211966 LIMIT 2 [ RunTime:0.004134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32211966 ORDER BY `minOrder` ASC [ RunTime:0.006956s ]
select * from pdf where partno='g6au-274p-st-us-dc5' and brandshort='omron electronics' limit 1 [ RunTime:0.002934s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'g6au-274p-st-us-dc5' OR `brand` LIKE 'omron electronics%' ) ) LIMIT 1 [ RunTime:0.000640s ]
SELECT `id` FROM `stock` WHERE `id` <> 32211966 AND `partno` = 'g6au-274p-st-us-dc5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron electronics%' ) [ RunTime:0.013640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32211965 LIMIT 5 [ RunTime:0.004177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32211965 ORDER BY `minOrder` ASC [ RunTime:0.013449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32211965 ORDER BY `unit` DESC [ RunTime:0.004164s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32211965 LIMIT 2 [ RunTime:0.003133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32211965 ORDER BY `minOrder` ASC [ RunTime:0.013028s ]
select * from pdf where partno='g6au-274p-st-us-dc12' and brandshort='omron electronics' limit 1 [ RunTime:0.014273s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'g6au-274p-st-us-dc12' OR `brand` LIKE 'omron electronics%' ) ) LIMIT 1 [ RunTime:0.007377s ]
SELECT `id` FROM `stock` WHERE `id` <> 32211965 AND `partno` = 'g6au-274p-st-us-dc12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron electronics%' ) [ RunTime:0.004989s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'G6A%' OR `brand` LIKE 'G6A%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51450606 LIMIT 5 [ RunTime:0.006538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51450606 ORDER BY `minOrder` ASC [ RunTime:0.000967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51450606 ORDER BY `unit` DESC [ RunTime:0.009935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51450606 LIMIT 2 [ RunTime:0.013959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51450606 ORDER BY `minOrder` ASC [ RunTime:0.019533s ]
select * from pdf where partno='G6A-274P-ST40-US DC24' and brandshort='Omron Electronics Inc-EMC Div' limit 1 [ RunTime:0.012012s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G6A-274P-ST40-US DC24' OR `brand` LIKE 'Omron Electronics Inc-EMC Div%' ) ) LIMIT 1 [ RunTime:0.011083s ]
SELECT `id` FROM `stock` WHERE `id` <> 51450606 AND `partno` = 'G6A-274P-ST40-US DC24' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron electronics inc-emc div%' ) [ RunTime:0.011842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17155769 [ RunTime:0.015469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58332560 LIMIT 5 [ RunTime:0.004289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58332560 ORDER BY `minOrder` ASC [ RunTime:0.001254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58332560 ORDER BY `unit` DESC [ RunTime:0.002875s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58332560 LIMIT 2 [ RunTime:0.000354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58332560 ORDER BY `minOrder` ASC [ RunTime:0.003618s ]
select * from pdf where partno='G6A-274P-ST40-US DC24' and brandshort='Aratas America LLC' limit 1 [ RunTime:0.007020s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G6A-274P-ST40-US DC24' OR `brand` LIKE 'Aratas America LLC%' ) ) LIMIT 1 [ RunTime:0.004815s ]
SELECT `id` FROM `stock` WHERE `id` <> 58332560 AND `partno` = 'G6A-274P-ST40-US DC24' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aratas america llc%' ) [ RunTime:0.012020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51450607 LIMIT 5 [ RunTime:0.006782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51450607 ORDER BY `minOrder` ASC [ RunTime:0.000690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51450607 ORDER BY `unit` DESC [ RunTime:0.004104s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51450607 LIMIT 2 [ RunTime:0.011596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51450607 ORDER BY `minOrder` ASC [ RunTime:0.003105s ]
select * from pdf where partno='G6A-274P-ST-US DC24' and brandshort='Omron Electronics Inc-EMC Div' limit 1 [ RunTime:0.025650s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G6A-274P-ST-US DC24' OR `brand` LIKE 'Omron Electronics Inc-EMC Div%' ) ) LIMIT 1 [ RunTime:0.009794s ]
SELECT `id` FROM `stock` WHERE `id` <> 51450607 AND `partno` = 'G6A-274P-ST-US DC24' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron electronics inc-emc div%' ) [ RunTime:0.024454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17155766 [ RunTime:0.015446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58332561 LIMIT 5 [ RunTime:0.021133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58332561 ORDER BY `minOrder` ASC [ RunTime:0.015249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58332561 ORDER BY `unit` DESC [ RunTime:0.045665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58332561 LIMIT 2 [ RunTime:0.005441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58332561 ORDER BY `minOrder` ASC [ RunTime:0.012626s ]
select * from pdf where partno='G6A-274P-ST-US DC24' and brandshort='Aratas America LLC' limit 1 [ RunTime:0.001141s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G6A-274P-ST-US DC24' OR `brand` LIKE 'Aratas America LLC%' ) ) LIMIT 1 [ RunTime:0.003760s ]
SELECT `id` FROM `stock` WHERE `id` <> 58332561 AND `partno` = 'G6A-274P-ST-US DC24' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aratas america llc%' ) [ RunTime:0.003527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51450800 LIMIT 5 [ RunTime:0.000672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51450800 ORDER BY `minOrder` ASC [ RunTime:0.006835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51450800 ORDER BY `unit` DESC [ RunTime:0.000811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51450800 LIMIT 2 [ RunTime:0.004286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51450800 ORDER BY `minOrder` ASC [ RunTime:0.003753s ]
select * from pdf where partno='G6A-274P-ST15-US DC24' and brandshort='Omron Electronics Inc-EMC Div' limit 1 [ RunTime:0.041692s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G6A-274P-ST15-US DC24' OR `brand` LIKE 'Omron Electronics Inc-EMC Div%' ) ) LIMIT 1 [ RunTime:0.011806s ]
SELECT `id` FROM `stock` WHERE `id` <> 51450800 AND `partno` = 'G6A-274P-ST15-US DC24' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron electronics inc-emc div%' ) [ RunTime:0.002136s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15375302 [ RunTime:0.018676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58332570 LIMIT 5 [ RunTime:0.003805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58332570 ORDER BY `minOrder` ASC [ RunTime:0.004817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58332570 ORDER BY `unit` DESC [ RunTime:0.024317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58332570 LIMIT 2 [ RunTime:0.011659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58332570 ORDER BY `minOrder` ASC [ RunTime:0.032065s ]
select * from pdf where partno='G6A-274P-ST15-US DC24' and brandshort='Aratas America LLC' limit 1 [ RunTime:0.015747s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G6A-274P-ST15-US DC24' OR `brand` LIKE 'Aratas America LLC%' ) ) LIMIT 1 [ RunTime:0.004111s ]
SELECT `id` FROM `stock` WHERE `id` <> 58332570 AND `partno` = 'G6A-274P-ST15-US DC24' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aratas america llc%' ) [ RunTime:0.015656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51450608 LIMIT 5 [ RunTime:0.016673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51450608 ORDER BY `minOrder` ASC [ RunTime:0.014725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51450608 ORDER BY `unit` DESC [ RunTime:0.008600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51450608 LIMIT 2 [ RunTime:0.005458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51450608 ORDER BY `minOrder` ASC [ RunTime:0.012034s ]
select * from pdf where partno='G6A-274P-ST-US DC12' and brandshort='Omron Electronics Inc-EMC Div' limit 1 [ RunTime:0.015832s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G6A-274P-ST-US DC12' OR `brand` LIKE 'Omron Electronics Inc-EMC Div%' ) ) LIMIT 1 [ RunTime:0.023785s ]
SELECT `id` FROM `stock` WHERE `id` <> 51450608 AND `partno` = 'G6A-274P-ST-US DC12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron electronics inc-emc div%' ) [ RunTime:0.005079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17155767 [ RunTime:0.010901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58332562 LIMIT 5 [ RunTime:0.038912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58332562 ORDER BY `minOrder` ASC [ RunTime:0.008487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58332562 ORDER BY `unit` DESC [ RunTime:0.021041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58332562 LIMIT 2 [ RunTime:0.035344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58332562 ORDER BY `minOrder` ASC [ RunTime:0.001759s ]
select * from pdf where partno='G6A-274P-ST-US DC12' and brandshort='Aratas America LLC' limit 1 [ RunTime:0.001459s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G6A-274P-ST-US DC12' OR `brand` LIKE 'Aratas America LLC%' ) ) LIMIT 1 [ RunTime:0.000618s ]
SELECT `id` FROM `stock` WHERE `id` <> 58332562 AND `partno` = 'G6A-274P-ST-US DC12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aratas america llc%' ) [ RunTime:0.002976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58332763 LIMIT 5 [ RunTime:0.003759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58332763 ORDER BY `minOrder` ASC [ RunTime:0.002537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58332763 ORDER BY `unit` DESC [ RunTime:0.002434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58332763 LIMIT 2 [ RunTime:0.011447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58332763 ORDER BY `minOrder` ASC [ RunTime:0.012948s ]
select * from pdf where partno='G6AK-234P-ST-US DC5' and brandshort='Aratas America LLC' limit 1 [ RunTime:0.007861s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G6AK-234P-ST-US DC5' OR `brand` LIKE 'Aratas America LLC%' ) ) LIMIT 1 [ RunTime:0.024896s ]
SELECT `id` FROM `stock` WHERE `id` <> 58332763 AND `partno` = 'G6AK-234P-ST-US DC5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aratas america llc%' ) [ RunTime:0.013508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51450804 LIMIT 5 [ RunTime:0.084659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51450804 ORDER BY `minOrder` ASC [ RunTime:0.060617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51450804 ORDER BY `unit` DESC [ RunTime:0.121076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51450804 LIMIT 2 [ RunTime:0.109251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51450804 ORDER BY `minOrder` ASC [ RunTime:0.044830s ]
select * from pdf where partno='G6AK-234P-ST-US DC5' and brandshort='Omron Electronics Inc-EMC Div' limit 1 [ RunTime:0.029538s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G6AK-234P-ST-US DC5' OR `brand` LIKE 'Omron Electronics Inc-EMC Div%' ) ) LIMIT 1 [ RunTime:0.074800s ]
SELECT `id` FROM `stock` WHERE `id` <> 51450804 AND `partno` = 'G6AK-234P-ST-US DC5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron electronics inc-emc div%' ) [ RunTime:0.061255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17155771 [ RunTime:0.082252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51450616 LIMIT 5 [ RunTime:0.048109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51450616 ORDER BY `minOrder` ASC [ RunTime:0.075257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51450616 ORDER BY `unit` DESC [ RunTime:0.043797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51450616 LIMIT 2 [ RunTime:0.050270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51450616 ORDER BY `minOrder` ASC [ RunTime:0.064036s ]
select * from pdf where partno='G6AK-274P-ST-US DC24' and brandshort='Omron Electronics Inc-EMC Div' limit 1 [ RunTime:0.033895s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G6AK-274P-ST-US DC24' OR `brand` LIKE 'Omron Electronics Inc-EMC Div%' ) ) LIMIT 1 [ RunTime:0.067770s ]
SELECT `id` FROM `stock` WHERE `id` <> 51450616 AND `partno` = 'G6AK-274P-ST-US DC24' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron electronics inc-emc div%' ) [ RunTime:0.038456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15375304 [ RunTime:0.038664s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51450610 LIMIT 5 [ RunTime:0.049866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51450610 ORDER BY `minOrder` ASC [ RunTime:0.051881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51450610 ORDER BY `unit` DESC [ RunTime:0.012214s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51450610 LIMIT 2 [ RunTime:0.023647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51450610 ORDER BY `minOrder` ASC [ RunTime:0.046934s ]
select * from pdf where partno='G6A-274P-ST-US DC5' and brandshort='Omron Electronics Inc-EMC Div' limit 1 [ RunTime:0.045783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G6A-274P-ST-US DC5' OR `brand` LIKE 'Omron Electronics Inc-EMC Div%' ) ) LIMIT 1 [ RunTime:0.027327s ]
SELECT `id` FROM `stock` WHERE `id` <> 51450610 AND `partno` = 'G6A-274P-ST-US DC5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron electronics inc-emc div%' ) [ RunTime:0.046057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15376089 [ RunTime:0.045748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58332571 LIMIT 5 [ RunTime:0.044574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58332571 ORDER BY `minOrder` ASC [ RunTime:0.019920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58332571 ORDER BY `unit` DESC [ RunTime:0.044095s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58332571 LIMIT 2 [ RunTime:0.028100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58332571 ORDER BY `minOrder` ASC [ RunTime:0.001156s ]
select * from pdf where partno='G6AK-274P-ST-US DC24' and brandshort='Aratas America LLC' limit 1 [ RunTime:0.037113s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G6AK-274P-ST-US DC24' OR `brand` LIKE 'Aratas America LLC%' ) ) LIMIT 1 [ RunTime:0.027206s ]
SELECT `id` FROM `stock` WHERE `id` <> 58332571 AND `partno` = 'G6AK-274P-ST-US DC24' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aratas america llc%' ) [ RunTime:0.020779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58332564 LIMIT 5 [ RunTime:0.025828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58332564 ORDER BY `minOrder` ASC [ RunTime:0.018752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58332564 ORDER BY `unit` DESC [ RunTime:0.027453s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58332564 LIMIT 2 [ RunTime:0.011053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58332564 ORDER BY `minOrder` ASC [ RunTime:0.018657s ]
select * from pdf where partno='G6A-274P-ST-US DC5' and brandshort='Aratas America LLC' limit 1 [ RunTime:0.012972s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G6A-274P-ST-US DC5' OR `brand` LIKE 'Aratas America LLC%' ) ) LIMIT 1 [ RunTime:0.022117s ]
SELECT `id` FROM `stock` WHERE `id` <> 58332564 AND `partno` = 'G6A-274P-ST-US DC5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aratas america llc%' ) [ RunTime:0.018214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58332557 LIMIT 5 [ RunTime:0.011780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58332557 ORDER BY `minOrder` ASC [ RunTime:0.024550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58332557 ORDER BY `unit` DESC [ RunTime:0.030267s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58332557 LIMIT 2 [ RunTime:0.013166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58332557 ORDER BY `minOrder` ASC [ RunTime:0.041654s ]
select * from pdf where partno='G6A-274P-ST40-US DC5' and brandshort='Aratas America LLC' limit 1 [ RunTime:0.032116s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G6A-274P-ST40-US DC5' OR `brand` LIKE 'Aratas America LLC%' ) ) LIMIT 1 [ RunTime:0.005394s ]
SELECT `id` FROM `stock` WHERE `id` <> 58332557 AND `partno` = 'G6A-274P-ST40-US DC5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aratas america llc%' ) [ RunTime:0.028384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51450617 LIMIT 5 [ RunTime:0.013364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51450617 ORDER BY `minOrder` ASC [ RunTime:0.026827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51450617 ORDER BY `unit` DESC [ RunTime:0.059236s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51450617 LIMIT 2 [ RunTime:0.022002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51450617 ORDER BY `minOrder` ASC [ RunTime:0.010527s ]
select * from pdf where partno='G6AK-234P-ST-US DC24' and brandshort='Omron Electronics Inc-EMC Div' limit 1 [ RunTime:0.017472s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G6AK-234P-ST-US DC24' OR `brand` LIKE 'Omron Electronics Inc-EMC Div%' ) ) LIMIT 1 [ RunTime:0.004213s ]
SELECT `id` FROM `stock` WHERE `id` <> 51450617 AND `partno` = 'G6AK-234P-ST-US DC24' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron electronics inc-emc div%' ) [ RunTime:0.018742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15377255 [ RunTime:0.017087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51450802 LIMIT 5 [ RunTime:0.017537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51450802 ORDER BY `minOrder` ASC [ RunTime:0.007107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51450802 ORDER BY `unit` DESC [ RunTime:0.006781s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51450802 LIMIT 2 [ RunTime:0.014437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51450802 ORDER BY `minOrder` ASC [ RunTime:0.002147s ]
select * from pdf where partno='G6AK-274P-ST40-US DC12' and brandshort='Omron Electronics Inc-EMC Div' limit 1 [ RunTime:0.015438s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G6AK-274P-ST40-US DC12' OR `brand` LIKE 'Omron Electronics Inc-EMC Div%' ) ) LIMIT 1 [ RunTime:0.002426s ]
SELECT `id` FROM `stock` WHERE `id` <> 51450802 AND `partno` = 'G6AK-274P-ST40-US DC12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron electronics inc-emc div%' ) [ RunTime:0.011575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15375303 [ RunTime:0.007152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51450600 LIMIT 5 [ RunTime:0.003450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51450600 ORDER BY `minOrder` ASC [ RunTime:0.013005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51450600 ORDER BY `unit` DESC [ RunTime:0.007895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51450600 LIMIT 2 [ RunTime:0.020823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51450600 ORDER BY `minOrder` ASC [ RunTime:0.005000s ]
select * from pdf where partno='G6A-274P-ST40-US DC12' and brandshort='Omron Electronics Inc-EMC Div' limit 1 [ RunTime:0.007438s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G6A-274P-ST40-US DC12' OR `brand` LIKE 'Omron Electronics Inc-EMC Div%' ) ) LIMIT 1 [ RunTime:0.009123s ]
SELECT `id` FROM `stock` WHERE `id` <> 51450600 AND `partno` = 'G6A-274P-ST40-US DC12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron electronics inc-emc div%' ) [ RunTime:0.013011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15377251 [ RunTime:0.012055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58332554 LIMIT 5 [ RunTime:0.018685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58332554 ORDER BY `minOrder` ASC [ RunTime:0.026721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58332554 ORDER BY `unit` DESC [ RunTime:0.001676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58332554 LIMIT 2 [ RunTime:0.000678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58332554 ORDER BY `minOrder` ASC [ RunTime:0.002347s ]
select * from pdf where partno='G6A-274P-ST40-US DC12' and brandshort='Aratas America LLC' limit 1 [ RunTime:0.002394s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G6A-274P-ST40-US DC12' OR `brand` LIKE 'Aratas America LLC%' ) ) LIMIT 1 [ RunTime:0.000933s ]
SELECT `id` FROM `stock` WHERE `id` <> 58332554 AND `partno` = 'G6A-274P-ST40-US DC12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aratas america llc%' ) [ RunTime:0.006165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58332761 LIMIT 5 [ RunTime:0.000694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58332761 ORDER BY `minOrder` ASC [ RunTime:0.008613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58332761 ORDER BY `unit` DESC [ RunTime:0.003401s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58332761 LIMIT 2 [ RunTime:0.006598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58332761 ORDER BY `minOrder` ASC [ RunTime:0.012527s ]
select * from pdf where partno='G6AK-274P-ST40-US DC12' and brandshort='Aratas America LLC' limit 1 [ RunTime:0.009707s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G6AK-274P-ST40-US DC12' OR `brand` LIKE 'Aratas America LLC%' ) ) LIMIT 1 [ RunTime:0.011195s ]
SELECT `id` FROM `stock` WHERE `id` <> 58332761 AND `partno` = 'G6AK-274P-ST40-US DC12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aratas america llc%' ) [ RunTime:0.014070s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'G6A%' OR `brand` LIKE 'G6A%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004626s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'G6A%' OR `brand` LIKE 'G6A%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027004s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'G6A%' OR `brand` LIKE 'G6A%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006946s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'G6A%' OR `brand` LIKE 'G6A%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001434s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'G6A%' OR `brand` LIKE 'G6A%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011397s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'G6A%' OR `brand` LIKE 'G6A%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015468s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'G6A%' OR `brand` LIKE 'G6A%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001239s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'G6A%' OR `brand` LIKE 'G6A%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.012609s ]