SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001135s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.153' , `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=1.5SMC30&search=1' [ RunTime:0.008466s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001253s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000506s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001969s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.000330s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001177s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000244s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001396s ]
SELECT * FROM `stock_search` WHERE `partno` = '1.5SMC30' LIMIT 1 [ RunTime:0.009168s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-17 21:38:30' WHERE `partno` = '1.5SMC30' [ RunTime:0.010759s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001972s ]
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 '1.5SMC30%' OR `brand` LIKE '1.5SMC30%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019477s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.010115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692173 LIMIT 5 [ RunTime:0.009393s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692173 ORDER BY `minOrder` ASC [ RunTime:0.013835s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006560s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692173 ORDER BY `unit` DESC [ RunTime:0.022402s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692173 LIMIT 2 [ RunTime:0.022566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692173 ORDER BY `minOrder` ASC [ RunTime:0.008608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16678853 LIMIT 5 [ RunTime:0.020203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16678853 ORDER BY `minOrder` ASC [ RunTime:0.019241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16678853 ORDER BY `unit` DESC [ RunTime:0.016178s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16678853 LIMIT 2 [ RunTime:0.032537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16678853 ORDER BY `minOrder` ASC [ RunTime:0.011140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13933043 LIMIT 5 [ RunTime:0.016142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13933043 ORDER BY `minOrder` ASC [ RunTime:0.004585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13933043 ORDER BY `unit` DESC [ RunTime:0.020746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13933043 LIMIT 2 [ RunTime:0.019285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13933043 ORDER BY `minOrder` ASC [ RunTime:0.002414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13925810 LIMIT 5 [ RunTime:0.011198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13925810 ORDER BY `minOrder` ASC [ RunTime:0.011048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13925810 ORDER BY `unit` DESC [ RunTime:0.031734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13925810 LIMIT 2 [ RunTime:0.027692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13925810 ORDER BY `minOrder` ASC [ RunTime:0.022305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13910641 LIMIT 5 [ RunTime:0.023280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910641 ORDER BY `minOrder` ASC [ RunTime:0.000994s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13910641 ORDER BY `unit` DESC [ RunTime:0.000609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13910641 LIMIT 2 [ RunTime:0.015374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910641 ORDER BY `minOrder` ASC [ RunTime:0.003371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668063 LIMIT 5 [ RunTime:0.013111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668063 ORDER BY `minOrder` ASC [ RunTime:0.020217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668063 ORDER BY `unit` DESC [ RunTime:0.021979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668063 LIMIT 2 [ RunTime:0.058377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668063 ORDER BY `minOrder` ASC [ RunTime:0.039023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16682244 LIMIT 5 [ RunTime:0.008614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16682244 ORDER BY `minOrder` ASC [ RunTime:0.004866s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16682244 ORDER BY `unit` DESC [ RunTime:0.014049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16682244 LIMIT 2 [ RunTime:0.034011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16682244 ORDER BY `minOrder` ASC [ RunTime:0.008838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13922911 LIMIT 5 [ RunTime:0.017647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13922911 ORDER BY `minOrder` ASC [ RunTime:0.036675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13922911 ORDER BY `unit` DESC [ RunTime:0.022034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13922911 LIMIT 2 [ RunTime:0.000409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13922911 ORDER BY `minOrder` ASC [ RunTime:0.000333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13910344 LIMIT 5 [ RunTime:0.002455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910344 ORDER BY `minOrder` ASC [ RunTime:0.001000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13910344 ORDER BY `unit` DESC [ RunTime:0.003937s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13910344 LIMIT 2 [ RunTime:0.016762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910344 ORDER BY `minOrder` ASC [ RunTime:0.007950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14821378 LIMIT 5 [ RunTime:0.014067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14821378 ORDER BY `minOrder` ASC [ RunTime:0.011991s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14821378 ORDER BY `unit` DESC [ RunTime:0.007585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14821378 LIMIT 2 [ RunTime:0.003317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14821378 ORDER BY `minOrder` ASC [ RunTime:0.007666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661776 LIMIT 5 [ RunTime:0.002513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661776 ORDER BY `minOrder` ASC [ RunTime:0.004420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16661776 ORDER BY `unit` DESC [ RunTime:0.000613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16661776 LIMIT 2 [ RunTime:0.000552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661776 ORDER BY `minOrder` ASC [ RunTime:0.000387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14799176 LIMIT 5 [ RunTime:0.011432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799176 ORDER BY `minOrder` ASC [ RunTime:0.012120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14799176 ORDER BY `unit` DESC [ RunTime:0.006550s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14799176 LIMIT 2 [ RunTime:0.002707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799176 ORDER BY `minOrder` ASC [ RunTime:0.011571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800162 LIMIT 5 [ RunTime:0.020733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800162 ORDER BY `minOrder` ASC [ RunTime:0.004878s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800162 ORDER BY `unit` DESC [ RunTime:0.003541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800162 LIMIT 2 [ RunTime:0.010371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800162 ORDER BY `minOrder` ASC [ RunTime:0.002720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16679234 LIMIT 5 [ RunTime:0.033823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16679234 ORDER BY `minOrder` ASC [ RunTime:0.033077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16679234 ORDER BY `unit` DESC [ RunTime:0.012305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16679234 LIMIT 2 [ RunTime:0.008267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16679234 ORDER BY `minOrder` ASC [ RunTime:0.000834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14809938 LIMIT 5 [ RunTime:0.022645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14809938 ORDER BY `minOrder` ASC [ RunTime:0.010433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14809938 ORDER BY `unit` DESC [ RunTime:0.014796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14809938 LIMIT 2 [ RunTime:0.002073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14809938 ORDER BY `minOrder` ASC [ RunTime:0.000270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908249 LIMIT 5 [ RunTime:0.000591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908249 ORDER BY `minOrder` ASC [ RunTime:0.007603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13908249 ORDER BY `unit` DESC [ RunTime:0.002569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13908249 LIMIT 2 [ RunTime:0.004071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908249 ORDER BY `minOrder` ASC [ RunTime:0.002240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908248 LIMIT 5 [ RunTime:0.000447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908248 ORDER BY `minOrder` ASC [ RunTime:0.006093s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13908248 ORDER BY `unit` DESC [ RunTime:0.000429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13908248 LIMIT 2 [ RunTime:0.001257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908248 ORDER BY `minOrder` ASC [ RunTime:0.000478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908152 LIMIT 5 [ RunTime:0.011430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908152 ORDER BY `minOrder` ASC [ RunTime:0.008900s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13908152 ORDER BY `unit` DESC [ RunTime:0.010777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13908152 LIMIT 2 [ RunTime:0.000650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908152 ORDER BY `minOrder` ASC [ RunTime:0.002766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907861 LIMIT 5 [ RunTime:0.010080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907861 ORDER BY `minOrder` ASC [ RunTime:0.009063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907861 ORDER BY `unit` DESC [ RunTime:0.018693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907861 LIMIT 2 [ RunTime:0.022266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907861 ORDER BY `minOrder` ASC [ RunTime:0.002413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907859 LIMIT 5 [ RunTime:0.004758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907859 ORDER BY `minOrder` ASC [ RunTime:0.003007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907859 ORDER BY `unit` DESC [ RunTime:0.006630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907859 LIMIT 2 [ RunTime:0.003451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907859 ORDER BY `minOrder` ASC [ RunTime:0.002455s ]
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 '1.5SMC30%' OR `brand` LIKE '1.5SMC30%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51141050 LIMIT 5 [ RunTime:0.007724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141050 ORDER BY `minOrder` ASC [ RunTime:0.002567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51141050 ORDER BY `unit` DESC [ RunTime:0.019434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51141050 LIMIT 2 [ RunTime:0.000904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141050 ORDER BY `minOrder` ASC [ RunTime:0.003207s ]
select * from pdf where partno='1.5smc30ca' and brandshort='bourns' limit 1 [ RunTime:0.008012s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001414s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5smc30ca' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.017677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51140915 LIMIT 5 [ RunTime:0.000473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51140915 ORDER BY `minOrder` ASC [ RunTime:0.010226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51140915 ORDER BY `unit` DESC [ RunTime:0.001939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51140915 LIMIT 2 [ RunTime:0.005928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51140915 ORDER BY `minOrder` ASC [ RunTime:0.004989s ]
select * from pdf where partno='1.5smc30ahm3_a/i' and brandshort='vishay semiconductors' limit 1 [ RunTime:0.005071s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5smc30ahm3_a/i' OR `brand` LIKE 'vishay semiconductors%' ) ) LIMIT 1 [ RunTime:0.000642s ]
SELECT `id` FROM `stock` WHERE `id` <> 51140915 AND `partno` = '1.5smc30ahm3_a/i' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay semiconductors%' ) [ RunTime:0.003663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51140916 LIMIT 5 [ RunTime:0.000471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51140916 ORDER BY `minOrder` ASC [ RunTime:0.000556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51140916 ORDER BY `unit` DESC [ RunTime:0.001551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51140916 LIMIT 2 [ RunTime:0.018709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51140916 ORDER BY `minOrder` ASC [ RunTime:0.013034s ]
select * from pdf where partno='1.5smc30cahe3_a/i' and brandshort='vishay semiconductors' limit 1 [ RunTime:0.008319s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5smc30cahe3_a/i' OR `brand` LIKE 'vishay semiconductors%' ) ) LIMIT 1 [ RunTime:0.009835s ]
SELECT `id` FROM `stock` WHERE `id` <> 51140916 AND `partno` = '1.5smc30cahe3_a/i' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay semiconductors%' ) [ RunTime:0.017830s ]
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 '1.5SMC30%' OR `brand` LIKE '1.5SMC30%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42119742 LIMIT 5 [ RunTime:0.003114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42119742 ORDER BY `minOrder` ASC [ RunTime:0.011690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42119742 ORDER BY `unit` DESC [ RunTime:0.000760s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42119742 LIMIT 2 [ RunTime:0.000453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42119742 ORDER BY `minOrder` ASC [ RunTime:0.006339s ]
select * from pdf where partno='1.5SMC300A' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.008079s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC300A' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.015666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42117021 LIMIT 5 [ RunTime:0.015103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117021 ORDER BY `minOrder` ASC [ RunTime:0.036353s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42117021 ORDER BY `unit` DESC [ RunTime:0.009832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42117021 LIMIT 2 [ RunTime:0.002856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117021 ORDER BY `minOrder` ASC [ RunTime:0.004845s ]
select * from pdf where partno='1.5SMC30A' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.017363s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC30A' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.003475s ]
SELECT `id` FROM `stock` WHERE `id` <> 42117021 AND `partno` = '1.5SMC30A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.030137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16678853 [ RunTime:0.013581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42132707 LIMIT 5 [ RunTime:0.000695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42132707 ORDER BY `minOrder` ASC [ RunTime:0.004456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42132707 ORDER BY `unit` DESC [ RunTime:0.001818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42132707 LIMIT 2 [ RunTime:0.003036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42132707 ORDER BY `minOrder` ASC [ RunTime:0.001548s ]
select * from pdf where partno='1.5SMC30A-Q' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.007281s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC30A-Q' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.001102s ]
SELECT `id` FROM `stock` WHERE `id` <> 42132707 AND `partno` = '1.5SMC30A-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.007634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13933043 [ RunTime:0.002211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42117830 LIMIT 5 [ RunTime:0.006621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117830 ORDER BY `minOrder` ASC [ RunTime:0.022482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42117830 ORDER BY `unit` DESC [ RunTime:0.002981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42117830 LIMIT 2 [ RunTime:0.018879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117830 ORDER BY `minOrder` ASC [ RunTime:0.006426s ]
select * from pdf where partno='1.5SMC30CA' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.001365s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC30CA' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.005710s ]
SELECT `id` FROM `stock` WHERE `id` <> 42117830 AND `partno` = '1.5SMC30CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.005436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13925810 [ RunTime:0.006080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42135393 LIMIT 5 [ RunTime:0.001006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42135393 ORDER BY `minOrder` ASC [ RunTime:0.001439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42135393 ORDER BY `unit` DESC [ RunTime:0.015549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42135393 LIMIT 2 [ RunTime:0.008178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42135393 ORDER BY `minOrder` ASC [ RunTime:0.000664s ]
select * from pdf where partno='1.5SMC300AHM3_B/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.005466s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC300AHM3_B/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.003254s ]
SELECT `id` FROM `stock` WHERE `id` <> 42135393 AND `partno` = '1.5SMC300AHM3_B/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.012232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16682244 [ RunTime:0.003099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42118073 LIMIT 5 [ RunTime:0.000776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42118073 ORDER BY `minOrder` ASC [ RunTime:0.008087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42118073 ORDER BY `unit` DESC [ RunTime:0.003866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42118073 LIMIT 2 [ RunTime:0.004610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42118073 ORDER BY `minOrder` ASC [ RunTime:0.001615s ]
select * from pdf where partno='1.5SMC30CAH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.001955s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC30CAH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.001373s ]
SELECT `id` FROM `stock` WHERE `id` <> 42118073 AND `partno` = '1.5SMC30CAH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.000917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13922911 [ RunTime:0.001177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42105223 LIMIT 5 [ RunTime:0.006416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105223 ORDER BY `minOrder` ASC [ RunTime:0.003102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42105223 ORDER BY `unit` DESC [ RunTime:0.005588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42105223 LIMIT 2 [ RunTime:0.006182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105223 ORDER BY `minOrder` ASC [ RunTime:0.000511s ]
select * from pdf where partno='1.5SMC30CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001071s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC30CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.004324s ]
SELECT `id` FROM `stock` WHERE `id` <> 42105223 AND `partno` = '1.5SMC30CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.020435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668063 [ RunTime:0.009586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42120156 LIMIT 5 [ RunTime:0.007441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42120156 ORDER BY `minOrder` ASC [ RunTime:0.002930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42120156 ORDER BY `unit` DESC [ RunTime:0.012727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42120156 LIMIT 2 [ RunTime:0.007579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42120156 ORDER BY `minOrder` ASC [ RunTime:0.009355s ]
select * from pdf where partno='1.5SMC300CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.002385s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC300CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.001808s ]
SELECT `id` FROM `stock` WHERE `id` <> 42120156 AND `partno` = '1.5SMC300CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.006633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14809938 [ RunTime:0.002308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42143519 LIMIT 5 [ RunTime:0.000677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42143519 ORDER BY `minOrder` ASC [ RunTime:0.005514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42143519 ORDER BY `unit` DESC [ RunTime:0.001407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42143519 LIMIT 2 [ RunTime:0.001231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42143519 ORDER BY `minOrder` ASC [ RunTime:0.000450s ]
select * from pdf where partno='1.5SMC30AHE3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.011845s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC30AHE3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.013770s ]
SELECT `id` FROM `stock` WHERE `id` <> 42143519 AND `partno` = '1.5SMC30AHE3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.009220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661776 [ RunTime:0.011038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42143885 LIMIT 5 [ RunTime:0.010594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42143885 ORDER BY `minOrder` ASC [ RunTime:0.003641s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42143885 ORDER BY `unit` DESC [ RunTime:0.001875s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42143885 LIMIT 2 [ RunTime:0.007422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42143885 ORDER BY `minOrder` ASC [ RunTime:0.003089s ]
select * from pdf where partno='1.5SMC300CA-E' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.003976s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC300CA-E' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000795s ]
SELECT `id` FROM `stock` WHERE `id` <> 42143885 AND `partno` = '1.5SMC300CA-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.007453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14804677 [ RunTime:0.001060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42143840 LIMIT 5 [ RunTime:0.005750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42143840 ORDER BY `minOrder` ASC [ RunTime:0.006707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42143840 ORDER BY `unit` DESC [ RunTime:0.002899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42143840 LIMIT 2 [ RunTime:0.002627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42143840 ORDER BY `minOrder` ASC [ RunTime:0.000367s ]
select * from pdf where partno='1.5SMC300A-E' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001001s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC300A-E' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.011739s ]
SELECT `id` FROM `stock` WHERE `id` <> 42143840 AND `partno` = '1.5SMC300A-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.006108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13909148 [ RunTime:0.012429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42142988 LIMIT 5 [ RunTime:0.000655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142988 ORDER BY `minOrder` ASC [ RunTime:0.008323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42142988 ORDER BY `unit` DESC [ RunTime:0.002732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42142988 LIMIT 2 [ RunTime:0.004307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142988 ORDER BY `minOrder` ASC [ RunTime:0.000382s ]
select * from pdf where partno='1.5SMC30CA-E' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001064s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC30CA-E' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.007587s ]
SELECT `id` FROM `stock` WHERE `id` <> 42142988 AND `partno` = '1.5SMC30CA-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.016113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13909141 [ RunTime:0.000732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42142929 LIMIT 5 [ RunTime:0.000781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142929 ORDER BY `minOrder` ASC [ RunTime:0.002528s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42142929 ORDER BY `unit` DESC [ RunTime:0.001144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42142929 LIMIT 2 [ RunTime:0.001130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142929 ORDER BY `minOrder` ASC [ RunTime:0.000488s ]
select * from pdf where partno='1.5SMC30A-E' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001058s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC30A-E' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.005057s ]
SELECT `id` FROM `stock` WHERE `id` <> 42142929 AND `partno` = '1.5SMC30A-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.006639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13909121 [ RunTime:0.004250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42133840 LIMIT 5 [ RunTime:0.000998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42133840 ORDER BY `minOrder` ASC [ RunTime:0.003892s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42133840 ORDER BY `unit` DESC [ RunTime:0.003513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42133840 LIMIT 2 [ RunTime:0.006679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42133840 ORDER BY `minOrder` ASC [ RunTime:0.000469s ]
select * from pdf where partno='1.5SMC300CA' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.002098s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC300CA' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.001457s ]
SELECT `id` FROM `stock` WHERE `id` <> 42133840 AND `partno` = '1.5SMC300CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.005713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14799176 [ RunTime:0.003730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42119796 LIMIT 5 [ RunTime:0.007338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42119796 ORDER BY `minOrder` ASC [ RunTime:0.006322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42119796 ORDER BY `unit` DESC [ RunTime:0.000680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42119796 LIMIT 2 [ RunTime:0.001353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42119796 ORDER BY `minOrder` ASC [ RunTime:0.004233s ]
select * from pdf where partno='1.5SMC300A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.003486s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC300A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.001678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42132424 LIMIT 5 [ RunTime:0.003550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42132424 ORDER BY `minOrder` ASC [ RunTime:0.007473s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42132424 ORDER BY `unit` DESC [ RunTime:0.013535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42132424 LIMIT 2 [ RunTime:0.000729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42132424 ORDER BY `minOrder` ASC [ RunTime:0.002013s ]
select * from pdf where partno='1.5SMC300A' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.001120s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC300A' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.001748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42105225 LIMIT 5 [ RunTime:0.000702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105225 ORDER BY `minOrder` ASC [ RunTime:0.001041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42105225 ORDER BY `unit` DESC [ RunTime:0.000654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42105225 LIMIT 2 [ RunTime:0.002786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105225 ORDER BY `minOrder` ASC [ RunTime:0.002728s ]
select * from pdf where partno='1.5SMC30A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.003105s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC30A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000941s ]
SELECT `id` FROM `stock` WHERE `id` <> 42105225 AND `partno` = '1.5SMC30A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.000939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13910641 [ RunTime:0.000720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42117907 LIMIT 5 [ RunTime:0.001433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117907 ORDER BY `minOrder` ASC [ RunTime:0.001048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42117907 ORDER BY `unit` DESC [ RunTime:0.000729s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42117907 LIMIT 2 [ RunTime:0.000657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117907 ORDER BY `minOrder` ASC [ RunTime:0.002386s ]
select * from pdf where partno='1.5SMC30A-E3/57T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.002357s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC30A-E3/57T' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.001466s ]
SELECT `id` FROM `stock` WHERE `id` <> 42117907 AND `partno` = '1.5SMC30A-E3/57T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.001795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13910344 [ RunTime:0.004003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42172128 LIMIT 5 [ RunTime:0.001739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42172128 ORDER BY `minOrder` ASC [ RunTime:0.001466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42172128 ORDER BY `unit` DESC [ RunTime:0.000461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42172128 LIMIT 2 [ RunTime:0.000483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42172128 ORDER BY `minOrder` ASC [ RunTime:0.000379s ]
select * from pdf where partno='1.5SMC300A/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.002955s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC300A/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.005840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42174648 LIMIT 5 [ RunTime:0.001044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42174648 ORDER BY `minOrder` ASC [ RunTime:0.001043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42174648 ORDER BY `unit` DESC [ RunTime:0.001597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42174648 LIMIT 2 [ RunTime:0.000623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42174648 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
select * from pdf where partno='1.5SMC30A_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.000656s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC30A_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.003857s ]
SELECT `id` FROM `stock` WHERE `id` <> 42174648 AND `partno` = '1.5SMC30A_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.000911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908249 [ RunTime:0.000681s ]
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 '1.5SMC30%' OR `brand` LIKE '1.5SMC30%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001550s ]
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 '1.5SMC30%' OR `brand` LIKE '1.5SMC30%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001171s ]
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 '1.5SMC30%' OR `brand` LIKE '1.5SMC30%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000969s ]
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 '1.5SMC30%' OR `brand` LIKE '1.5SMC30%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004654s ]
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 '1.5SMC30%' OR `brand` LIKE '1.5SMC30%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002519s ]
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 '1.5SMC30%' OR `brand` LIKE '1.5SMC30%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001067s ]
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 '1.5SMC30%' OR `brand` LIKE '1.5SMC30%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001267s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1.5SMC30%' OR `brand` LIKE '1.5SMC30%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002695s ]