SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002806s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=PA4305&search=1' [ RunTime:0.014466s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001980s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.023922s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002033s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.025562s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.004035s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.020874s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002461s ]
SELECT * FROM `stock_search` WHERE `partno` = 'PA4305' LIMIT 1 [ RunTime:0.030923s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-24 03:14:37' WHERE `partno` = 'PA4305' [ RunTime:0.020128s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003549s ]
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 'PA4305%' OR `brand` LIKE 'PA4305%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.075901s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13415398 LIMIT 5 [ RunTime:0.049883s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13415398 ORDER BY `minOrder` ASC [ RunTime:0.005778s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13415398 ORDER BY `unit` DESC [ RunTime:0.014230s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13415398 LIMIT 2 [ RunTime:0.005719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13415398 ORDER BY `minOrder` ASC [ RunTime:0.019375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13418046 LIMIT 5 [ RunTime:0.022380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13418046 ORDER BY `minOrder` ASC [ RunTime:0.032442s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13418046 ORDER BY `unit` DESC [ RunTime:0.043467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13418046 LIMIT 2 [ RunTime:0.039132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13418046 ORDER BY `minOrder` ASC [ RunTime:0.006948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13418045 LIMIT 5 [ RunTime:0.022711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13418045 ORDER BY `minOrder` ASC [ RunTime:0.006841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13418045 ORDER BY `unit` DESC [ RunTime:0.019696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13418045 LIMIT 2 [ RunTime:0.008742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13418045 ORDER BY `minOrder` ASC [ RunTime:0.032568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14311701 LIMIT 5 [ RunTime:0.021230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14311701 ORDER BY `minOrder` ASC [ RunTime:0.014718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14311701 ORDER BY `unit` DESC [ RunTime:0.036833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14311701 LIMIT 2 [ RunTime:0.018924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14311701 ORDER BY `minOrder` ASC [ RunTime:0.008885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14311760 LIMIT 5 [ RunTime:0.067810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14311760 ORDER BY `minOrder` ASC [ RunTime:0.028179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14311760 ORDER BY `unit` DESC [ RunTime:0.012786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14311760 LIMIT 2 [ RunTime:0.016675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14311760 ORDER BY `minOrder` ASC [ RunTime:0.016591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14311761 LIMIT 5 [ RunTime:0.009251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14311761 ORDER BY `minOrder` ASC [ RunTime:0.017864s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14311761 ORDER BY `unit` DESC [ RunTime:0.039968s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14311761 LIMIT 2 [ RunTime:0.017117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14311761 ORDER BY `minOrder` ASC [ RunTime:0.002062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14311762 LIMIT 5 [ RunTime:0.007451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14311762 ORDER BY `minOrder` ASC [ RunTime:0.007424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14311762 ORDER BY `unit` DESC [ RunTime:0.017866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14311762 LIMIT 2 [ RunTime:0.004934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14311762 ORDER BY `minOrder` ASC [ RunTime:0.000670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13417926 LIMIT 5 [ RunTime:0.001239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13417926 ORDER BY `minOrder` ASC [ RunTime:0.003822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13417926 ORDER BY `unit` DESC [ RunTime:0.008061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13417926 LIMIT 2 [ RunTime:0.014879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13417926 ORDER BY `minOrder` ASC [ RunTime:0.004063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13417928 LIMIT 5 [ RunTime:0.005430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13417928 ORDER BY `minOrder` ASC [ RunTime:0.009215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13417928 ORDER BY `unit` DESC [ RunTime:0.011578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13417928 LIMIT 2 [ RunTime:0.000963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13417928 ORDER BY `minOrder` ASC [ RunTime:0.001253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13417929 LIMIT 5 [ RunTime:0.001986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13417929 ORDER BY `minOrder` ASC [ RunTime:0.003913s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13417929 ORDER BY `unit` DESC [ RunTime:0.000655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13417929 LIMIT 2 [ RunTime:0.000645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13417929 ORDER BY `minOrder` ASC [ RunTime:0.001947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16387583 LIMIT 5 [ RunTime:0.001023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16387583 ORDER BY `minOrder` ASC [ RunTime:0.006562s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16387583 ORDER BY `unit` DESC [ RunTime:0.012820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16387583 LIMIT 2 [ RunTime:0.014452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16387583 ORDER BY `minOrder` ASC [ RunTime:0.004473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16387582 LIMIT 5 [ RunTime:0.001722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16387582 ORDER BY `minOrder` ASC [ RunTime:0.000681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16387582 ORDER BY `unit` DESC [ RunTime:0.000609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16387582 LIMIT 2 [ RunTime:0.000599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16387582 ORDER BY `minOrder` ASC [ RunTime:0.002432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16387581 LIMIT 5 [ RunTime:0.000627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16387581 ORDER BY `minOrder` ASC [ RunTime:0.000746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16387581 ORDER BY `unit` DESC [ RunTime:0.014425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16387581 LIMIT 2 [ RunTime:0.014650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16387581 ORDER BY `minOrder` ASC [ RunTime:0.006546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16387580 LIMIT 5 [ RunTime:0.001336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16387580 ORDER BY `minOrder` ASC [ RunTime:0.000674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16387580 ORDER BY `unit` DESC [ RunTime:0.021908s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16387580 LIMIT 2 [ RunTime:0.002580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16387580 ORDER BY `minOrder` ASC [ RunTime:0.005639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14338016 LIMIT 5 [ RunTime:0.004599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14338016 ORDER BY `minOrder` ASC [ RunTime:0.022808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14338016 ORDER BY `unit` DESC [ RunTime:0.001760s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14338016 LIMIT 2 [ RunTime:0.006874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14338016 ORDER BY `minOrder` ASC [ RunTime:0.010652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14338015 LIMIT 5 [ RunTime:0.002003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14338015 ORDER BY `minOrder` ASC [ RunTime:0.000784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14338015 ORDER BY `unit` DESC [ RunTime:0.000649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14338015 LIMIT 2 [ RunTime:0.003184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14338015 ORDER BY `minOrder` ASC [ RunTime:0.003115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14338014 LIMIT 5 [ RunTime:0.002507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14338014 ORDER BY `minOrder` ASC [ RunTime:0.005763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14338014 ORDER BY `unit` DESC [ RunTime:0.000690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14338014 LIMIT 2 [ RunTime:0.020329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14338014 ORDER BY `minOrder` ASC [ RunTime:0.003778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14338013 LIMIT 5 [ RunTime:0.007444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14338013 ORDER BY `minOrder` ASC [ RunTime:0.012068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14338013 ORDER BY `unit` DESC [ RunTime:0.008480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14338013 LIMIT 2 [ RunTime:0.006784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14338013 ORDER BY `minOrder` ASC [ RunTime:0.011405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14338012 LIMIT 5 [ RunTime:0.020486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14338012 ORDER BY `minOrder` ASC [ RunTime:0.002915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14338012 ORDER BY `unit` DESC [ RunTime:0.008473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14338012 LIMIT 2 [ RunTime:0.011606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14338012 ORDER BY `minOrder` ASC [ RunTime:0.014936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14338011 LIMIT 5 [ RunTime:0.023039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14338011 ORDER BY `minOrder` ASC [ RunTime:0.013498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14338011 ORDER BY `unit` DESC [ RunTime:0.018662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14338011 LIMIT 2 [ RunTime:0.034079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14338011 ORDER BY `minOrder` ASC [ RunTime:0.014883s ]
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 'PA4305%' OR `brand` LIKE 'PA4305%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012614s ]
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 'PA4305%' OR `brand` LIKE 'PA4305%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40473195 LIMIT 5 [ RunTime:0.027047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40473195 ORDER BY `minOrder` ASC [ RunTime:0.025058s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40473195 ORDER BY `unit` DESC [ RunTime:0.016589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40473195 LIMIT 2 [ RunTime:0.008264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40473195 ORDER BY `minOrder` ASC [ RunTime:0.002446s ]
select * from pdf where partno='PA4305.682NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.016021s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002581s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PA4305.682NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.016528s ]
SELECT `id` FROM `stock` WHERE `id` <> 40473195 AND `partno` = 'PA4305.682NLT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.024032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13415398 [ RunTime:0.007040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40482535 LIMIT 5 [ RunTime:0.041566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40482535 ORDER BY `minOrder` ASC [ RunTime:0.016644s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40482535 ORDER BY `unit` DESC [ RunTime:0.008546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40482535 LIMIT 2 [ RunTime:0.036935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40482535 ORDER BY `minOrder` ASC [ RunTime:0.007018s ]
select * from pdf where partno='PA4305.104NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.004364s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PA4305.104NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.010671s ]
SELECT `id` FROM `stock` WHERE `id` <> 40482535 AND `partno` = 'PA4305.104NLT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.009917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13418045 [ RunTime:0.002622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40482536 LIMIT 5 [ RunTime:0.007696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40482536 ORDER BY `minOrder` ASC [ RunTime:0.038920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40482536 ORDER BY `unit` DESC [ RunTime:0.040374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40482536 LIMIT 2 [ RunTime:0.040456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40482536 ORDER BY `minOrder` ASC [ RunTime:0.040195s ]
select * from pdf where partno='PA4305.474NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.040910s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PA4305.474NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.048336s ]
SELECT `id` FROM `stock` WHERE `id` <> 40482536 AND `partno` = 'PA4305.474NLT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.078733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14311701 [ RunTime:0.082128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40482538 LIMIT 5 [ RunTime:0.066437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40482538 ORDER BY `minOrder` ASC [ RunTime:0.087513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40482538 ORDER BY `unit` DESC [ RunTime:0.048240s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40482538 LIMIT 2 [ RunTime:0.018941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40482538 ORDER BY `minOrder` ASC [ RunTime:0.036973s ]
select * from pdf where partno='PA4305.683NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.020630s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PA4305.683NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.023617s ]
SELECT `id` FROM `stock` WHERE `id` <> 40482538 AND `partno` = 'PA4305.683NLT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.055004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14311761 [ RunTime:0.055614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40482537 LIMIT 5 [ RunTime:0.058601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40482537 ORDER BY `minOrder` ASC [ RunTime:0.024379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40482537 ORDER BY `unit` DESC [ RunTime:0.020996s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40482537 LIMIT 2 [ RunTime:0.015442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40482537 ORDER BY `minOrder` ASC [ RunTime:0.000587s ]
select * from pdf where partno='PA4305.103NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.011925s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PA4305.103NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.016921s ]
SELECT `id` FROM `stock` WHERE `id` <> 40482537 AND `partno` = 'PA4305.103NLT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.011631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14311760 [ RunTime:0.014478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40482539 LIMIT 5 [ RunTime:0.080356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40482539 ORDER BY `minOrder` ASC [ RunTime:0.053515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40482539 ORDER BY `unit` DESC [ RunTime:0.045322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40482539 LIMIT 2 [ RunTime:0.038174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40482539 ORDER BY `minOrder` ASC [ RunTime:0.033772s ]
select * from pdf where partno='PA4305.332NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.069737s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PA4305.332NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.044437s ]
SELECT `id` FROM `stock` WHERE `id` <> 40482539 AND `partno` = 'PA4305.332NLT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.036791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13418046 [ RunTime:0.040209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40482540 LIMIT 5 [ RunTime:0.045770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40482540 ORDER BY `minOrder` ASC [ RunTime:0.002621s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40482540 ORDER BY `unit` DESC [ RunTime:0.024329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40482540 LIMIT 2 [ RunTime:0.058950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40482540 ORDER BY `minOrder` ASC [ RunTime:0.042425s ]
select * from pdf where partno='PA4305.102NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.018110s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PA4305.102NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.032885s ]
SELECT `id` FROM `stock` WHERE `id` <> 40482540 AND `partno` = 'PA4305.102NLT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.016361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13417926 [ RunTime:0.021334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40482541 LIMIT 5 [ RunTime:0.038218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40482541 ORDER BY `minOrder` ASC [ RunTime:0.043440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40482541 ORDER BY `unit` DESC [ RunTime:0.092948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40482541 LIMIT 2 [ RunTime:0.015091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40482541 ORDER BY `minOrder` ASC [ RunTime:0.003708s ]
select * from pdf where partno='PA4305.223NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.039073s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PA4305.223NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.086746s ]
SELECT `id` FROM `stock` WHERE `id` <> 40482541 AND `partno` = 'PA4305.223NLT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.065420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14311762 [ RunTime:0.067371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40482553 LIMIT 5 [ RunTime:0.041362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40482553 ORDER BY `minOrder` ASC [ RunTime:0.057186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40482553 ORDER BY `unit` DESC [ RunTime:0.028195s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40482553 LIMIT 2 [ RunTime:0.020247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40482553 ORDER BY `minOrder` ASC [ RunTime:0.007109s ]
select * from pdf where partno='PA4305.334NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.027909s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PA4305.334NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.034985s ]
SELECT `id` FROM `stock` WHERE `id` <> 40482553 AND `partno` = 'PA4305.334NLT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.013754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13417928 [ RunTime:0.047340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40482554 LIMIT 5 [ RunTime:0.053069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40482554 ORDER BY `minOrder` ASC [ RunTime:0.035562s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40482554 ORDER BY `unit` DESC [ RunTime:0.007923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40482554 LIMIT 2 [ RunTime:0.035807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40482554 ORDER BY `minOrder` ASC [ RunTime:0.033509s ]
select * from pdf where partno='PA4305.105NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.024125s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PA4305.105NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.074135s ]
SELECT `id` FROM `stock` WHERE `id` <> 40482554 AND `partno` = 'PA4305.105NLT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.060050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13417929 [ RunTime:0.057704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63531225 LIMIT 5 [ RunTime:0.030079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63531225 ORDER BY `minOrder` ASC [ RunTime:0.061281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63531225 ORDER BY `unit` DESC [ RunTime:0.032321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63531225 LIMIT 2 [ RunTime:0.055526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63531225 ORDER BY `minOrder` ASC [ RunTime:0.009940s ]
select * from pdf where partno='PA4305' and brandshort='Tempo Communications' limit 1 [ RunTime:0.041898s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PA4305' OR `brand` LIKE 'Tempo Communications%' ) ) LIMIT 1 [ RunTime:0.024184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40542863 LIMIT 5 [ RunTime:0.062430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40542863 ORDER BY `minOrder` ASC [ RunTime:0.044336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40542863 ORDER BY `unit` DESC [ RunTime:0.047923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40542863 LIMIT 2 [ RunTime:0.048572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40542863 ORDER BY `minOrder` ASC [ RunTime:0.012269s ]
select * from pdf where partno='PA4305.824NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.039228s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PA4305.824NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.026965s ]
SELECT `id` FROM `stock` WHERE `id` <> 40542863 AND `partno` = 'PA4305.824NLT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.023412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14338016 [ RunTime:0.009911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40542862 LIMIT 5 [ RunTime:0.005153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40542862 ORDER BY `minOrder` ASC [ RunTime:0.022929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40542862 ORDER BY `unit` DESC [ RunTime:0.003105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40542862 LIMIT 2 [ RunTime:0.026056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40542862 ORDER BY `minOrder` ASC [ RunTime:0.039415s ]
select * from pdf where partno='PA4305.823NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.049227s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PA4305.823NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.015430s ]
SELECT `id` FROM `stock` WHERE `id` <> 40542862 AND `partno` = 'PA4305.823NLT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.009243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14338015 [ RunTime:0.005226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40542861 LIMIT 5 [ RunTime:0.003955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40542861 ORDER BY `minOrder` ASC [ RunTime:0.023859s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40542861 ORDER BY `unit` DESC [ RunTime:0.041216s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40542861 LIMIT 2 [ RunTime:0.007127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40542861 ORDER BY `minOrder` ASC [ RunTime:0.009240s ]
select * from pdf where partno='PA4305.822NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.014216s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PA4305.822NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.022538s ]
SELECT `id` FROM `stock` WHERE `id` <> 40542861 AND `partno` = 'PA4305.822NLT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.002803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14338014 [ RunTime:0.008381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40542860 LIMIT 5 [ RunTime:0.032144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40542860 ORDER BY `minOrder` ASC [ RunTime:0.033351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40542860 ORDER BY `unit` DESC [ RunTime:0.006090s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40542860 LIMIT 2 [ RunTime:0.002085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40542860 ORDER BY `minOrder` ASC [ RunTime:0.002483s ]
select * from pdf where partno='PA4305.684NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.003325s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PA4305.684NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.013050s ]
SELECT `id` FROM `stock` WHERE `id` <> 40542860 AND `partno` = 'PA4305.684NLT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.020990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16387583 [ RunTime:0.011724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40542859 LIMIT 5 [ RunTime:0.009194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40542859 ORDER BY `minOrder` ASC [ RunTime:0.014260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40542859 ORDER BY `unit` DESC [ RunTime:0.011456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40542859 LIMIT 2 [ RunTime:0.001162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40542859 ORDER BY `minOrder` ASC [ RunTime:0.002164s ]
select * from pdf where partno='PA4305.564NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.014154s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PA4305.564NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.007565s ]
SELECT `id` FROM `stock` WHERE `id` <> 40542859 AND `partno` = 'PA4305.564NLT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.038497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16387582 [ RunTime:0.013301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40542858 LIMIT 5 [ RunTime:0.007275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40542858 ORDER BY `minOrder` ASC [ RunTime:0.013275s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40542858 ORDER BY `unit` DESC [ RunTime:0.017053s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40542858 LIMIT 2 [ RunTime:0.009471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40542858 ORDER BY `minOrder` ASC [ RunTime:0.011341s ]
select * from pdf where partno='PA4305.563NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.009164s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PA4305.563NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.001405s ]
SELECT `id` FROM `stock` WHERE `id` <> 40542858 AND `partno` = 'PA4305.563NLT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.014817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16387581 [ RunTime:0.006500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40542857 LIMIT 5 [ RunTime:0.009268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40542857 ORDER BY `minOrder` ASC [ RunTime:0.019803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40542857 ORDER BY `unit` DESC [ RunTime:0.020804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40542857 LIMIT 2 [ RunTime:0.013235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40542857 ORDER BY `minOrder` ASC [ RunTime:0.008381s ]
select * from pdf where partno='PA4305.562NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.002591s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PA4305.562NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.005381s ]
SELECT `id` FROM `stock` WHERE `id` <> 40542857 AND `partno` = 'PA4305.562NLT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.012696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14338013 [ RunTime:0.046257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40542856 LIMIT 5 [ RunTime:0.005229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40542856 ORDER BY `minOrder` ASC [ RunTime:0.016019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40542856 ORDER BY `unit` DESC [ RunTime:0.004289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40542856 LIMIT 2 [ RunTime:0.002616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40542856 ORDER BY `minOrder` ASC [ RunTime:0.009920s ]
select * from pdf where partno='PA4305.473NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.001844s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PA4305.473NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.017131s ]
SELECT `id` FROM `stock` WHERE `id` <> 40542856 AND `partno` = 'PA4305.473NLT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.036599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14338012 [ RunTime:0.002008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40542855 LIMIT 5 [ RunTime:0.016650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40542855 ORDER BY `minOrder` ASC [ RunTime:0.009411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40542855 ORDER BY `unit` DESC [ RunTime:0.011515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40542855 LIMIT 2 [ RunTime:0.013855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40542855 ORDER BY `minOrder` ASC [ RunTime:0.018115s ]
select * from pdf where partno='PA4305.472NLT' and brandshort='Pulse Electronics' limit 1 [ RunTime:0.005384s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PA4305.472NLT' OR `brand` LIKE 'Pulse Electronics%' ) ) LIMIT 1 [ RunTime:0.025130s ]
SELECT `id` FROM `stock` WHERE `id` <> 40542855 AND `partno` = 'PA4305.472NLT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.001223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13450794 [ RunTime:0.004534s ]
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 'PA4305%' OR `brand` LIKE 'PA4305%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010984s ]
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 'PA4305%' OR `brand` LIKE 'PA4305%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012719s ]
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 'PA4305%' OR `brand` LIKE 'PA4305%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006641s ]
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 'PA4305%' OR `brand` LIKE 'PA4305%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007070s ]
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 'PA4305%' OR `brand` LIKE 'PA4305%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024552s ]
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 'PA4305%' OR `brand` LIKE 'PA4305%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048234s ]
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 'PA4305%' OR `brand` LIKE 'PA4305%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026392s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'PA4305%' OR `brand` LIKE 'PA4305%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.012247s ]