SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001342s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.113' , `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=2423&search=1' [ RunTime:0.001622s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001261s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000586s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.009434s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.113' ) [ RunTime:0.006397s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001116s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.014387s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.004698s ]
SELECT * FROM `stock_search` WHERE `partno` = '2423' LIMIT 1 [ RunTime:0.028059s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-06 11:46:11' WHERE `partno` = '2423' [ RunTime:0.010481s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002372s ]
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 '2423%' OR `brand` LIKE '2423%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017023s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19774797 LIMIT 5 [ RunTime:0.009085s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19774797 ORDER BY `minOrder` ASC [ RunTime:0.000732s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003375s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19774797 ORDER BY `unit` DESC [ RunTime:0.019888s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000990s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19774797 LIMIT 2 [ RunTime:0.004939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19774797 ORDER BY `minOrder` ASC [ RunTime:0.003256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19774793 LIMIT 5 [ RunTime:0.000823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19774793 ORDER BY `minOrder` ASC [ RunTime:0.001851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19774793 ORDER BY `unit` DESC [ RunTime:0.006477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19774793 LIMIT 2 [ RunTime:0.009023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19774793 ORDER BY `minOrder` ASC [ RunTime:0.009527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19774776 LIMIT 5 [ RunTime:0.002959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19774776 ORDER BY `minOrder` ASC [ RunTime:0.012040s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19774776 ORDER BY `unit` DESC [ RunTime:0.010155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19774776 LIMIT 2 [ RunTime:0.000744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19774776 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19774764 LIMIT 5 [ RunTime:0.006866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19774764 ORDER BY `minOrder` ASC [ RunTime:0.008106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19774764 ORDER BY `unit` DESC [ RunTime:0.003348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19774764 LIMIT 2 [ RunTime:0.011163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19774764 ORDER BY `minOrder` ASC [ RunTime:0.006529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16197428 LIMIT 5 [ RunTime:0.006369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16197428 ORDER BY `minOrder` ASC [ RunTime:0.007160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16197428 ORDER BY `unit` DESC [ RunTime:0.000631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16197428 LIMIT 2 [ RunTime:0.007186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16197428 ORDER BY `minOrder` ASC [ RunTime:0.001257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16197417 LIMIT 5 [ RunTime:0.000837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16197417 ORDER BY `minOrder` ASC [ RunTime:0.006782s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16197417 ORDER BY `unit` DESC [ RunTime:0.012643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16197417 LIMIT 2 [ RunTime:0.012811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16197417 ORDER BY `minOrder` ASC [ RunTime:0.003803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13516048 LIMIT 5 [ RunTime:0.008815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13516048 ORDER BY `minOrder` ASC [ RunTime:0.001849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13516048 ORDER BY `unit` DESC [ RunTime:0.001642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13516048 LIMIT 2 [ RunTime:0.014858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13516048 ORDER BY `minOrder` ASC [ RunTime:0.003443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14389158 LIMIT 5 [ RunTime:0.018592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14389158 ORDER BY `minOrder` ASC [ RunTime:0.007416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14389158 ORDER BY `unit` DESC [ RunTime:0.027955s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14389158 LIMIT 2 [ RunTime:0.008456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14389158 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10942665 LIMIT 5 [ RunTime:0.011083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10942665 ORDER BY `minOrder` ASC [ RunTime:0.016011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10942665 ORDER BY `unit` DESC [ RunTime:0.002551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10942665 LIMIT 2 [ RunTime:0.000918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10942665 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10942667 LIMIT 5 [ RunTime:0.001486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10942667 ORDER BY `minOrder` ASC [ RunTime:0.018265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10942667 ORDER BY `unit` DESC [ RunTime:0.003906s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10942667 LIMIT 2 [ RunTime:0.012335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10942667 ORDER BY `minOrder` ASC [ RunTime:0.000820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10942663 LIMIT 5 [ RunTime:0.003146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10942663 ORDER BY `minOrder` ASC [ RunTime:0.007460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10942663 ORDER BY `unit` DESC [ RunTime:0.005681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10942663 LIMIT 2 [ RunTime:0.002799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10942663 ORDER BY `minOrder` ASC [ RunTime:0.003074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10942658 LIMIT 5 [ RunTime:0.006769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10942658 ORDER BY `minOrder` ASC [ RunTime:0.000649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10942658 ORDER BY `unit` DESC [ RunTime:0.006245s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10942658 LIMIT 2 [ RunTime:0.007972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10942658 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14387429 LIMIT 5 [ RunTime:0.004000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14387429 ORDER BY `minOrder` ASC [ RunTime:0.001249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14387429 ORDER BY `unit` DESC [ RunTime:0.004337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14387429 LIMIT 2 [ RunTime:0.001598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14387429 ORDER BY `minOrder` ASC [ RunTime:0.000431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12391817 LIMIT 5 [ RunTime:0.009146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12391817 ORDER BY `minOrder` ASC [ RunTime:0.006698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12391817 ORDER BY `unit` DESC [ RunTime:0.003079s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12391817 LIMIT 2 [ RunTime:0.000719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12391817 ORDER BY `minOrder` ASC [ RunTime:0.002742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14387017 LIMIT 5 [ RunTime:0.000983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14387017 ORDER BY `minOrder` ASC [ RunTime:0.009287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14387017 ORDER BY `unit` DESC [ RunTime:0.002665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14387017 LIMIT 2 [ RunTime:0.016625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14387017 ORDER BY `minOrder` ASC [ RunTime:0.009903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13514645 LIMIT 5 [ RunTime:0.004799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13514645 ORDER BY `minOrder` ASC [ RunTime:0.012966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13514645 ORDER BY `unit` DESC [ RunTime:0.003288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13514645 LIMIT 2 [ RunTime:0.007174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13514645 ORDER BY `minOrder` ASC [ RunTime:0.003773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13514560 LIMIT 5 [ RunTime:0.003706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13514560 ORDER BY `minOrder` ASC [ RunTime:0.019176s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13514560 ORDER BY `unit` DESC [ RunTime:0.005003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13514560 LIMIT 2 [ RunTime:0.000632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13514560 ORDER BY `minOrder` ASC [ RunTime:0.000936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18994183 LIMIT 5 [ RunTime:0.014946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18994183 ORDER BY `minOrder` ASC [ RunTime:0.016937s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18994183 ORDER BY `unit` DESC [ RunTime:0.006050s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18994183 LIMIT 2 [ RunTime:0.007532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18994183 ORDER BY `minOrder` ASC [ RunTime:0.016199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18744781 LIMIT 5 [ RunTime:0.014572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18744781 ORDER BY `minOrder` ASC [ RunTime:0.011096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18744781 ORDER BY `unit` DESC [ RunTime:0.019511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18744781 LIMIT 2 [ RunTime:0.005164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18744781 ORDER BY `minOrder` ASC [ RunTime:0.015171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13328104 LIMIT 5 [ RunTime:0.011077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13328104 ORDER BY `minOrder` ASC [ RunTime:0.006214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13328104 ORDER BY `unit` DESC [ RunTime:0.000656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13328104 LIMIT 2 [ RunTime:0.021647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13328104 ORDER BY `minOrder` ASC [ RunTime:0.007719s ]
select * from pdf where partno='2423' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.029079s ]
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 '2423%' OR `brand` LIKE '2423%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51106600 LIMIT 5 [ RunTime:0.041231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51106600 ORDER BY `minOrder` ASC [ RunTime:0.010010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51106600 ORDER BY `unit` DESC [ RunTime:0.017569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51106600 LIMIT 2 [ RunTime:0.017693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51106600 ORDER BY `minOrder` ASC [ RunTime:0.006005s ]
select * from pdf where partno='2423' and brandshort='adafruit' limit 1 [ RunTime:0.021346s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002566s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2423' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.019685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51137879 LIMIT 5 [ RunTime:0.027146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137879 ORDER BY `minOrder` ASC [ RunTime:0.005227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51137879 ORDER BY `unit` DESC [ RunTime:0.000679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51137879 LIMIT 2 [ RunTime:0.009210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137879 ORDER BY `minOrder` ASC [ RunTime:0.013907s ]
select * from pdf where partno='2423c sl005' and brandshort='alpha wire' limit 1 [ RunTime:0.003144s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2423c sl005' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.012477s ]
SELECT `id` FROM `stock` WHERE `id` <> 51137879 AND `partno` = '2423c sl005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.024937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14389158 [ RunTime:0.018244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51137880 LIMIT 5 [ RunTime:0.019506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137880 ORDER BY `minOrder` ASC [ RunTime:0.008037s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51137880 ORDER BY `unit` DESC [ RunTime:0.010781s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51137880 LIMIT 2 [ RunTime:0.006396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137880 ORDER BY `minOrder` ASC [ RunTime:0.013510s ]
select * from pdf where partno='2423c sl002' and brandshort='alpha wire' limit 1 [ RunTime:0.004806s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2423c sl002' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.009943s ]
SELECT `id` FROM `stock` WHERE `id` <> 51137880 AND `partno` = '2423c sl002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.034067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14387017 [ RunTime:0.024938s ]
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 '2423%' OR `brand` LIKE '2423%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59448119 LIMIT 5 [ RunTime:0.011077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59448119 ORDER BY `minOrder` ASC [ RunTime:0.049821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59448119 ORDER BY `unit` DESC [ RunTime:0.036363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59448119 LIMIT 2 [ RunTime:0.028162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59448119 ORDER BY `minOrder` ASC [ RunTime:0.004546s ]
select * from pdf where partno='2423324-6' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002719s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2423324-6' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001417s ]
SELECT `id` FROM `stock` WHERE `id` <> 59448119 AND `partno` = '2423324-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19774793 [ RunTime:0.014298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59448087 LIMIT 5 [ RunTime:0.021337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59448087 ORDER BY `minOrder` ASC [ RunTime:0.012637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59448087 ORDER BY `unit` DESC [ RunTime:0.008030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59448087 LIMIT 2 [ RunTime:0.004409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59448087 ORDER BY `minOrder` ASC [ RunTime:0.018451s ]
select * from pdf where partno='2423324-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.008525s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2423324-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.028476s ]
SELECT `id` FROM `stock` WHERE `id` <> 59448087 AND `partno` = '2423324-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.018072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19774776 [ RunTime:0.015865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59448068 LIMIT 5 [ RunTime:0.022571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59448068 ORDER BY `minOrder` ASC [ RunTime:0.010821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59448068 ORDER BY `unit` DESC [ RunTime:0.023510s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59448068 LIMIT 2 [ RunTime:0.023399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59448068 ORDER BY `minOrder` ASC [ RunTime:0.029006s ]
select * from pdf where partno='2423324-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.039832s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2423324-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.008720s ]
SELECT `id` FROM `stock` WHERE `id` <> 59448068 AND `partno` = '2423324-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.017354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19774764 [ RunTime:0.007787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59448167 LIMIT 5 [ RunTime:0.002787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59448167 ORDER BY `minOrder` ASC [ RunTime:0.010908s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59448167 ORDER BY `unit` DESC [ RunTime:0.045365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59448167 LIMIT 2 [ RunTime:0.014474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59448167 ORDER BY `minOrder` ASC [ RunTime:0.013658s ]
select * from pdf where partno='2423324-8' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007547s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2423324-8' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.022327s ]
SELECT `id` FROM `stock` WHERE `id` <> 59448167 AND `partno` = '2423324-8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.009523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19774797 [ RunTime:0.005047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59448098 LIMIT 5 [ RunTime:0.023958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59448098 ORDER BY `minOrder` ASC [ RunTime:0.014077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59448098 ORDER BY `unit` DESC [ RunTime:0.033881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59448098 LIMIT 2 [ RunTime:0.025449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59448098 ORDER BY `minOrder` ASC [ RunTime:0.006845s ]
select * from pdf where partno='2423324-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.030155s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2423324-5' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.037143s ]
SELECT `id` FROM `stock` WHERE `id` <> 59448098 AND `partno` = '2423324-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.018850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16197428 [ RunTime:0.016543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59448049 LIMIT 5 [ RunTime:0.020084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59448049 ORDER BY `minOrder` ASC [ RunTime:0.025693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59448049 ORDER BY `unit` DESC [ RunTime:0.005918s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59448049 LIMIT 2 [ RunTime:0.008460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59448049 ORDER BY `minOrder` ASC [ RunTime:0.016307s ]
select * from pdf where partno='2423324-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.015877s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2423324-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.012092s ]
SELECT `id` FROM `stock` WHERE `id` <> 59448049 AND `partno` = '2423324-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.038079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16197417 [ RunTime:0.038462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62997155 LIMIT 5 [ RunTime:0.016460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997155 ORDER BY `minOrder` ASC [ RunTime:0.023026s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62997155 ORDER BY `unit` DESC [ RunTime:0.030517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62997155 LIMIT 2 [ RunTime:0.020529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997155 ORDER BY `minOrder` ASC [ RunTime:0.007629s ]
select * from pdf where partno='2423C SL010' and brandshort='Alpha Wire' limit 1 [ RunTime:0.002686s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2423C SL010' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.017089s ]
SELECT `id` FROM `stock` WHERE `id` <> 62997155 AND `partno` = '2423C SL010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.020363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13516048 [ RunTime:0.000780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62996744 LIMIT 5 [ RunTime:0.009942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62996744 ORDER BY `minOrder` ASC [ RunTime:0.008781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62996744 ORDER BY `unit` DESC [ RunTime:0.021027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62996744 LIMIT 2 [ RunTime:0.012824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62996744 ORDER BY `minOrder` ASC [ RunTime:0.001221s ]
select * from pdf where partno='2423C SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.004573s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2423C SL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.010525s ]
SELECT `id` FROM `stock` WHERE `id` <> 62996744 AND `partno` = '2423C SL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.016089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14389158 [ RunTime:0.004554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60563092 LIMIT 5 [ RunTime:0.004440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60563092 ORDER BY `minOrder` ASC [ RunTime:0.005283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60563092 ORDER BY `unit` DESC [ RunTime:0.000790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60563092 LIMIT 2 [ RunTime:0.012630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60563092 ORDER BY `minOrder` ASC [ RunTime:0.000531s ]
select * from pdf where partno='2423' and brandshort='Pololu' limit 1 [ RunTime:0.010187s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2423' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.015918s ]
SELECT `id` FROM `stock` WHERE `id` <> 60563092 AND `partno` = '2423' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.017196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62998713 LIMIT 5 [ RunTime:0.007240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62998713 ORDER BY `minOrder` ASC [ RunTime:0.016301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62998713 ORDER BY `unit` DESC [ RunTime:0.019377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62998713 LIMIT 2 [ RunTime:0.029575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62998713 ORDER BY `minOrder` ASC [ RunTime:0.012414s ]
select * from pdf where partno='2423C SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.011757s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2423C SL001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.003352s ]
SELECT `id` FROM `stock` WHERE `id` <> 62998713 AND `partno` = '2423C SL001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.002577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14387429 [ RunTime:0.041093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62999786 LIMIT 5 [ RunTime:0.014045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62999786 ORDER BY `minOrder` ASC [ RunTime:0.009521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62999786 ORDER BY `unit` DESC [ RunTime:0.026432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62999786 LIMIT 2 [ RunTime:0.015930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62999786 ORDER BY `minOrder` ASC [ RunTime:0.014275s ]
select * from pdf where partno='2423C SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.015976s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2423C SL002' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.011610s ]
SELECT `id` FROM `stock` WHERE `id` <> 62999786 AND `partno` = '2423C SL002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.011396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14387017 [ RunTime:0.003815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62135498 LIMIT 5 [ RunTime:0.013425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62135498 ORDER BY `minOrder` ASC [ RunTime:0.018351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62135498 ORDER BY `unit` DESC [ RunTime:0.012813s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62135498 LIMIT 2 [ RunTime:0.002900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62135498 ORDER BY `minOrder` ASC [ RunTime:0.000364s ]
select * from pdf where partno='2423447-8' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002369s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2423447-8' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.010463s ]
SELECT `id` FROM `stock` WHERE `id` <> 62135498 AND `partno` = '2423447-8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.011278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63000015 LIMIT 5 [ RunTime:0.030753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63000015 ORDER BY `minOrder` ASC [ RunTime:0.049196s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63000015 ORDER BY `unit` DESC [ RunTime:0.020988s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63000015 LIMIT 2 [ RunTime:0.022101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63000015 ORDER BY `minOrder` ASC [ RunTime:0.015577s ]
select * from pdf where partno='2423C SL021' and brandshort='Alpha Wire' limit 1 [ RunTime:0.071832s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2423C SL021' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.014922s ]
SELECT `id` FROM `stock` WHERE `id` <> 63000015 AND `partno` = '2423C SL021' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.015906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13514645 [ RunTime:0.010310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62999787 LIMIT 5 [ RunTime:0.009449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62999787 ORDER BY `minOrder` ASC [ RunTime:0.029421s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62999787 ORDER BY `unit` DESC [ RunTime:0.029865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62999787 LIMIT 2 [ RunTime:0.012518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62999787 ORDER BY `minOrder` ASC [ RunTime:0.015764s ]
select * from pdf where partno='2423C SL022' and brandshort='Alpha Wire' limit 1 [ RunTime:0.023747s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2423C SL022' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.056069s ]
SELECT `id` FROM `stock` WHERE `id` <> 62999787 AND `partno` = '2423C SL022' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.046599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13514560 [ RunTime:0.034866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64417339 LIMIT 5 [ RunTime:0.027172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64417339 ORDER BY `minOrder` ASC [ RunTime:0.020113s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64417339 ORDER BY `unit` DESC [ RunTime:0.008879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64417339 LIMIT 2 [ RunTime:0.024855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64417339 ORDER BY `minOrder` ASC [ RunTime:0.015565s ]
select * from pdf where partno='2423830-1' and brandshort='TE Kemtron' limit 1 [ RunTime:0.024315s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2423830-1' OR `brand` LIKE 'TE Kemtron%' ) ) LIMIT 1 [ RunTime:0.009917s ]
SELECT `id` FROM `stock` WHERE `id` <> 64417339 AND `partno` = '2423830-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te kemtron%' ) [ RunTime:0.007968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64417898 LIMIT 5 [ RunTime:0.007650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64417898 ORDER BY `minOrder` ASC [ RunTime:0.016782s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64417898 ORDER BY `unit` DESC [ RunTime:0.015815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64417898 LIMIT 2 [ RunTime:0.009319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64417898 ORDER BY `minOrder` ASC [ RunTime:0.007603s ]
select * from pdf where partno='2423773-1' and brandshort='TE Kemtron' limit 1 [ RunTime:0.022968s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2423773-1' OR `brand` LIKE 'TE Kemtron%' ) ) LIMIT 1 [ RunTime:0.006897s ]
SELECT `id` FROM `stock` WHERE `id` <> 64417898 AND `partno` = '2423773-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te kemtron%' ) [ RunTime:0.009086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64052021 LIMIT 5 [ RunTime:0.004005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64052021 ORDER BY `minOrder` ASC [ RunTime:0.010420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64052021 ORDER BY `unit` DESC [ RunTime:0.011292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64052021 LIMIT 2 [ RunTime:0.000624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64052021 ORDER BY `minOrder` ASC [ RunTime:0.001342s ]
select * from pdf where partno='2423' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.001635s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2423' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.012826s ]
SELECT `id` FROM `stock` WHERE `id` <> 64052021 AND `partno` = '2423' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.004931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12391817 [ RunTime:0.005150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63457159 LIMIT 5 [ RunTime:0.023537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63457159 ORDER BY `minOrder` ASC [ RunTime:0.037898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63457159 ORDER BY `unit` DESC [ RunTime:0.002424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63457159 LIMIT 2 [ RunTime:0.001931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63457159 ORDER BY `minOrder` ASC [ RunTime:0.009418s ]
select * from pdf where partno='2423000' and brandshort='Rittal' limit 1 [ RunTime:0.008561s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2423000' OR `brand` LIKE 'Rittal%' ) ) LIMIT 1 [ RunTime:0.019122s ]
SELECT `id` FROM `stock` WHERE `id` <> 63457159 AND `partno` = '2423000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rittal%' ) [ RunTime:0.028070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18994183 [ RunTime:0.019865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63410635 LIMIT 5 [ RunTime:0.003204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63410635 ORDER BY `minOrder` ASC [ RunTime:0.006591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63410635 ORDER BY `unit` DESC [ RunTime:0.014444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63410635 LIMIT 2 [ RunTime:0.015561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63410635 ORDER BY `minOrder` ASC [ RunTime:0.018976s ]
select * from pdf where partno='2423' and brandshort='80/20, LLC' limit 1 [ RunTime:0.015995s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2423' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.003161s ]
SELECT `id` FROM `stock` WHERE `id` <> 63410635 AND `partno` = '2423' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.002221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63372055 LIMIT 5 [ RunTime:0.005788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63372055 ORDER BY `minOrder` ASC [ RunTime:0.019100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63372055 ORDER BY `unit` DESC [ RunTime:0.041408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63372055 LIMIT 2 [ RunTime:0.014505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63372055 ORDER BY `minOrder` ASC [ RunTime:0.004068s ]
select * from pdf where partno='2423' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.003356s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2423' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.014721s ]
SELECT `id` FROM `stock` WHERE `id` <> 63372055 AND `partno` = '2423' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.008241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13328104 [ RunTime:0.000697s ]
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 '2423%' OR `brand` LIKE '2423%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008249s ]
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 '2423%' OR `brand` LIKE '2423%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002944s ]
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 '2423%' OR `brand` LIKE '2423%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000797s ]
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 '2423%' OR `brand` LIKE '2423%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027527s ]
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 '2423%' OR `brand` LIKE '2423%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001246s ]
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 '2423%' OR `brand` LIKE '2423%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007171s ]
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 '2423%' OR `brand` LIKE '2423%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001076s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '2423%' OR `brand` LIKE '2423%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.000820s ]