SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001764s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.111' , `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=A3F&search=1' [ RunTime:0.002080s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001628s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.010032s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001843s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.111' ) [ RunTime:0.000807s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001893s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001910s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002166s ]
SELECT * FROM `stock_search` WHERE `partno` = 'A3F' LIMIT 1 [ RunTime:0.003024s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-13 15:28:55' WHERE `partno` = 'A3F' [ RunTime:0.003837s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001487s ]
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 'A3F%' OR `brand` LIKE 'A3F%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011356s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17154605 LIMIT 5 [ RunTime:0.007375s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17154605 ORDER BY `minOrder` ASC [ RunTime:0.000538s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17154605 ORDER BY `unit` DESC [ RunTime:0.008234s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17154605 LIMIT 2 [ RunTime:0.009462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17154605 ORDER BY `minOrder` ASC [ RunTime:0.000362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15374935 LIMIT 5 [ RunTime:0.008317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15374935 ORDER BY `minOrder` ASC [ RunTime:0.023208s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15374935 ORDER BY `unit` DESC [ RunTime:0.015378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15374935 LIMIT 2 [ RunTime:0.013011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15374935 ORDER BY `minOrder` ASC [ RunTime:0.002710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19303678 LIMIT 5 [ RunTime:0.001199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19303678 ORDER BY `minOrder` ASC [ RunTime:0.001873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19303678 ORDER BY `unit` DESC [ RunTime:0.003627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19303678 LIMIT 2 [ RunTime:0.006302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19303678 ORDER BY `minOrder` ASC [ RunTime:0.002300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19303583 LIMIT 5 [ RunTime:0.007851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19303583 ORDER BY `minOrder` ASC [ RunTime:0.005836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19303583 ORDER BY `unit` DESC [ RunTime:0.015182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19303583 LIMIT 2 [ RunTime:0.006270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19303583 ORDER BY `minOrder` ASC [ RunTime:0.002801s ]
select * from pdf where partno='A3F1ASQ12VDC2' and brandshort='CIT Relay and Switch' limit 1 [ RunTime:0.008003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19303481 LIMIT 5 [ RunTime:0.012745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19303481 ORDER BY `minOrder` ASC [ RunTime:0.007029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19303481 ORDER BY `unit` DESC [ RunTime:0.010652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19303481 LIMIT 2 [ RunTime:0.000464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19303481 ORDER BY `minOrder` ASC [ RunTime:0.001943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17154628 LIMIT 5 [ RunTime:0.004119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17154628 ORDER BY `minOrder` ASC [ RunTime:0.014076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17154628 ORDER BY `unit` DESC [ RunTime:0.019012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17154628 LIMIT 2 [ RunTime:0.000704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17154628 ORDER BY `minOrder` ASC [ RunTime:0.006315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19303453 LIMIT 5 [ RunTime:0.008085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19303453 ORDER BY `minOrder` ASC [ RunTime:0.006924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19303453 ORDER BY `unit` DESC [ RunTime:0.012194s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19303453 LIMIT 2 [ RunTime:0.009064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19303453 ORDER BY `minOrder` ASC [ RunTime:0.001748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10752830 LIMIT 5 [ RunTime:0.000983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10752830 ORDER BY `minOrder` ASC [ RunTime:0.006039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10752830 ORDER BY `unit` DESC [ RunTime:0.016915s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10752830 LIMIT 2 [ RunTime:0.015169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10752830 ORDER BY `minOrder` ASC [ RunTime:0.002407s ]
select * from pdf where partno='A3F' and brandshort='Switchcraft Inc.' limit 1 [ RunTime:0.005725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10858260 LIMIT 5 [ RunTime:0.007712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10858260 ORDER BY `minOrder` ASC [ RunTime:0.010719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10858260 ORDER BY `unit` DESC [ RunTime:0.002340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10858260 LIMIT 2 [ RunTime:0.006485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10858260 ORDER BY `minOrder` ASC [ RunTime:0.005322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10851681 LIMIT 5 [ RunTime:0.015545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10851681 ORDER BY `minOrder` ASC [ RunTime:0.022541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10851681 ORDER BY `unit` DESC [ RunTime:0.013606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10851681 LIMIT 2 [ RunTime:0.014466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10851681 ORDER BY `minOrder` ASC [ RunTime:0.009115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10831773 LIMIT 5 [ RunTime:0.009385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10831773 ORDER BY `minOrder` ASC [ RunTime:0.013368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10831773 ORDER BY `unit` DESC [ RunTime:0.034949s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10831773 LIMIT 2 [ RunTime:0.014533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10831773 ORDER BY `minOrder` ASC [ RunTime:0.000965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19303011 LIMIT 5 [ RunTime:0.004474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19303011 ORDER BY `minOrder` ASC [ RunTime:0.022322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19303011 ORDER BY `unit` DESC [ RunTime:0.016551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19303011 LIMIT 2 [ RunTime:0.014408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19303011 ORDER BY `minOrder` ASC [ RunTime:0.000832s ]
select * from pdf where partno='A3F1CSP24VDC2D' and brandshort='CIT Relay and Switch' limit 1 [ RunTime:0.003893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19303010 LIMIT 5 [ RunTime:0.018291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19303010 ORDER BY `minOrder` ASC [ RunTime:0.010276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19303010 ORDER BY `unit` DESC [ RunTime:0.008596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19303010 LIMIT 2 [ RunTime:0.001278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19303010 ORDER BY `minOrder` ASC [ RunTime:0.010792s ]
select * from pdf where partno='A3F1CSP24VDC2R' and brandshort='CIT Relay and Switch' limit 1 [ RunTime:0.028635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19303006 LIMIT 5 [ RunTime:0.036240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19303006 ORDER BY `minOrder` ASC [ RunTime:0.017795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19303006 ORDER BY `unit` DESC [ RunTime:0.015605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19303006 LIMIT 2 [ RunTime:0.020927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19303006 ORDER BY `minOrder` ASC [ RunTime:0.015694s ]
select * from pdf where partno='A3F1CSP24VDC2' and brandshort='CIT Relay and Switch' limit 1 [ RunTime:0.032741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19303000 LIMIT 5 [ RunTime:0.012314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19303000 ORDER BY `minOrder` ASC [ RunTime:0.018944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19303000 ORDER BY `unit` DESC [ RunTime:0.034201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19303000 LIMIT 2 [ RunTime:0.022191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19303000 ORDER BY `minOrder` ASC [ RunTime:0.013353s ]
select * from pdf where partno='A3F1CSP12VDC2' and brandshort='CIT Relay and Switch' limit 1 [ RunTime:0.019351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19302982 LIMIT 5 [ RunTime:0.025539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19302982 ORDER BY `minOrder` ASC [ RunTime:0.022310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19302982 ORDER BY `unit` DESC [ RunTime:0.015407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19302982 LIMIT 2 [ RunTime:0.008750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19302982 ORDER BY `minOrder` ASC [ RunTime:0.021628s ]
select * from pdf where partno='A3F1CCQ24VDC2D' and brandshort='CIT Relay and Switch' limit 1 [ RunTime:0.024886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19302961 LIMIT 5 [ RunTime:0.008665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19302961 ORDER BY `minOrder` ASC [ RunTime:0.035874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19302961 ORDER BY `unit` DESC [ RunTime:0.059505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19302961 LIMIT 2 [ RunTime:0.005302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19302961 ORDER BY `minOrder` ASC [ RunTime:0.006946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19302958 LIMIT 5 [ RunTime:0.038672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19302958 ORDER BY `minOrder` ASC [ RunTime:0.041362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19302958 ORDER BY `unit` DESC [ RunTime:0.010037s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19302958 LIMIT 2 [ RunTime:0.016433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19302958 ORDER BY `minOrder` ASC [ RunTime:0.003377s ]
select * from pdf where partno='A3F1CCQ24VDC2R' and brandshort='CIT Relay and Switch' limit 1 [ RunTime:0.026380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19302954 LIMIT 5 [ RunTime:0.013861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19302954 ORDER BY `minOrder` ASC [ RunTime:0.011165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19302954 ORDER BY `unit` DESC [ RunTime:0.005518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19302954 LIMIT 2 [ RunTime:0.000401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19302954 ORDER BY `minOrder` ASC [ RunTime:0.000216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19302952 LIMIT 5 [ RunTime:0.000318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19302952 ORDER BY `minOrder` ASC [ RunTime:0.001732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19302952 ORDER BY `unit` DESC [ RunTime:0.009954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19302952 LIMIT 2 [ RunTime:0.030874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19302952 ORDER BY `minOrder` ASC [ RunTime:0.040139s ]
select * from pdf where partno='A3F1CCQ24VDC2' and brandshort='CIT Relay and Switch' limit 1 [ RunTime:0.016051s ]
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 'A3F%' OR `brand` LIKE 'A3F%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51034027 LIMIT 5 [ RunTime:0.006429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51034027 ORDER BY `minOrder` ASC [ RunTime:0.014269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51034027 ORDER BY `unit` DESC [ RunTime:0.008840s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51034027 LIMIT 2 [ RunTime:0.034104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51034027 ORDER BY `minOrder` ASC [ RunTime:0.018296s ]
select * from pdf where partno='a3f4gh40dbf-wc' and brandshort='zentel japan' limit 1 [ RunTime:0.009000s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002884s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'a3f4gh40dbf-wc' OR `brand` LIKE 'zentel japan%' ) ) LIMIT 1 [ RunTime:0.028539s ]
SELECT `id` FROM `stock` WHERE `id` <> 51034027 AND `partno` = 'a3f4gh40dbf-wc' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%zentel japan%' ) [ RunTime:0.009907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32271939 LIMIT 5 [ RunTime:0.011397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32271939 ORDER BY `minOrder` ASC [ RunTime:0.027487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32271939 ORDER BY `unit` DESC [ RunTime:0.007395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32271939 LIMIT 2 [ RunTime:0.014466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32271939 ORDER BY `minOrder` ASC [ RunTime:0.021190s ]
select * from pdf where partno='a3fd' and brandshort='switchcraft' limit 1 [ RunTime:0.017556s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'a3fd' OR `brand` LIKE 'switchcraft%' ) ) LIMIT 1 [ RunTime:0.004246s ]
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 'A3F%' OR `brand` LIKE 'A3F%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64463033 LIMIT 5 [ RunTime:0.000512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64463033 ORDER BY `minOrder` ASC [ RunTime:0.009098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64463033 ORDER BY `unit` DESC [ RunTime:0.005040s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64463033 LIMIT 2 [ RunTime:0.000427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64463033 ORDER BY `minOrder` ASC [ RunTime:0.000298s ]
select * from pdf where partno='A3F1ASQ12VDC2R' and brandshort='CIT Relay and Switch' limit 1 [ RunTime:0.008733s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A3F1ASQ12VDC2R' OR `brand` LIKE 'CIT Relay and Switch%' ) ) LIMIT 1 [ RunTime:0.011738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64463185 LIMIT 5 [ RunTime:0.009167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64463185 ORDER BY `minOrder` ASC [ RunTime:0.014093s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64463185 ORDER BY `unit` DESC [ RunTime:0.032757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64463185 LIMIT 2 [ RunTime:0.002622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64463185 ORDER BY `minOrder` ASC [ RunTime:0.002679s ]
select * from pdf where partno='A3F1ASQ12VDC2D' and brandshort='CIT Relay and Switch' limit 1 [ RunTime:0.015543s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A3F1ASQ12VDC2D' OR `brand` LIKE 'CIT Relay and Switch%' ) ) LIMIT 1 [ RunTime:0.027725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64463306 LIMIT 5 [ RunTime:0.006968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64463306 ORDER BY `minOrder` ASC [ RunTime:0.017241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64463306 ORDER BY `unit` DESC [ RunTime:0.012414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64463306 LIMIT 2 [ RunTime:0.010549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64463306 ORDER BY `minOrder` ASC [ RunTime:0.006073s ]
select * from pdf where partno='A3F1CSQ24VDC2' and brandshort='CIT Relay and Switch' limit 1 [ RunTime:0.018884s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A3F1CSQ24VDC2' OR `brand` LIKE 'CIT Relay and Switch%' ) ) LIMIT 1 [ RunTime:0.011905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61011680 LIMIT 5 [ RunTime:0.005909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61011680 ORDER BY `minOrder` ASC [ RunTime:0.002762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61011680 ORDER BY `unit` DESC [ RunTime:0.009784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61011680 LIMIT 2 [ RunTime:0.027154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61011680 ORDER BY `minOrder` ASC [ RunTime:0.018064s ]
select * from pdf where partno='A3F' and brandshort='Switchcraft Inc.' limit 1 [ RunTime:0.006175s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A3F' OR `brand` LIKE 'Switchcraft Inc.%' ) ) LIMIT 1 [ RunTime:0.019690s ]
SELECT `id` FROM `stock` WHERE `id` <> 61011680 AND `partno` = 'A3F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%switchcraft inc.%' ) [ RunTime:0.041590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10752830 [ RunTime:0.013902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64463184 LIMIT 5 [ RunTime:0.045437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64463184 ORDER BY `minOrder` ASC [ RunTime:0.015677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64463184 ORDER BY `unit` DESC [ RunTime:0.003457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64463184 LIMIT 2 [ RunTime:0.001286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64463184 ORDER BY `minOrder` ASC [ RunTime:0.005321s ]
select * from pdf where partno='A3F1ASQ12VDC2' and brandshort='CIT Relay and Switch' limit 1 [ RunTime:0.004924s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A3F1ASQ12VDC2' OR `brand` LIKE 'CIT Relay and Switch%' ) ) LIMIT 1 [ RunTime:0.023614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64463740 LIMIT 5 [ RunTime:0.012180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64463740 ORDER BY `minOrder` ASC [ RunTime:0.020002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64463740 ORDER BY `unit` DESC [ RunTime:0.000685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64463740 LIMIT 2 [ RunTime:0.002055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64463740 ORDER BY `minOrder` ASC [ RunTime:0.009213s ]
select * from pdf where partno='A3F1ASQ24VDC2D' and brandshort='CIT Relay and Switch' limit 1 [ RunTime:0.011230s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A3F1ASQ24VDC2D' OR `brand` LIKE 'CIT Relay and Switch%' ) ) LIMIT 1 [ RunTime:0.015866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64463741 LIMIT 5 [ RunTime:0.027796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64463741 ORDER BY `minOrder` ASC [ RunTime:0.011286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64463741 ORDER BY `unit` DESC [ RunTime:0.010578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64463741 LIMIT 2 [ RunTime:0.014153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64463741 ORDER BY `minOrder` ASC [ RunTime:0.007692s ]
select * from pdf where partno='A3F1ASQ24VDC2R' and brandshort='CIT Relay and Switch' limit 1 [ RunTime:0.004117s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A3F1ASQ24VDC2R' OR `brand` LIKE 'CIT Relay and Switch%' ) ) LIMIT 1 [ RunTime:0.003518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64463799 LIMIT 5 [ RunTime:0.009795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64463799 ORDER BY `minOrder` ASC [ RunTime:0.003197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64463799 ORDER BY `unit` DESC [ RunTime:0.016233s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64463799 LIMIT 2 [ RunTime:0.007514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64463799 ORDER BY `minOrder` ASC [ RunTime:0.003106s ]
select * from pdf where partno='A3F1CSQ12VDC2R' and brandshort='CIT Relay and Switch' limit 1 [ RunTime:0.030052s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A3F1CSQ12VDC2R' OR `brand` LIKE 'CIT Relay and Switch%' ) ) LIMIT 1 [ RunTime:0.009340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64463791 LIMIT 5 [ RunTime:0.004382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64463791 ORDER BY `minOrder` ASC [ RunTime:0.002326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64463791 ORDER BY `unit` DESC [ RunTime:0.003301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64463791 LIMIT 2 [ RunTime:0.006014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64463791 ORDER BY `minOrder` ASC [ RunTime:0.003514s ]
select * from pdf where partno='A3F1ASQ24VDC2' and brandshort='CIT Relay and Switch' limit 1 [ RunTime:0.002237s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A3F1ASQ24VDC2' OR `brand` LIKE 'CIT Relay and Switch%' ) ) LIMIT 1 [ RunTime:0.019125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61152615 LIMIT 5 [ RunTime:0.009196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61152615 ORDER BY `minOrder` ASC [ RunTime:0.005701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61152615 ORDER BY `unit` DESC [ RunTime:0.000592s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61152615 LIMIT 2 [ RunTime:0.011585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61152615 ORDER BY `minOrder` ASC [ RunTime:0.006106s ]
select * from pdf where partno='A3FBXAU' and brandshort='Switchcraft Inc.' limit 1 [ RunTime:0.008374s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A3FBXAU' OR `brand` LIKE 'Switchcraft Inc.%' ) ) LIMIT 1 [ RunTime:0.017974s ]
SELECT `id` FROM `stock` WHERE `id` <> 61152615 AND `partno` = 'A3FBXAU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%switchcraft inc.%' ) [ RunTime:0.007312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10858260 [ RunTime:0.009271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64463744 LIMIT 5 [ RunTime:0.000572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64463744 ORDER BY `minOrder` ASC [ RunTime:0.001500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64463744 ORDER BY `unit` DESC [ RunTime:0.008516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64463744 LIMIT 2 [ RunTime:0.002488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64463744 ORDER BY `minOrder` ASC [ RunTime:0.002694s ]
select * from pdf where partno='A3F1CSQ24VDC2D' and brandshort='CIT Relay and Switch' limit 1 [ RunTime:0.006111s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A3F1CSQ24VDC2D' OR `brand` LIKE 'CIT Relay and Switch%' ) ) LIMIT 1 [ RunTime:0.003865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64463800 LIMIT 5 [ RunTime:0.010325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64463800 ORDER BY `minOrder` ASC [ RunTime:0.011394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64463800 ORDER BY `unit` DESC [ RunTime:0.002903s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64463800 LIMIT 2 [ RunTime:0.032571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64463800 ORDER BY `minOrder` ASC [ RunTime:0.000400s ]
select * from pdf where partno='A3F1CSQ12VDC2D' and brandshort='CIT Relay and Switch' limit 1 [ RunTime:0.008532s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A3F1CSQ12VDC2D' OR `brand` LIKE 'CIT Relay and Switch%' ) ) LIMIT 1 [ RunTime:0.020491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64464569 LIMIT 5 [ RunTime:0.030432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64464569 ORDER BY `minOrder` ASC [ RunTime:0.007735s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64464569 ORDER BY `unit` DESC [ RunTime:0.011043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64464569 LIMIT 2 [ RunTime:0.014055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64464569 ORDER BY `minOrder` ASC [ RunTime:0.001554s ]
select * from pdf where partno='A3F1CSP24VDC2D' and brandshort='CIT Relay and Switch' limit 1 [ RunTime:0.000986s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A3F1CSP24VDC2D' OR `brand` LIKE 'CIT Relay and Switch%' ) ) LIMIT 1 [ RunTime:0.010548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64464568 LIMIT 5 [ RunTime:0.004776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64464568 ORDER BY `minOrder` ASC [ RunTime:0.009399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64464568 ORDER BY `unit` DESC [ RunTime:0.010387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64464568 LIMIT 2 [ RunTime:0.012605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64464568 ORDER BY `minOrder` ASC [ RunTime:0.018204s ]
select * from pdf where partno='A3F1CSP24VDC2R' and brandshort='CIT Relay and Switch' limit 1 [ RunTime:0.000529s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A3F1CSP24VDC2R' OR `brand` LIKE 'CIT Relay and Switch%' ) ) LIMIT 1 [ RunTime:0.020950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64464563 LIMIT 5 [ RunTime:0.005562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64464563 ORDER BY `minOrder` ASC [ RunTime:0.038461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64464563 ORDER BY `unit` DESC [ RunTime:0.013423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64464563 LIMIT 2 [ RunTime:0.033383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64464563 ORDER BY `minOrder` ASC [ RunTime:0.008507s ]
select * from pdf where partno='A3F1CSP24VDC2' and brandshort='CIT Relay and Switch' limit 1 [ RunTime:0.001954s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A3F1CSP24VDC2' OR `brand` LIKE 'CIT Relay and Switch%' ) ) LIMIT 1 [ RunTime:0.007419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64464559 LIMIT 5 [ RunTime:0.024143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64464559 ORDER BY `minOrder` ASC [ RunTime:0.013339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64464559 ORDER BY `unit` DESC [ RunTime:0.006734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64464559 LIMIT 2 [ RunTime:0.012819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64464559 ORDER BY `minOrder` ASC [ RunTime:0.001011s ]
select * from pdf where partno='A3F1CSP12VDC2D' and brandshort='CIT Relay and Switch' limit 1 [ RunTime:0.019149s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A3F1CSP12VDC2D' OR `brand` LIKE 'CIT Relay and Switch%' ) ) LIMIT 1 [ RunTime:0.031536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64464558 LIMIT 5 [ RunTime:0.044192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64464558 ORDER BY `minOrder` ASC [ RunTime:0.026463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64464558 ORDER BY `unit` DESC [ RunTime:0.017251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64464558 LIMIT 2 [ RunTime:0.036038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64464558 ORDER BY `minOrder` ASC [ RunTime:0.018120s ]
select * from pdf where partno='A3F1CSP12VDC2R' and brandshort='CIT Relay and Switch' limit 1 [ RunTime:0.016347s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A3F1CSP12VDC2R' OR `brand` LIKE 'CIT Relay and Switch%' ) ) LIMIT 1 [ RunTime:0.026837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64464554 LIMIT 5 [ RunTime:0.026145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64464554 ORDER BY `minOrder` ASC [ RunTime:0.042904s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64464554 ORDER BY `unit` DESC [ RunTime:0.026348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64464554 LIMIT 2 [ RunTime:0.012269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64464554 ORDER BY `minOrder` ASC [ RunTime:0.014458s ]
select * from pdf where partno='A3F1CSP12VDC2' and brandshort='CIT Relay and Switch' limit 1 [ RunTime:0.000643s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A3F1CSP12VDC2' OR `brand` LIKE 'CIT Relay and Switch%' ) ) LIMIT 1 [ RunTime:0.027261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64464495 LIMIT 5 [ RunTime:0.006123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64464495 ORDER BY `minOrder` ASC [ RunTime:0.003397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64464495 ORDER BY `unit` DESC [ RunTime:0.007641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64464495 LIMIT 2 [ RunTime:0.010885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64464495 ORDER BY `minOrder` ASC [ RunTime:0.004153s ]
select * from pdf where partno='A3F1CCQ24VDC2R' and brandshort='CIT Relay and Switch' limit 1 [ RunTime:0.004467s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A3F1CCQ24VDC2R' OR `brand` LIKE 'CIT Relay and Switch%' ) ) LIMIT 1 [ RunTime:0.008230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64464493 LIMIT 5 [ RunTime:0.021827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64464493 ORDER BY `minOrder` ASC [ RunTime:0.028940s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64464493 ORDER BY `unit` DESC [ RunTime:0.018970s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64464493 LIMIT 2 [ RunTime:0.010392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64464493 ORDER BY `minOrder` ASC [ RunTime:0.004776s ]
select * from pdf where partno='A3F1CCQ24VDC2D' and brandshort='CIT Relay and Switch' limit 1 [ RunTime:0.004855s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A3F1CCQ24VDC2D' OR `brand` LIKE 'CIT Relay and Switch%' ) ) LIMIT 1 [ RunTime:0.015030s ]
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 'A3F%' OR `brand` LIKE 'A3F%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041601s ]
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 'A3F%' OR `brand` LIKE 'A3F%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026308s ]
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 'A3F%' OR `brand` LIKE 'A3F%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013352s ]
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 'A3F%' OR `brand` LIKE 'A3F%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020250s ]
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 'A3F%' OR `brand` LIKE 'A3F%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027708s ]
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 'A3F%' OR `brand` LIKE 'A3F%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040633s ]
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 'A3F%' OR `brand` LIKE 'A3F%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028686s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'A3F%' OR `brand` LIKE 'A3F%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.009579s ]