SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003050s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.116' , `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=5923&search=1' [ RunTime:0.005731s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003152s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000644s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001966s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.116' ) [ RunTime:0.001397s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001819s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000329s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003191s ]
SELECT * FROM `stock_search` WHERE `partno` = '5923' LIMIT 1 [ RunTime:0.002424s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-23 03:54:12' WHERE `partno` = '5923' [ RunTime:0.004480s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002060s ]
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 '5923%' OR `brand` LIKE '5923%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013924s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15250445 LIMIT 5 [ RunTime:0.002407s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15250445 ORDER BY `minOrder` ASC [ RunTime:0.001044s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15250445 ORDER BY `unit` DESC [ RunTime:0.005127s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15250445 LIMIT 2 [ RunTime:0.000927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15250445 ORDER BY `minOrder` ASC [ RunTime:0.010015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15250157 LIMIT 5 [ RunTime:0.013805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15250157 ORDER BY `minOrder` ASC [ RunTime:0.008081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15250157 ORDER BY `unit` DESC [ RunTime:0.007107s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15250157 LIMIT 2 [ RunTime:0.015088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15250157 ORDER BY `minOrder` ASC [ RunTime:0.013502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18905623 LIMIT 5 [ RunTime:0.004751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18905623 ORDER BY `minOrder` ASC [ RunTime:0.008436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18905623 ORDER BY `unit` DESC [ RunTime:0.009319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18905623 LIMIT 2 [ RunTime:0.003511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18905623 ORDER BY `minOrder` ASC [ RunTime:0.003155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18908791 LIMIT 5 [ RunTime:0.004389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18908791 ORDER BY `minOrder` ASC [ RunTime:0.000781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18908791 ORDER BY `unit` DESC [ RunTime:0.006844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18908791 LIMIT 2 [ RunTime:0.002645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18908791 ORDER BY `minOrder` ASC [ RunTime:0.002026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17033830 LIMIT 5 [ RunTime:0.006255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17033830 ORDER BY `minOrder` ASC [ RunTime:0.002433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17033830 ORDER BY `unit` DESC [ RunTime:0.001163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17033830 LIMIT 2 [ RunTime:0.007619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17033830 ORDER BY `minOrder` ASC [ RunTime:0.000495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13344637 LIMIT 5 [ RunTime:0.009172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13344637 ORDER BY `minOrder` ASC [ RunTime:0.009568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13344637 ORDER BY `unit` DESC [ RunTime:0.004877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13344637 LIMIT 2 [ RunTime:0.009930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13344637 ORDER BY `minOrder` ASC [ RunTime:0.013494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17124802 LIMIT 5 [ RunTime:0.013719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17124802 ORDER BY `minOrder` ASC [ RunTime:0.009259s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17124802 ORDER BY `unit` DESC [ RunTime:0.013849s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17124802 LIMIT 2 [ RunTime:0.071999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17124802 ORDER BY `minOrder` ASC [ RunTime:0.012467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18909220 LIMIT 5 [ RunTime:0.017203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18909220 ORDER BY `minOrder` ASC [ RunTime:0.010513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18909220 ORDER BY `unit` DESC [ RunTime:0.024155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18909220 LIMIT 2 [ RunTime:0.022229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18909220 ORDER BY `minOrder` ASC [ RunTime:0.008008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15249891 LIMIT 5 [ RunTime:0.008549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15249891 ORDER BY `minOrder` ASC [ RunTime:0.008455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15249891 ORDER BY `unit` DESC [ RunTime:0.031293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15249891 LIMIT 2 [ RunTime:0.018771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15249891 ORDER BY `minOrder` ASC [ RunTime:0.006672s ]
select * from pdf where partno='5923131834F' and brandshort='Dialight' limit 1 [ RunTime:0.008379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18963887 LIMIT 5 [ RunTime:0.016474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18963887 ORDER BY `minOrder` ASC [ RunTime:0.018815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18963887 ORDER BY `unit` DESC [ RunTime:0.007409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18963887 LIMIT 2 [ RunTime:0.008848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18963887 ORDER BY `minOrder` ASC [ RunTime:0.014125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18963885 LIMIT 5 [ RunTime:0.026948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18963885 ORDER BY `minOrder` ASC [ RunTime:0.020404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18963885 ORDER BY `unit` DESC [ RunTime:0.014488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18963885 LIMIT 2 [ RunTime:0.020818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18963885 ORDER BY `minOrder` ASC [ RunTime:0.013780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18963883 LIMIT 5 [ RunTime:0.025841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18963883 ORDER BY `minOrder` ASC [ RunTime:0.026594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18963883 ORDER BY `unit` DESC [ RunTime:0.012975s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18963883 LIMIT 2 [ RunTime:0.018747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18963883 ORDER BY `minOrder` ASC [ RunTime:0.025401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18963876 LIMIT 5 [ RunTime:0.005103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18963876 ORDER BY `minOrder` ASC [ RunTime:0.018126s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18963876 ORDER BY `unit` DESC [ RunTime:0.004998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18963876 LIMIT 2 [ RunTime:0.013720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18963876 ORDER BY `minOrder` ASC [ RunTime:0.016644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18963866 LIMIT 5 [ RunTime:0.033861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18963866 ORDER BY `minOrder` ASC [ RunTime:0.028612s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18963866 ORDER BY `unit` DESC [ RunTime:0.011400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18963866 LIMIT 2 [ RunTime:0.026373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18963866 ORDER BY `minOrder` ASC [ RunTime:0.026528s ]
select * from pdf where partno='5923333313F' and brandshort='Dialight' limit 1 [ RunTime:0.023631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18908883 LIMIT 5 [ RunTime:0.024040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18908883 ORDER BY `minOrder` ASC [ RunTime:0.010240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18908883 ORDER BY `unit` DESC [ RunTime:0.026971s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18908883 LIMIT 2 [ RunTime:0.018667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18908883 ORDER BY `minOrder` ASC [ RunTime:0.000562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18908862 LIMIT 5 [ RunTime:0.001473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18908862 ORDER BY `minOrder` ASC [ RunTime:0.018779s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18908862 ORDER BY `unit` DESC [ RunTime:0.027511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18908862 LIMIT 2 [ RunTime:0.021957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18908862 ORDER BY `minOrder` ASC [ RunTime:0.003377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18907860 LIMIT 5 [ RunTime:0.007350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907860 ORDER BY `minOrder` ASC [ RunTime:0.014118s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18907860 ORDER BY `unit` DESC [ RunTime:0.018991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18907860 LIMIT 2 [ RunTime:0.015124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907860 ORDER BY `minOrder` ASC [ RunTime:0.008993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18907696 LIMIT 5 [ RunTime:0.023462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907696 ORDER BY `minOrder` ASC [ RunTime:0.017644s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18907696 ORDER BY `unit` DESC [ RunTime:0.020225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18907696 LIMIT 2 [ RunTime:0.009950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907696 ORDER BY `minOrder` ASC [ RunTime:0.011774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18907641 LIMIT 5 [ RunTime:0.011997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907641 ORDER BY `minOrder` ASC [ RunTime:0.009060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18907641 ORDER BY `unit` DESC [ RunTime:0.020118s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18907641 LIMIT 2 [ RunTime:0.004993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907641 ORDER BY `minOrder` ASC [ RunTime:0.006675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18907615 LIMIT 5 [ RunTime:0.027914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907615 ORDER BY `minOrder` ASC [ RunTime:0.020027s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18907615 ORDER BY `unit` DESC [ RunTime:0.031865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18907615 LIMIT 2 [ RunTime:0.013741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907615 ORDER BY `minOrder` ASC [ RunTime:0.000513s ]
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 '5923%' OR `brand` LIKE '5923%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017794s ]
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 '5923%' OR `brand` LIKE '5923%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51241933 LIMIT 5 [ RunTime:0.025770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51241933 ORDER BY `minOrder` ASC [ RunTime:0.022105s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51241933 ORDER BY `unit` DESC [ RunTime:0.026444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51241933 LIMIT 2 [ RunTime:0.004146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51241933 ORDER BY `minOrder` ASC [ RunTime:0.006718s ]
select * from pdf where partno='5923131313F' and brandshort='Dialight' limit 1 [ RunTime:0.017755s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003743s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923131313F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.010829s ]
SELECT `id` FROM `stock` WHERE `id` <> 51241933 AND `partno` = '5923131313F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.015633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17033830 [ RunTime:0.009177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51242130 LIMIT 5 [ RunTime:0.015690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51242130 ORDER BY `minOrder` ASC [ RunTime:0.018067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51242130 ORDER BY `unit` DESC [ RunTime:0.017520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51242130 LIMIT 2 [ RunTime:0.011132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51242130 ORDER BY `minOrder` ASC [ RunTime:0.006531s ]
select * from pdf where partno='5923030820SF' and brandshort='Dialight' limit 1 [ RunTime:0.030264s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923030820SF' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.029041s ]
SELECT `id` FROM `stock` WHERE `id` <> 51242130 AND `partno` = '5923030820SF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.011398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15250157 [ RunTime:0.019663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51242334 LIMIT 5 [ RunTime:0.023719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51242334 ORDER BY `minOrder` ASC [ RunTime:0.029430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51242334 ORDER BY `unit` DESC [ RunTime:0.008607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51242334 LIMIT 2 [ RunTime:0.004789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51242334 ORDER BY `minOrder` ASC [ RunTime:0.006195s ]
select * from pdf where partno='5923720313NF' and brandshort='Dialight' limit 1 [ RunTime:0.009391s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923720313NF' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.020685s ]
SELECT `id` FROM `stock` WHERE `id` <> 51242334 AND `partno` = '5923720313NF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.006211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51242333 LIMIT 5 [ RunTime:0.007664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51242333 ORDER BY `minOrder` ASC [ RunTime:0.006437s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51242333 ORDER BY `unit` DESC [ RunTime:0.008002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51242333 LIMIT 2 [ RunTime:0.013958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51242333 ORDER BY `minOrder` ASC [ RunTime:0.006214s ]
select * from pdf where partno='5923731313NF' and brandshort='Dialight' limit 1 [ RunTime:0.001551s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923731313NF' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.003622s ]
SELECT `id` FROM `stock` WHERE `id` <> 51242333 AND `partno` = '5923731313NF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.001752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51242332 LIMIT 5 [ RunTime:0.014470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51242332 ORDER BY `minOrder` ASC [ RunTime:0.002065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51242332 ORDER BY `unit` DESC [ RunTime:0.008214s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51242332 LIMIT 2 [ RunTime:0.005643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51242332 ORDER BY `minOrder` ASC [ RunTime:0.003148s ]
select * from pdf where partno='5923730313NF' and brandshort='Dialight' limit 1 [ RunTime:0.006680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923730313NF' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.003585s ]
SELECT `id` FROM `stock` WHERE `id` <> 51242332 AND `partno` = '5923730313NF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.003140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51241934 LIMIT 5 [ RunTime:0.001022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51241934 ORDER BY `minOrder` ASC [ RunTime:0.002669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51241934 ORDER BY `unit` DESC [ RunTime:0.003316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51241934 LIMIT 2 [ RunTime:0.002805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51241934 ORDER BY `minOrder` ASC [ RunTime:0.007265s ]
select * from pdf where partno='5923131834F' and brandshort='Dialight' limit 1 [ RunTime:0.001969s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923131834F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.009177s ]
SELECT `id` FROM `stock` WHERE `id` <> 51241934 AND `partno` = '5923131834F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.009719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15249891 [ RunTime:0.004318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56510121 LIMIT 5 [ RunTime:0.004825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56510121 ORDER BY `minOrder` ASC [ RunTime:0.001909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56510121 ORDER BY `unit` DESC [ RunTime:0.012094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56510121 LIMIT 2 [ RunTime:0.004604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56510121 ORDER BY `minOrder` ASC [ RunTime:0.008377s ]
select * from pdf where partno='59230-4-T-02-A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.007474s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '59230-4-T-02-A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.016267s ]
SELECT `id` FROM `stock` WHERE `id` <> 56510121 AND `partno` = '59230-4-T-02-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.007328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17124802 [ RunTime:0.001564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50752795 LIMIT 5 [ RunTime:0.007775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50752795 ORDER BY `minOrder` ASC [ RunTime:0.010270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50752795 ORDER BY `unit` DESC [ RunTime:0.004143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50752795 LIMIT 2 [ RunTime:0.003709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50752795 ORDER BY `minOrder` ASC [ RunTime:0.001323s ]
select * from pdf where partno='5923CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.012467s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.004941s ]
SELECT `id` FROM `stock` WHERE `id` <> 50752795 AND `partno` = '5923CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.009687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13344637 [ RunTime:0.011418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38160776 LIMIT 5 [ RunTime:0.010974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38160776 ORDER BY `minOrder` ASC [ RunTime:0.004015s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38160776 ORDER BY `unit` DESC [ RunTime:0.009429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38160776 LIMIT 2 [ RunTime:0.006362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38160776 ORDER BY `minOrder` ASC [ RunTime:0.006256s ]
select * from pdf where partno='5923CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.003622s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.010163s ]
SELECT `id` FROM `stock` WHERE `id` <> 38160776 AND `partno` = '5923CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.006502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13344637 [ RunTime:0.006942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51242530 LIMIT 5 [ RunTime:0.003482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51242530 ORDER BY `minOrder` ASC [ RunTime:0.008061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51242530 ORDER BY `unit` DESC [ RunTime:0.001714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51242530 LIMIT 2 [ RunTime:0.008365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51242530 ORDER BY `minOrder` ASC [ RunTime:0.004543s ]
select * from pdf where partno='5923031313F' and brandshort='Dialight' limit 1 [ RunTime:0.002360s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923031313F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.016401s ]
SELECT `id` FROM `stock` WHERE `id` <> 51242530 AND `partno` = '5923031313F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.014540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904215 [ RunTime:0.009121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56207763 LIMIT 5 [ RunTime:0.008330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56207763 ORDER BY `minOrder` ASC [ RunTime:0.006286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56207763 ORDER BY `unit` DESC [ RunTime:0.001127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56207763 LIMIT 2 [ RunTime:0.007203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56207763 ORDER BY `minOrder` ASC [ RunTime:0.002823s ]
select * from pdf where partno='5923 SL199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.001071s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923 SL199' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.003283s ]
SELECT `id` FROM `stock` WHERE `id` <> 56207763 AND `partno` = '5923 SL199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.003499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13505147 [ RunTime:0.001200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56206025 LIMIT 5 [ RunTime:0.001912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56206025 ORDER BY `minOrder` ASC [ RunTime:0.001183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56206025 ORDER BY `unit` DESC [ RunTime:0.007566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56206025 LIMIT 2 [ RunTime:0.009134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56206025 ORDER BY `minOrder` ASC [ RunTime:0.000483s ]
select * from pdf where partno='5923 SL002' and brandshort='Alpha Wire' limit 1 [ RunTime:0.001014s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923 SL002' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000828s ]
SELECT `id` FROM `stock` WHERE `id` <> 56206025 AND `partno` = '5923 SL002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.004801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13504968 [ RunTime:0.006354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56202448 LIMIT 5 [ RunTime:0.009149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56202448 ORDER BY `minOrder` ASC [ RunTime:0.001977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56202448 ORDER BY `unit` DESC [ RunTime:0.001239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56202448 LIMIT 2 [ RunTime:0.001895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56202448 ORDER BY `minOrder` ASC [ RunTime:0.007131s ]
select * from pdf where partno='5923 SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.007926s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923 SL001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.001623s ]
SELECT `id` FROM `stock` WHERE `id` <> 56202448 AND `partno` = '5923 SL001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.003926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14376818 [ RunTime:0.000540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56193392 LIMIT 5 [ RunTime:0.004662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56193392 ORDER BY `minOrder` ASC [ RunTime:0.004751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56193392 ORDER BY `unit` DESC [ RunTime:0.001596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56193392 LIMIT 2 [ RunTime:0.013098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56193392 ORDER BY `minOrder` ASC [ RunTime:0.002058s ]
select * from pdf where partno='5923 SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.010179s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923 SL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.004718s ]
SELECT `id` FROM `stock` WHERE `id` <> 56193392 AND `partno` = '5923 SL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.003733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13517196 [ RunTime:0.016204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55384572 LIMIT 5 [ RunTime:0.008515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55384572 ORDER BY `minOrder` ASC [ RunTime:0.007904s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55384572 ORDER BY `unit` DESC [ RunTime:0.011606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55384572 LIMIT 2 [ RunTime:0.012934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55384572 ORDER BY `minOrder` ASC [ RunTime:0.004155s ]
select * from pdf where partno='5923' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.013879s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.032497s ]
SELECT `id` FROM `stock` WHERE `id` <> 55384572 AND `partno` = '5923' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.020991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17506014 [ RunTime:0.029927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51666586 LIMIT 5 [ RunTime:0.020027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51666586 ORDER BY `minOrder` ASC [ RunTime:0.016403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51666586 ORDER BY `unit` DESC [ RunTime:0.005548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51666586 LIMIT 2 [ RunTime:0.010888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51666586 ORDER BY `minOrder` ASC [ RunTime:0.005297s ]
select * from pdf where partno='59239-8' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.009149s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '59239-8' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.002952s ]
SELECT `id` FROM `stock` WHERE `id` <> 51666586 AND `partno` = '59239-8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.005537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51662900 LIMIT 5 [ RunTime:0.014756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51662900 ORDER BY `minOrder` ASC [ RunTime:0.005067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51662900 ORDER BY `unit` DESC [ RunTime:0.014257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51662900 LIMIT 2 [ RunTime:0.005214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51662900 ORDER BY `minOrder` ASC [ RunTime:0.003494s ]
select * from pdf where partno='59239-4' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.002412s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '59239-4' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.013795s ]
SELECT `id` FROM `stock` WHERE `id` <> 51662900 AND `partno` = '59239-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.005050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51247251 LIMIT 5 [ RunTime:0.007004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51247251 ORDER BY `minOrder` ASC [ RunTime:0.011079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51247251 ORDER BY `unit` DESC [ RunTime:0.009594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51247251 LIMIT 2 [ RunTime:0.002392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51247251 ORDER BY `minOrder` ASC [ RunTime:0.000378s ]
select * from pdf where partno='5923535302F' and brandshort='Dialight' limit 1 [ RunTime:0.005439s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923535302F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.010230s ]
SELECT `id` FROM `stock` WHERE `id` <> 51247251 AND `partno` = '5923535302F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.006909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18907860 [ RunTime:0.013780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51247129 LIMIT 5 [ RunTime:0.010859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51247129 ORDER BY `minOrder` ASC [ RunTime:0.025778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51247129 ORDER BY `unit` DESC [ RunTime:0.020211s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51247129 LIMIT 2 [ RunTime:0.013736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51247129 ORDER BY `minOrder` ASC [ RunTime:0.002871s ]
select * from pdf where partno='5923535803F' and brandshort='Dialight' limit 1 [ RunTime:0.019897s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923535803F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.013957s ]
SELECT `id` FROM `stock` WHERE `id` <> 51247129 AND `partno` = '5923535803F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.009040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17034436 [ RunTime:0.023162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51247063 LIMIT 5 [ RunTime:0.007505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51247063 ORDER BY `minOrder` ASC [ RunTime:0.010384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51247063 ORDER BY `unit` DESC [ RunTime:0.005791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51247063 LIMIT 2 [ RunTime:0.008801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51247063 ORDER BY `minOrder` ASC [ RunTime:0.012047s ]
select * from pdf where partno='5923026302F' and brandshort='Dialight' limit 1 [ RunTime:0.008538s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923026302F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.008612s ]
SELECT `id` FROM `stock` WHERE `id` <> 51247063 AND `partno` = '5923026302F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.017359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17034425 [ RunTime:0.008297s ]
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 '5923%' OR `brand` LIKE '5923%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006489s ]
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 '5923%' OR `brand` LIKE '5923%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010083s ]
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 '5923%' OR `brand` LIKE '5923%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013527s ]
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 '5923%' OR `brand` LIKE '5923%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010146s ]
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 '5923%' OR `brand` LIKE '5923%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007605s ]
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 '5923%' OR `brand` LIKE '5923%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021801s ]
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 '5923%' OR `brand` LIKE '5923%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005044s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5923%' OR `brand` LIKE '5923%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.008095s ]