SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001954s ]
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=592303&search=1' [ RunTime:0.001859s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001574s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002927s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001524s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.116' ) [ RunTime:0.003071s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001222s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002182s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001694s ]
SELECT * FROM `stock_search` WHERE `partno` = '592303' LIMIT 1 [ RunTime:0.011907s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-23 15:38:11' WHERE `partno` = '592303' [ RunTime:0.061243s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002897s ]
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 '592303%' OR `brand` LIKE '592303%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.066885s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15250445 LIMIT 5 [ RunTime:0.097901s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15250445 ORDER BY `minOrder` ASC [ RunTime:0.042885s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15250445 ORDER BY `unit` DESC [ RunTime:0.027836s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15250445 LIMIT 2 [ RunTime:0.008979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15250445 ORDER BY `minOrder` ASC [ RunTime:0.051057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15250157 LIMIT 5 [ RunTime:0.031636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15250157 ORDER BY `minOrder` ASC [ RunTime:0.021166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15250157 ORDER BY `unit` DESC [ RunTime:0.017098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15250157 LIMIT 2 [ RunTime:0.047541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15250157 ORDER BY `minOrder` ASC [ RunTime:0.031947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18908791 LIMIT 5 [ RunTime:0.035726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18908791 ORDER BY `minOrder` ASC [ RunTime:0.033524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18908791 ORDER BY `unit` DESC [ RunTime:0.047264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18908791 LIMIT 2 [ RunTime:0.023934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18908791 ORDER BY `minOrder` ASC [ RunTime:0.022261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18909220 LIMIT 5 [ RunTime:0.042356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18909220 ORDER BY `minOrder` ASC [ RunTime:0.026142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18909220 ORDER BY `unit` DESC [ RunTime:0.076459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18909220 LIMIT 2 [ RunTime:0.030504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18909220 ORDER BY `minOrder` ASC [ RunTime:0.047763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18907615 LIMIT 5 [ RunTime:0.055000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907615 ORDER BY `minOrder` ASC [ RunTime:0.020949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18907615 ORDER BY `unit` DESC [ RunTime:0.017473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18907615 LIMIT 2 [ RunTime:0.026068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907615 ORDER BY `minOrder` ASC [ RunTime:0.020433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18907592 LIMIT 5 [ RunTime:0.020800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907592 ORDER BY `minOrder` ASC [ RunTime:0.013836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18907592 ORDER BY `unit` DESC [ RunTime:0.020538s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18907592 LIMIT 2 [ RunTime:0.078462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907592 ORDER BY `minOrder` ASC [ RunTime:0.055877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18907584 LIMIT 5 [ RunTime:0.041616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907584 ORDER BY `minOrder` ASC [ RunTime:0.035965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18907584 ORDER BY `unit` DESC [ RunTime:0.029940s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18907584 LIMIT 2 [ RunTime:0.017834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907584 ORDER BY `minOrder` ASC [ RunTime:0.004167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18907489 LIMIT 5 [ RunTime:0.016180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907489 ORDER BY `minOrder` ASC [ RunTime:0.006534s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18907489 ORDER BY `unit` DESC [ RunTime:0.021113s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18907489 LIMIT 2 [ RunTime:0.009201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907489 ORDER BY `minOrder` ASC [ RunTime:0.000920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18907488 LIMIT 5 [ RunTime:0.004698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907488 ORDER BY `minOrder` ASC [ RunTime:0.008185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18907488 ORDER BY `unit` DESC [ RunTime:0.011736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18907488 LIMIT 2 [ RunTime:0.017149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907488 ORDER BY `minOrder` ASC [ RunTime:0.002893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18907448 LIMIT 5 [ RunTime:0.013305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907448 ORDER BY `minOrder` ASC [ RunTime:0.017017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18907448 ORDER BY `unit` DESC [ RunTime:0.011341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18907448 LIMIT 2 [ RunTime:0.006737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907448 ORDER BY `minOrder` ASC [ RunTime:0.014012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18907398 LIMIT 5 [ RunTime:0.032942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907398 ORDER BY `minOrder` ASC [ RunTime:0.027489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18907398 ORDER BY `unit` DESC [ RunTime:0.017639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18907398 LIMIT 2 [ RunTime:0.005238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907398 ORDER BY `minOrder` ASC [ RunTime:0.016359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18907008 LIMIT 5 [ RunTime:0.026437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907008 ORDER BY `minOrder` ASC [ RunTime:0.004535s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18907008 ORDER BY `unit` DESC [ RunTime:0.013998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18907008 LIMIT 2 [ RunTime:0.005977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907008 ORDER BY `minOrder` ASC [ RunTime:0.006635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18907007 LIMIT 5 [ RunTime:0.031940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907007 ORDER BY `minOrder` ASC [ RunTime:0.001347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18907007 ORDER BY `unit` DESC [ RunTime:0.010345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18907007 LIMIT 2 [ RunTime:0.006940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907007 ORDER BY `minOrder` ASC [ RunTime:0.014102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18907006 LIMIT 5 [ RunTime:0.013515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907006 ORDER BY `minOrder` ASC [ RunTime:0.001109s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18907006 ORDER BY `unit` DESC [ RunTime:0.006523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18907006 LIMIT 2 [ RunTime:0.004470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907006 ORDER BY `minOrder` ASC [ RunTime:0.016611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904215 LIMIT 5 [ RunTime:0.009145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904215 ORDER BY `minOrder` ASC [ RunTime:0.017167s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18904215 ORDER BY `unit` DESC [ RunTime:0.002959s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18904215 LIMIT 2 [ RunTime:0.009039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904215 ORDER BY `minOrder` ASC [ RunTime:0.004718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904138 LIMIT 5 [ RunTime:0.018199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904138 ORDER BY `minOrder` ASC [ RunTime:0.006250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18904138 ORDER BY `unit` DESC [ RunTime:0.009110s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18904138 LIMIT 2 [ RunTime:0.009463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904138 ORDER BY `minOrder` ASC [ RunTime:0.010773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18712095 LIMIT 5 [ RunTime:0.006067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18712095 ORDER BY `minOrder` ASC [ RunTime:0.018425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18712095 ORDER BY `unit` DESC [ RunTime:0.003590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18712095 LIMIT 2 [ RunTime:0.001579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18712095 ORDER BY `minOrder` ASC [ RunTime:0.009622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17034579 LIMIT 5 [ RunTime:0.002460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17034579 ORDER BY `minOrder` ASC [ RunTime:0.010864s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17034579 ORDER BY `unit` DESC [ RunTime:0.013697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17034579 LIMIT 2 [ RunTime:0.013634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17034579 ORDER BY `minOrder` ASC [ RunTime:0.002266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17034357 LIMIT 5 [ RunTime:0.006695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17034357 ORDER BY `minOrder` ASC [ RunTime:0.030239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17034357 ORDER BY `unit` DESC [ RunTime:0.014177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17034357 LIMIT 2 [ RunTime:0.016789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17034357 ORDER BY `minOrder` ASC [ RunTime:0.035132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16015011 LIMIT 5 [ RunTime:0.027103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16015011 ORDER BY `minOrder` ASC [ RunTime:0.007129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16015011 ORDER BY `unit` DESC [ RunTime:0.009513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16015011 LIMIT 2 [ RunTime:0.028502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16015011 ORDER BY `minOrder` ASC [ RunTime:0.012085s ]
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 '592303%' OR `brand` LIKE '592303%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010497s ]
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 '592303%' OR `brand` LIKE '592303%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51242130 LIMIT 5 [ RunTime:0.003198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51242130 ORDER BY `minOrder` ASC [ RunTime:0.010256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51242130 ORDER BY `unit` DESC [ RunTime:0.000656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51242130 LIMIT 2 [ RunTime:0.010712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51242130 ORDER BY `minOrder` ASC [ RunTime:0.071905s ]
select * from pdf where partno='5923030820SF' and brandshort='Dialight' limit 1 [ RunTime:0.021580s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003057s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923030820SF' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.077505s ]
SELECT `id` FROM `stock` WHERE `id` <> 51242130 AND `partno` = '5923030820SF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.041896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15250157 [ RunTime:0.021095s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51242530 LIMIT 5 [ RunTime:0.004990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51242530 ORDER BY `minOrder` ASC [ RunTime:0.019755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51242530 ORDER BY `unit` DESC [ RunTime:0.032457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51242530 LIMIT 2 [ RunTime:0.034804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51242530 ORDER BY `minOrder` ASC [ RunTime:0.094563s ]
select * from pdf where partno='5923031313F' and brandshort='Dialight' limit 1 [ RunTime:0.137764s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923031313F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.050359s ]
SELECT `id` FROM `stock` WHERE `id` <> 51242530 AND `partno` = '5923031313F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.039125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904215 [ RunTime:0.031349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246911 LIMIT 5 [ RunTime:0.056396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246911 ORDER BY `minOrder` ASC [ RunTime:0.018260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246911 ORDER BY `unit` DESC [ RunTime:0.012776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246911 LIMIT 2 [ RunTime:0.079958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246911 ORDER BY `minOrder` ASC [ RunTime:0.015009s ]
select * from pdf where partno='5923034302F' and brandshort='Dialight' limit 1 [ RunTime:0.020498s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923034302F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.013998s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246911 AND `partno` = '5923034302F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.005015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18907584 [ RunTime:0.032149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246798 LIMIT 5 [ RunTime:0.027376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246798 ORDER BY `minOrder` ASC [ RunTime:0.010031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246798 ORDER BY `unit` DESC [ RunTime:0.035917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246798 LIMIT 2 [ RunTime:0.082756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246798 ORDER BY `minOrder` ASC [ RunTime:0.019439s ]
select * from pdf where partno='5923032302F' and brandshort='Dialight' limit 1 [ RunTime:0.123079s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923032302F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.030768s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246798 AND `partno` = '5923032302F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.041922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16015011 [ RunTime:0.045200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246797 LIMIT 5 [ RunTime:0.048477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246797 ORDER BY `minOrder` ASC [ RunTime:0.024733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246797 ORDER BY `unit` DESC [ RunTime:0.009626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246797 LIMIT 2 [ RunTime:0.041861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246797 ORDER BY `minOrder` ASC [ RunTime:0.069770s ]
select * from pdf where partno='5923036302F' and brandshort='Dialight' limit 1 [ RunTime:0.047844s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923036302F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.036329s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246797 AND `partno` = '5923036302F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.001126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18907489 [ RunTime:0.044042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246796 LIMIT 5 [ RunTime:0.038740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246796 ORDER BY `minOrder` ASC [ RunTime:0.116605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246796 ORDER BY `unit` DESC [ RunTime:0.033450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246796 LIMIT 2 [ RunTime:0.034321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246796 ORDER BY `minOrder` ASC [ RunTime:0.009725s ]
select * from pdf where partno='5923036822F' and brandshort='Dialight' limit 1 [ RunTime:0.038071s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923036822F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.036576s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246796 AND `partno` = '5923036822F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.005581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18907488 [ RunTime:0.006723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246758 LIMIT 5 [ RunTime:0.008807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246758 ORDER BY `minOrder` ASC [ RunTime:0.024725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246758 ORDER BY `unit` DESC [ RunTime:0.018111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246758 LIMIT 2 [ RunTime:0.025901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246758 ORDER BY `minOrder` ASC [ RunTime:0.037695s ]
select * from pdf where partno='5923031302F' and brandshort='Dialight' limit 1 [ RunTime:0.046160s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923031302F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.036915s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246758 AND `partno` = '5923031302F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.047924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18907448 [ RunTime:0.017976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246702 LIMIT 5 [ RunTime:0.029120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246702 ORDER BY `minOrder` ASC [ RunTime:0.011043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246702 ORDER BY `unit` DESC [ RunTime:0.051864s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246702 LIMIT 2 [ RunTime:0.090522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246702 ORDER BY `minOrder` ASC [ RunTime:0.020235s ]
select * from pdf where partno='5923030826SF' and brandshort='Dialight' limit 1 [ RunTime:0.040893s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923030826SF' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.012968s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246702 AND `partno` = '5923030826SF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.007673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18907398 [ RunTime:0.040036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246572 LIMIT 5 [ RunTime:0.014293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246572 ORDER BY `minOrder` ASC [ RunTime:0.018357s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246572 ORDER BY `unit` DESC [ RunTime:0.029778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246572 LIMIT 2 [ RunTime:0.017210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246572 ORDER BY `minOrder` ASC [ RunTime:0.042174s ]
select * from pdf where partno='5923034313F' and brandshort='Dialight' limit 1 [ RunTime:0.029067s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923034313F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.064845s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246572 AND `partno` = '5923034313F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.018947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17034357 [ RunTime:0.019238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246263 LIMIT 5 [ RunTime:0.035221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246263 ORDER BY `minOrder` ASC [ RunTime:0.021664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246263 ORDER BY `unit` DESC [ RunTime:0.019327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246263 LIMIT 2 [ RunTime:0.031074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246263 ORDER BY `minOrder` ASC [ RunTime:0.023216s ]
select * from pdf where partno='59230368823F' and brandshort='Dialight' limit 1 [ RunTime:0.039011s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '59230368823F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.050412s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246263 AND `partno` = '59230368823F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.094104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18907008 [ RunTime:0.121290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246262 LIMIT 5 [ RunTime:0.117705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246262 ORDER BY `minOrder` ASC [ RunTime:0.008529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246262 ORDER BY `unit` DESC [ RunTime:0.068290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246262 LIMIT 2 [ RunTime:0.036003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246262 ORDER BY `minOrder` ASC [ RunTime:0.014077s ]
select * from pdf where partno='5923036313F' and brandshort='Dialight' limit 1 [ RunTime:0.046730s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923036313F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.044340s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246262 AND `partno` = '5923036313F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.011017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18907007 [ RunTime:0.044091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246261 LIMIT 5 [ RunTime:0.012354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246261 ORDER BY `minOrder` ASC [ RunTime:0.028088s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246261 ORDER BY `unit` DESC [ RunTime:0.001773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246261 LIMIT 2 [ RunTime:0.039698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246261 ORDER BY `minOrder` ASC [ RunTime:0.019574s ]
select * from pdf where partno='5923036823F' and brandshort='Dialight' limit 1 [ RunTime:0.063419s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923036823F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.045152s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246261 AND `partno` = '5923036823F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.033464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18907006 [ RunTime:0.009925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246190 LIMIT 5 [ RunTime:0.018524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246190 ORDER BY `minOrder` ASC [ RunTime:0.025822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246190 ORDER BY `unit` DESC [ RunTime:0.018331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246190 LIMIT 2 [ RunTime:0.024553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246190 ORDER BY `minOrder` ASC [ RunTime:0.007562s ]
select * from pdf where partno='5923030013F' and brandshort='Dialight' limit 1 [ RunTime:0.006477s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923030013F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.022943s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246190 AND `partno` = '5923030013F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.009363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18907592 [ RunTime:0.006449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246037 LIMIT 5 [ RunTime:0.015451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246037 ORDER BY `minOrder` ASC [ RunTime:0.012938s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246037 ORDER BY `unit` DESC [ RunTime:0.032393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246037 LIMIT 2 [ RunTime:0.037503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246037 ORDER BY `minOrder` ASC [ RunTime:0.010010s ]
select * from pdf where partno='5923030820F' and brandshort='Dialight' limit 1 [ RunTime:0.027847s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923030820F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.035843s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246037 AND `partno` = '5923030820F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.040148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18907615 [ RunTime:0.017949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51242883 LIMIT 5 [ RunTime:0.031150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51242883 ORDER BY `minOrder` ASC [ RunTime:0.014123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51242883 ORDER BY `unit` DESC [ RunTime:0.009662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51242883 LIMIT 2 [ RunTime:0.020384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51242883 ORDER BY `minOrder` ASC [ RunTime:0.011178s ]
select * from pdf where partno='5923030835F' and brandshort='Dialight' limit 1 [ RunTime:0.036015s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923030835F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.028642s ]
SELECT `id` FROM `stock` WHERE `id` <> 51242883 AND `partno` = '5923030835F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.037890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15250445 [ RunTime:0.014411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51242882 LIMIT 5 [ RunTime:0.031643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51242882 ORDER BY `minOrder` ASC [ RunTime:0.016336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51242882 ORDER BY `unit` DESC [ RunTime:0.003902s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51242882 LIMIT 2 [ RunTime:0.014301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51242882 ORDER BY `minOrder` ASC [ RunTime:0.030225s ]
select * from pdf where partno='5923032313F' and brandshort='Dialight' limit 1 [ RunTime:0.032534s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923032313F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.043771s ]
SELECT `id` FROM `stock` WHERE `id` <> 51242882 AND `partno` = '5923032313F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.010338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18908791 [ RunTime:0.017825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51242662 LIMIT 5 [ RunTime:0.006182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51242662 ORDER BY `minOrder` ASC [ RunTime:0.005254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51242662 ORDER BY `unit` DESC [ RunTime:0.092197s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51242662 LIMIT 2 [ RunTime:0.015907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51242662 ORDER BY `minOrder` ASC [ RunTime:0.006743s ]
select * from pdf where partno='5923030313F' and brandshort='Dialight' limit 1 [ RunTime:0.021866s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5923030313F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.023853s ]
SELECT `id` FROM `stock` WHERE `id` <> 51242662 AND `partno` = '5923030313F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.016611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18909220 [ RunTime:0.011204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50615281 LIMIT 5 [ RunTime:0.046270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50615281 ORDER BY `minOrder` ASC [ RunTime:0.035989s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50615281 ORDER BY `unit` DESC [ RunTime:0.005772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50615281 LIMIT 2 [ RunTime:0.027271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50615281 ORDER BY `minOrder` ASC [ RunTime:0.018714s ]
select * from pdf where partno='592303' and brandshort='3M' limit 1 [ RunTime:0.013500s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '592303' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.026129s ]
SELECT `id` FROM `stock` WHERE `id` <> 50615281 AND `partno` = '592303' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.016270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18712095 [ RunTime:0.013786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37942485 LIMIT 5 [ RunTime:0.032025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37942485 ORDER BY `minOrder` ASC [ RunTime:0.008572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37942485 ORDER BY `unit` DESC [ RunTime:0.022852s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37942485 LIMIT 2 [ RunTime:0.043831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37942485 ORDER BY `minOrder` ASC [ RunTime:0.016793s ]
select * from pdf where partno='592303' and brandshort='3M' limit 1 [ RunTime:0.014679s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '592303' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.066341s ]
SELECT `id` FROM `stock` WHERE `id` <> 37942485 AND `partno` = '592303' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.021590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18712095 [ RunTime:0.019619s ]
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 '592303%' OR `brand` LIKE '592303%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025970s ]
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 '592303%' OR `brand` LIKE '592303%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016168s ]
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 '592303%' OR `brand` LIKE '592303%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003839s ]
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 '592303%' OR `brand` LIKE '592303%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005130s ]
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 '592303%' OR `brand` LIKE '592303%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006297s ]
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 '592303%' OR `brand` LIKE '592303%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005254s ]
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 '592303%' OR `brand` LIKE '592303%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003808s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '592303%' OR `brand` LIKE '592303%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.004357s ]