SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002115s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.215' , `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=7483&search=1' [ RunTime:0.008188s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002109s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002466s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002460s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.215' ) [ RunTime:0.022996s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001945s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.024292s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003160s ]
SELECT * FROM `stock_search` WHERE `partno` = '7483' LIMIT 1 [ RunTime:0.020898s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-08-30 13:04:35' WHERE `partno` = '7483' [ RunTime:0.013813s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002810s ]
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 '7483%' OR `brand` LIKE '7483%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035323s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11950037 LIMIT 5 [ RunTime:0.024585s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11950037 ORDER BY `minOrder` ASC [ RunTime:0.016222s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.012602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11950037 ORDER BY `unit` DESC [ RunTime:0.016861s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11950037 LIMIT 2 [ RunTime:0.013041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11950037 ORDER BY `minOrder` ASC [ RunTime:0.002203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11950035 LIMIT 5 [ RunTime:0.014903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11950035 ORDER BY `minOrder` ASC [ RunTime:0.029433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11950035 ORDER BY `unit` DESC [ RunTime:0.029161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11950035 LIMIT 2 [ RunTime:0.017965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11950035 ORDER BY `minOrder` ASC [ RunTime:0.013128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11950095 LIMIT 5 [ RunTime:0.007631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11950095 ORDER BY `minOrder` ASC [ RunTime:0.022612s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11950095 ORDER BY `unit` DESC [ RunTime:0.019431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11950095 LIMIT 2 [ RunTime:0.034758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11950095 ORDER BY `minOrder` ASC [ RunTime:0.010880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13175070 LIMIT 5 [ RunTime:0.026843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13175070 ORDER BY `minOrder` ASC [ RunTime:0.005963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13175070 ORDER BY `unit` DESC [ RunTime:0.032397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13175070 LIMIT 2 [ RunTime:0.020208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13175070 ORDER BY `minOrder` ASC [ RunTime:0.014607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16102159 LIMIT 5 [ RunTime:0.016436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16102159 ORDER BY `minOrder` ASC [ RunTime:0.004379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16102159 ORDER BY `unit` DESC [ RunTime:0.002673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16102159 LIMIT 2 [ RunTime:0.019028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16102159 ORDER BY `minOrder` ASC [ RunTime:0.010948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11948946 LIMIT 5 [ RunTime:0.016006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11948946 ORDER BY `minOrder` ASC [ RunTime:0.037745s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11948946 ORDER BY `unit` DESC [ RunTime:0.023509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11948946 LIMIT 2 [ RunTime:0.031572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11948946 ORDER BY `minOrder` ASC [ RunTime:0.034541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20090116 LIMIT 5 [ RunTime:0.017248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20090116 ORDER BY `minOrder` ASC [ RunTime:0.039793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20090116 ORDER BY `unit` DESC [ RunTime:0.029430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20090116 LIMIT 2 [ RunTime:0.033306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20090116 ORDER BY `minOrder` ASC [ RunTime:0.008873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11950093 LIMIT 5 [ RunTime:0.020248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11950093 ORDER BY `minOrder` ASC [ RunTime:0.016622s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11950093 ORDER BY `unit` DESC [ RunTime:0.010773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11950093 LIMIT 2 [ RunTime:0.051817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11950093 ORDER BY `minOrder` ASC [ RunTime:0.017594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20074898 LIMIT 5 [ RunTime:0.017183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074898 ORDER BY `minOrder` ASC [ RunTime:0.030498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20074898 ORDER BY `unit` DESC [ RunTime:0.043595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20074898 LIMIT 2 [ RunTime:0.037167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074898 ORDER BY `minOrder` ASC [ RunTime:0.008571s ]
select * from pdf where partno='74839-0082' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.012605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20074774 LIMIT 5 [ RunTime:0.024501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074774 ORDER BY `minOrder` ASC [ RunTime:0.015475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20074774 ORDER BY `unit` DESC [ RunTime:0.069761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20074774 LIMIT 2 [ RunTime:0.020377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074774 ORDER BY `minOrder` ASC [ RunTime:0.042492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20074772 LIMIT 5 [ RunTime:0.009435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074772 ORDER BY `minOrder` ASC [ RunTime:0.006474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20074772 ORDER BY `unit` DESC [ RunTime:0.015676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20074772 LIMIT 2 [ RunTime:0.018134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074772 ORDER BY `minOrder` ASC [ RunTime:0.007401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20074543 LIMIT 5 [ RunTime:0.030266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074543 ORDER BY `minOrder` ASC [ RunTime:0.000877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20074543 ORDER BY `unit` DESC [ RunTime:0.011905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20074543 LIMIT 2 [ RunTime:0.030428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074543 ORDER BY `minOrder` ASC [ RunTime:0.009945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20074428 LIMIT 5 [ RunTime:0.021212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074428 ORDER BY `minOrder` ASC [ RunTime:0.005506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20074428 ORDER BY `unit` DESC [ RunTime:0.014605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20074428 LIMIT 2 [ RunTime:0.015959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074428 ORDER BY `minOrder` ASC [ RunTime:0.013631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20074419 LIMIT 5 [ RunTime:0.004872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074419 ORDER BY `minOrder` ASC [ RunTime:0.010092s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20074419 ORDER BY `unit` DESC [ RunTime:0.000679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20074419 LIMIT 2 [ RunTime:0.007890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074419 ORDER BY `minOrder` ASC [ RunTime:0.009011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20074370 LIMIT 5 [ RunTime:0.003698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074370 ORDER BY `minOrder` ASC [ RunTime:0.008501s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20074370 ORDER BY `unit` DESC [ RunTime:0.000616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20074370 LIMIT 2 [ RunTime:0.002910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074370 ORDER BY `minOrder` ASC [ RunTime:0.011054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20074339 LIMIT 5 [ RunTime:0.008646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074339 ORDER BY `minOrder` ASC [ RunTime:0.009176s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20074339 ORDER BY `unit` DESC [ RunTime:0.008492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20074339 LIMIT 2 [ RunTime:0.000638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074339 ORDER BY `minOrder` ASC [ RunTime:0.001198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20074337 LIMIT 5 [ RunTime:0.008077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074337 ORDER BY `minOrder` ASC [ RunTime:0.026899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20074337 ORDER BY `unit` DESC [ RunTime:0.005791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20074337 LIMIT 2 [ RunTime:0.000670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074337 ORDER BY `minOrder` ASC [ RunTime:0.001440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20074336 LIMIT 5 [ RunTime:0.000654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074336 ORDER BY `minOrder` ASC [ RunTime:0.000605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20074336 ORDER BY `unit` DESC [ RunTime:0.000585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20074336 LIMIT 2 [ RunTime:0.001501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074336 ORDER BY `minOrder` ASC [ RunTime:0.003418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20074279 LIMIT 5 [ RunTime:0.002232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074279 ORDER BY `minOrder` ASC [ RunTime:0.001975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20074279 ORDER BY `unit` DESC [ RunTime:0.003032s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20074279 LIMIT 2 [ RunTime:0.004303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074279 ORDER BY `minOrder` ASC [ RunTime:0.003583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20074067 LIMIT 5 [ RunTime:0.010075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074067 ORDER BY `minOrder` ASC [ RunTime:0.008872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20074067 ORDER BY `unit` DESC [ RunTime:0.000882s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20074067 LIMIT 2 [ RunTime:0.000481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074067 ORDER BY `minOrder` ASC [ RunTime:0.000313s ]
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 '7483%' OR `brand` LIKE '7483%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001376s ]
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 '7483%' OR `brand` LIKE '7483%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64158638 LIMIT 5 [ RunTime:0.003283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64158638 ORDER BY `minOrder` ASC [ RunTime:0.021391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64158638 ORDER BY `unit` DESC [ RunTime:0.002682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64158638 LIMIT 2 [ RunTime:0.011985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64158638 ORDER BY `minOrder` ASC [ RunTime:0.008527s ]
select * from pdf where partno='748351124' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.051495s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001453s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '748351124' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.004533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64158546 LIMIT 5 [ RunTime:0.008108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64158546 ORDER BY `minOrder` ASC [ RunTime:0.019234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64158546 ORDER BY `unit` DESC [ RunTime:0.002439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64158546 LIMIT 2 [ RunTime:0.030532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64158546 ORDER BY `minOrder` ASC [ RunTime:0.002416s ]
select * from pdf where partno='748323024' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.015566s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '748323024' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.004422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64158539 LIMIT 5 [ RunTime:0.005017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64158539 ORDER BY `minOrder` ASC [ RunTime:0.000805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64158539 ORDER BY `unit` DESC [ RunTime:0.005304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64158539 LIMIT 2 [ RunTime:0.006869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64158539 ORDER BY `minOrder` ASC [ RunTime:0.002391s ]
select * from pdf where partno='748351024' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.009567s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '748351024' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.004802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63775044 LIMIT 5 [ RunTime:0.006775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63775044 ORDER BY `minOrder` ASC [ RunTime:0.027258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63775044 ORDER BY `unit` DESC [ RunTime:0.020772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63775044 LIMIT 2 [ RunTime:0.015192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63775044 ORDER BY `minOrder` ASC [ RunTime:0.006742s ]
select * from pdf where partno='7483APC' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.012491s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7483APC' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.009502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64160072 LIMIT 5 [ RunTime:0.010609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64160072 ORDER BY `minOrder` ASC [ RunTime:0.029512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64160072 ORDER BY `unit` DESC [ RunTime:0.028011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64160072 LIMIT 2 [ RunTime:0.014076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64160072 ORDER BY `minOrder` ASC [ RunTime:0.015282s ]
select * from pdf where partno='748323056' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.010580s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '748323056' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.006591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64160478 LIMIT 5 [ RunTime:0.019384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64160478 ORDER BY `minOrder` ASC [ RunTime:0.012387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64160478 ORDER BY `unit` DESC [ RunTime:0.013225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64160478 LIMIT 2 [ RunTime:0.065252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64160478 ORDER BY `minOrder` ASC [ RunTime:0.020046s ]
select * from pdf where partno='748323155' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.009224s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '748323155' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.036396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59402750 LIMIT 5 [ RunTime:0.014889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59402750 ORDER BY `minOrder` ASC [ RunTime:0.046142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59402750 ORDER BY `unit` DESC [ RunTime:0.034732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59402750 LIMIT 2 [ RunTime:0.000737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59402750 ORDER BY `minOrder` ASC [ RunTime:0.065962s ]
select * from pdf where partno='748301-000' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.026604s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '748301-000' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.037120s ]
SELECT `id` FROM `stock` WHERE `id` <> 59402750 AND `partno` = '748301-000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.058073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20090116 [ RunTime:0.007351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64535250 LIMIT 5 [ RunTime:0.013292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64535250 ORDER BY `minOrder` ASC [ RunTime:0.039405s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64535250 ORDER BY `unit` DESC [ RunTime:0.012418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64535250 LIMIT 2 [ RunTime:0.029862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64535250 ORDER BY `minOrder` ASC [ RunTime:0.014799s ]
select * from pdf where partno='74837' and brandshort='Brady Corporation' limit 1 [ RunTime:0.012835s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74837' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.002872s ]
SELECT `id` FROM `stock` WHERE `id` <> 64535250 AND `partno` = '74837' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.016197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13550065 [ RunTime:0.015420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64428156 LIMIT 5 [ RunTime:0.007445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64428156 ORDER BY `minOrder` ASC [ RunTime:0.013488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64428156 ORDER BY `unit` DESC [ RunTime:0.010475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64428156 LIMIT 2 [ RunTime:0.003247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64428156 ORDER BY `minOrder` ASC [ RunTime:0.007843s ]
select * from pdf where partno='7483' and brandshort='3M' limit 1 [ RunTime:0.015370s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7483' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.008567s ]
SELECT `id` FROM `stock` WHERE `id` <> 64428156 AND `partno` = '7483' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.016096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18708059 [ RunTime:0.012133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61988034 LIMIT 5 [ RunTime:0.005667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61988034 ORDER BY `minOrder` ASC [ RunTime:0.010797s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61988034 ORDER BY `unit` DESC [ RunTime:0.021384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61988034 LIMIT 2 [ RunTime:0.022149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61988034 ORDER BY `minOrder` ASC [ RunTime:0.006382s ]
select * from pdf where partno='748394-6' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.011675s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '748394-6' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.008518s ]
SELECT `id` FROM `stock` WHERE `id` <> 61988034 AND `partno` = '748394-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11890488 [ RunTime:0.008227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61981856 LIMIT 5 [ RunTime:0.001393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61981856 ORDER BY `minOrder` ASC [ RunTime:0.008689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61981856 ORDER BY `unit` DESC [ RunTime:0.004309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61981856 LIMIT 2 [ RunTime:0.007880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61981856 ORDER BY `minOrder` ASC [ RunTime:0.016240s ]
select * from pdf where partno='748394-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007586s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '748394-5' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.005261s ]
SELECT `id` FROM `stock` WHERE `id` <> 61981856 AND `partno` = '748394-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.009615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11887178 [ RunTime:0.011771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61956563 LIMIT 5 [ RunTime:0.009080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61956563 ORDER BY `minOrder` ASC [ RunTime:0.025343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61956563 ORDER BY `unit` DESC [ RunTime:0.013473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61956563 LIMIT 2 [ RunTime:0.006572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61956563 ORDER BY `minOrder` ASC [ RunTime:0.009769s ]
select * from pdf where partno='748389-7' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003074s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '748389-7' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.017063s ]
SELECT `id` FROM `stock` WHERE `id` <> 61956563 AND `partno` = '748389-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.005361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13134056 [ RunTime:0.004938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61953730 LIMIT 5 [ RunTime:0.014174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61953730 ORDER BY `minOrder` ASC [ RunTime:0.028627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61953730 ORDER BY `unit` DESC [ RunTime:0.016915s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61953730 LIMIT 2 [ RunTime:0.010440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61953730 ORDER BY `minOrder` ASC [ RunTime:0.019200s ]
select * from pdf where partno='748389-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.010274s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '748389-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.004186s ]
SELECT `id` FROM `stock` WHERE `id` <> 61953730 AND `partno` = '748389-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.005824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11874498 [ RunTime:0.010322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60351291 LIMIT 5 [ RunTime:0.012542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60351291 ORDER BY `minOrder` ASC [ RunTime:0.019567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60351291 ORDER BY `unit` DESC [ RunTime:0.000701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60351291 LIMIT 2 [ RunTime:0.004738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60351291 ORDER BY `minOrder` ASC [ RunTime:0.007911s ]
select * from pdf where partno='748333-9' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003831s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '748333-9' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.014508s ]
SELECT `id` FROM `stock` WHERE `id` <> 60351291 AND `partno` = '748333-9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60351173 LIMIT 5 [ RunTime:0.002113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60351173 ORDER BY `minOrder` ASC [ RunTime:0.003546s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60351173 ORDER BY `unit` DESC [ RunTime:0.001208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60351173 LIMIT 2 [ RunTime:0.005049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60351173 ORDER BY `minOrder` ASC [ RunTime:0.003514s ]
select * from pdf where partno='748333-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001215s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '748333-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001617s ]
SELECT `id` FROM `stock` WHERE `id` <> 60351173 AND `partno` = '748333-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.004934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11910126 [ RunTime:0.003489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60351113 LIMIT 5 [ RunTime:0.003899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60351113 ORDER BY `minOrder` ASC [ RunTime:0.002020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60351113 ORDER BY `unit` DESC [ RunTime:0.003252s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60351113 LIMIT 2 [ RunTime:0.013582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60351113 ORDER BY `minOrder` ASC [ RunTime:0.005197s ]
select * from pdf where partno='748333-7' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001580s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '748333-7' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.004119s ]
SELECT `id` FROM `stock` WHERE `id` <> 60351113 AND `partno` = '748333-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.014959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11910085 [ RunTime:0.005135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60291353 LIMIT 5 [ RunTime:0.001348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60291353 ORDER BY `minOrder` ASC [ RunTime:0.000856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60291353 ORDER BY `unit` DESC [ RunTime:0.005623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60291353 LIMIT 2 [ RunTime:0.003552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60291353 ORDER BY `minOrder` ASC [ RunTime:0.008299s ]
select * from pdf where partno='748368-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001085s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '748368-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002758s ]
SELECT `id` FROM `stock` WHERE `id` <> 60291353 AND `partno` = '748368-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11913396 [ RunTime:0.003510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60291245 LIMIT 5 [ RunTime:0.009868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60291245 ORDER BY `minOrder` ASC [ RunTime:0.006065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60291245 ORDER BY `unit` DESC [ RunTime:0.001482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60291245 LIMIT 2 [ RunTime:0.002450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60291245 ORDER BY `minOrder` ASC [ RunTime:0.012354s ]
select * from pdf where partno='748366-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007520s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '748366-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007773s ]
SELECT `id` FROM `stock` WHERE `id` <> 60291245 AND `partno` = '748366-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.007149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11913358 [ RunTime:0.000915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60291241 LIMIT 5 [ RunTime:0.000982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60291241 ORDER BY `minOrder` ASC [ RunTime:0.002048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60291241 ORDER BY `unit` DESC [ RunTime:0.007399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60291241 LIMIT 2 [ RunTime:0.012164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60291241 ORDER BY `minOrder` ASC [ RunTime:0.002245s ]
select * from pdf where partno='748367-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.008588s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '748367-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.008331s ]
SELECT `id` FROM `stock` WHERE `id` <> 60291241 AND `partno` = '748367-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.007723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13175770 [ RunTime:0.004757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60291211 LIMIT 5 [ RunTime:0.001563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60291211 ORDER BY `minOrder` ASC [ RunTime:0.003135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60291211 ORDER BY `unit` DESC [ RunTime:0.006779s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60291211 LIMIT 2 [ RunTime:0.006512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60291211 ORDER BY `minOrder` ASC [ RunTime:0.006157s ]
select * from pdf where partno='748365-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002122s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '748365-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.004279s ]
SELECT `id` FROM `stock` WHERE `id` <> 60291211 AND `partno` = '748365-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.003851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13175754 [ RunTime:0.001042s ]
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 '7483%' OR `brand` LIKE '7483%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004699s ]
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 '7483%' OR `brand` LIKE '7483%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006126s ]
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 '7483%' OR `brand` LIKE '7483%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016860s ]
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 '7483%' OR `brand` LIKE '7483%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002773s ]
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 '7483%' OR `brand` LIKE '7483%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006706s ]
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 '7483%' OR `brand` LIKE '7483%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001613s ]
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 '7483%' OR `brand` LIKE '7483%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010229s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '7483%' OR `brand` LIKE '7483%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002254s ]