SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001504s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.153' , `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=BZW04-10&search=1' [ RunTime:0.001721s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001251s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001031s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002845s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.000416s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002683s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002490s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.006789s ]
SELECT * FROM `stock_search` WHERE `partno` = 'BZW04-10' LIMIT 1 [ RunTime:0.009168s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-16 03:44:45' WHERE `partno` = 'BZW04-10' [ RunTime:0.029411s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002539s ]
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 'BZW04-10%' OR `brand` LIKE 'BZW04-10%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.067543s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.008274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661566 LIMIT 5 [ RunTime:0.051106s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.015073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661566 ORDER BY `minOrder` ASC [ RunTime:0.037911s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16661566 ORDER BY `unit` DESC [ RunTime:0.011442s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16661566 LIMIT 2 [ RunTime:0.005208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661566 ORDER BY `minOrder` ASC [ RunTime:0.015782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670831 LIMIT 5 [ RunTime:0.007263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670831 ORDER BY `minOrder` ASC [ RunTime:0.023558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16670831 ORDER BY `unit` DESC [ RunTime:0.028905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16670831 LIMIT 2 [ RunTime:0.010372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670831 ORDER BY `minOrder` ASC [ RunTime:0.011467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670830 LIMIT 5 [ RunTime:0.025772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670830 ORDER BY `minOrder` ASC [ RunTime:0.016785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16670830 ORDER BY `unit` DESC [ RunTime:0.035363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16670830 LIMIT 2 [ RunTime:0.058792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670830 ORDER BY `minOrder` ASC [ RunTime:0.008868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670689 LIMIT 5 [ RunTime:0.002055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670689 ORDER BY `minOrder` ASC [ RunTime:0.032630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16670689 ORDER BY `unit` DESC [ RunTime:0.039105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16670689 LIMIT 2 [ RunTime:0.041275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670689 ORDER BY `minOrder` ASC [ RunTime:0.012072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668822 LIMIT 5 [ RunTime:0.032647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668822 ORDER BY `minOrder` ASC [ RunTime:0.040415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668822 ORDER BY `unit` DESC [ RunTime:0.031515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668822 LIMIT 2 [ RunTime:0.061236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668822 ORDER BY `minOrder` ASC [ RunTime:0.033466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668549 LIMIT 5 [ RunTime:0.059215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668549 ORDER BY `minOrder` ASC [ RunTime:0.025624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668549 ORDER BY `unit` DESC [ RunTime:0.023061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668549 LIMIT 2 [ RunTime:0.016462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668549 ORDER BY `minOrder` ASC [ RunTime:0.031295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668548 LIMIT 5 [ RunTime:0.024410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668548 ORDER BY `minOrder` ASC [ RunTime:0.031514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668548 ORDER BY `unit` DESC [ RunTime:0.004892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668548 LIMIT 2 [ RunTime:0.024553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668548 ORDER BY `minOrder` ASC [ RunTime:0.004057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668547 LIMIT 5 [ RunTime:0.013258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668547 ORDER BY `minOrder` ASC [ RunTime:0.015135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668547 ORDER BY `unit` DESC [ RunTime:0.022442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668547 LIMIT 2 [ RunTime:0.024187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668547 ORDER BY `minOrder` ASC [ RunTime:0.001163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668546 LIMIT 5 [ RunTime:0.009490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668546 ORDER BY `minOrder` ASC [ RunTime:0.006262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668546 ORDER BY `unit` DESC [ RunTime:0.019850s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668546 LIMIT 2 [ RunTime:0.016105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668546 ORDER BY `minOrder` ASC [ RunTime:0.013468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668537 LIMIT 5 [ RunTime:0.032957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668537 ORDER BY `minOrder` ASC [ RunTime:0.021408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668537 ORDER BY `unit` DESC [ RunTime:0.009026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668537 LIMIT 2 [ RunTime:0.004611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668537 ORDER BY `minOrder` ASC [ RunTime:0.006193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16667762 LIMIT 5 [ RunTime:0.004601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667762 ORDER BY `minOrder` ASC [ RunTime:0.005456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16667762 ORDER BY `unit` DESC [ RunTime:0.004369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16667762 LIMIT 2 [ RunTime:0.003738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667762 ORDER BY `minOrder` ASC [ RunTime:0.008552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16667755 LIMIT 5 [ RunTime:0.007893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667755 ORDER BY `minOrder` ASC [ RunTime:0.001055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16667755 ORDER BY `unit` DESC [ RunTime:0.004128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16667755 LIMIT 2 [ RunTime:0.003465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667755 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812433 LIMIT 5 [ RunTime:0.004148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14812433 ORDER BY `minOrder` ASC [ RunTime:0.002157s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14812433 ORDER BY `unit` DESC [ RunTime:0.003479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14812433 LIMIT 2 [ RunTime:0.009478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14812433 ORDER BY `minOrder` ASC [ RunTime:0.002357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812351 LIMIT 5 [ RunTime:0.003747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14812351 ORDER BY `minOrder` ASC [ RunTime:0.008100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14812351 ORDER BY `unit` DESC [ RunTime:0.014178s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14812351 LIMIT 2 [ RunTime:0.005019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14812351 ORDER BY `minOrder` ASC [ RunTime:0.002863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808752 LIMIT 5 [ RunTime:0.023065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808752 ORDER BY `minOrder` ASC [ RunTime:0.000829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14808752 ORDER BY `unit` DESC [ RunTime:0.003539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14808752 LIMIT 2 [ RunTime:0.009210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808752 ORDER BY `minOrder` ASC [ RunTime:0.001215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808157 LIMIT 5 [ RunTime:0.000990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808157 ORDER BY `minOrder` ASC [ RunTime:0.007946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14808157 ORDER BY `unit` DESC [ RunTime:0.000697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14808157 LIMIT 2 [ RunTime:0.004660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808157 ORDER BY `minOrder` ASC [ RunTime:0.001771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915307 LIMIT 5 [ RunTime:0.009974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915307 ORDER BY `minOrder` ASC [ RunTime:0.015318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13915307 ORDER BY `unit` DESC [ RunTime:0.011478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13915307 LIMIT 2 [ RunTime:0.000647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915307 ORDER BY `minOrder` ASC [ RunTime:0.004385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915004 LIMIT 5 [ RunTime:0.001011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915004 ORDER BY `minOrder` ASC [ RunTime:0.005522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13915004 ORDER BY `unit` DESC [ RunTime:0.006835s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13915004 LIMIT 2 [ RunTime:0.000655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915004 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914362 LIMIT 5 [ RunTime:0.005540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13914362 ORDER BY `minOrder` ASC [ RunTime:0.002090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13914362 ORDER BY `unit` DESC [ RunTime:0.010456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13914362 LIMIT 2 [ RunTime:0.009326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13914362 ORDER BY `minOrder` ASC [ RunTime:0.006730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13912271 LIMIT 5 [ RunTime:0.004758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13912271 ORDER BY `minOrder` ASC [ RunTime:0.003773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13912271 ORDER BY `unit` DESC [ RunTime:0.008697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13912271 LIMIT 2 [ RunTime:0.023544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13912271 ORDER BY `minOrder` ASC [ RunTime:0.002240s ]
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 'BZW04-10%' OR `brand` LIKE 'BZW04-10%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003942s ]
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 'BZW04-10%' OR `brand` LIKE 'BZW04-10%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42152601 LIMIT 5 [ RunTime:0.009272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42152601 ORDER BY `minOrder` ASC [ RunTime:0.023278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42152601 ORDER BY `unit` DESC [ RunTime:0.009841s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42152601 LIMIT 2 [ RunTime:0.020985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42152601 ORDER BY `minOrder` ASC [ RunTime:0.014820s ]
select * from pdf where partno='BZW04-10B' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.009589s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003334s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZW04-10B' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.022165s ]
SELECT `id` FROM `stock` WHERE `id` <> 42152601 AND `partno` = 'BZW04-10B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.027860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661566 [ RunTime:0.032476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42273753 LIMIT 5 [ RunTime:0.012554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42273753 ORDER BY `minOrder` ASC [ RunTime:0.022487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42273753 ORDER BY `unit` DESC [ RunTime:0.016619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42273753 LIMIT 2 [ RunTime:0.017295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42273753 ORDER BY `minOrder` ASC [ RunTime:0.030554s ]
select * from pdf where partno='BZW04-10BHE3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.023689s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZW04-10BHE3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.033462s ]
SELECT `id` FROM `stock` WHERE `id` <> 42273753 AND `partno` = 'BZW04-10BHE3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.062520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812433 [ RunTime:0.036724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42273735 LIMIT 5 [ RunTime:0.019789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42273735 ORDER BY `minOrder` ASC [ RunTime:0.037632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42273735 ORDER BY `unit` DESC [ RunTime:0.047990s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42273735 LIMIT 2 [ RunTime:0.047705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42273735 ORDER BY `minOrder` ASC [ RunTime:0.049584s ]
select * from pdf where partno='BZW04-10BHE3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.052999s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZW04-10BHE3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.046008s ]
SELECT `id` FROM `stock` WHERE `id` <> 42273735 AND `partno` = 'BZW04-10BHE3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.051432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42271437 LIMIT 5 [ RunTime:0.046062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42271437 ORDER BY `minOrder` ASC [ RunTime:0.044400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42271437 ORDER BY `unit` DESC [ RunTime:0.050731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42271437 LIMIT 2 [ RunTime:0.047682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42271437 ORDER BY `minOrder` ASC [ RunTime:0.035730s ]
select * from pdf where partno='BZW04-102B-E3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.045848s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZW04-102B-E3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.022480s ]
SELECT `id` FROM `stock` WHERE `id` <> 42271437 AND `partno` = 'BZW04-102B-E3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.026656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42269918 LIMIT 5 [ RunTime:0.011388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42269918 ORDER BY `minOrder` ASC [ RunTime:0.050073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42269918 ORDER BY `unit` DESC [ RunTime:0.018577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42269918 LIMIT 2 [ RunTime:0.024118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42269918 ORDER BY `minOrder` ASC [ RunTime:0.023067s ]
select * from pdf where partno='BZW04-10HE3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.028411s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZW04-10HE3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.098421s ]
SELECT `id` FROM `stock` WHERE `id` <> 42269918 AND `partno` = 'BZW04-10HE3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.042943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915307 [ RunTime:0.065364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42269869 LIMIT 5 [ RunTime:0.013694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42269869 ORDER BY `minOrder` ASC [ RunTime:0.045926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42269869 ORDER BY `unit` DESC [ RunTime:0.046659s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42269869 LIMIT 2 [ RunTime:0.032651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42269869 ORDER BY `minOrder` ASC [ RunTime:0.012385s ]
select * from pdf where partno='BZW04-10HE3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.026483s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZW04-10HE3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.030236s ]
SELECT `id` FROM `stock` WHERE `id` <> 42269869 AND `partno` = 'BZW04-10HE3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.033070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42269868 LIMIT 5 [ RunTime:0.042300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42269868 ORDER BY `minOrder` ASC [ RunTime:0.014583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42269868 ORDER BY `unit` DESC [ RunTime:0.026909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42269868 LIMIT 2 [ RunTime:0.018669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42269868 ORDER BY `minOrder` ASC [ RunTime:0.002006s ]
select * from pdf where partno='BZW04-102HE3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.017228s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZW04-102HE3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.030585s ]
SELECT `id` FROM `stock` WHERE `id` <> 42269868 AND `partno` = 'BZW04-102HE3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.006442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42267679 LIMIT 5 [ RunTime:0.000593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42267679 ORDER BY `minOrder` ASC [ RunTime:0.004570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42267679 ORDER BY `unit` DESC [ RunTime:0.004527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42267679 LIMIT 2 [ RunTime:0.010538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42267679 ORDER BY `minOrder` ASC [ RunTime:0.020547s ]
select * from pdf where partno='BZW04-10B-E3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.012482s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZW04-10B-E3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.003690s ]
SELECT `id` FROM `stock` WHERE `id` <> 42267679 AND `partno` = 'BZW04-10B-E3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.015432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42264413 LIMIT 5 [ RunTime:0.002494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42264413 ORDER BY `minOrder` ASC [ RunTime:0.009467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42264413 ORDER BY `unit` DESC [ RunTime:0.006759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42264413 LIMIT 2 [ RunTime:0.005779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42264413 ORDER BY `minOrder` ASC [ RunTime:0.018040s ]
select * from pdf where partno='BZW04-102-E3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.017898s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZW04-102-E3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.026391s ]
SELECT `id` FROM `stock` WHERE `id` <> 42264413 AND `partno` = 'BZW04-102-E3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.004481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42263404 LIMIT 5 [ RunTime:0.007055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42263404 ORDER BY `minOrder` ASC [ RunTime:0.002264s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42263404 ORDER BY `unit` DESC [ RunTime:0.011999s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42263404 LIMIT 2 [ RunTime:0.000663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42263404 ORDER BY `minOrder` ASC [ RunTime:0.005747s ]
select * from pdf where partno='BZW04-102HE3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.016005s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZW04-102HE3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.015629s ]
SELECT `id` FROM `stock` WHERE `id` <> 42263404 AND `partno` = 'BZW04-102HE3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.014400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812351 [ RunTime:0.038959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42262953 LIMIT 5 [ RunTime:0.009268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262953 ORDER BY `minOrder` ASC [ RunTime:0.016096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42262953 ORDER BY `unit` DESC [ RunTime:0.022003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42262953 LIMIT 2 [ RunTime:0.023085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262953 ORDER BY `minOrder` ASC [ RunTime:0.024594s ]
select * from pdf where partno='BZW04-102B-E3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.046552s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZW04-102B-E3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.024864s ]
SELECT `id` FROM `stock` WHERE `id` <> 42262953 AND `partno` = 'BZW04-102B-E3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.037306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670689 [ RunTime:0.002896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42262219 LIMIT 5 [ RunTime:0.002286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262219 ORDER BY `minOrder` ASC [ RunTime:0.008101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42262219 ORDER BY `unit` DESC [ RunTime:0.033510s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42262219 LIMIT 2 [ RunTime:0.015294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262219 ORDER BY `minOrder` ASC [ RunTime:0.003350s ]
select * from pdf where partno='BZW04-10-E3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.038186s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZW04-10-E3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.034153s ]
SELECT `id` FROM `stock` WHERE `id` <> 42262219 AND `partno` = 'BZW04-10-E3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.043412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42261023 LIMIT 5 [ RunTime:0.012085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42261023 ORDER BY `minOrder` ASC [ RunTime:0.005394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42261023 ORDER BY `unit` DESC [ RunTime:0.043752s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42261023 LIMIT 2 [ RunTime:0.033166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42261023 ORDER BY `minOrder` ASC [ RunTime:0.010456s ]
select * from pdf where partno='BZW04-10B-E3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.011551s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZW04-10B-E3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.012946s ]
SELECT `id` FROM `stock` WHERE `id` <> 42261023 AND `partno` = 'BZW04-10B-E3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.045249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915004 [ RunTime:0.023487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42254440 LIMIT 5 [ RunTime:0.030163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42254440 ORDER BY `minOrder` ASC [ RunTime:0.056740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42254440 ORDER BY `unit` DESC [ RunTime:0.030458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42254440 LIMIT 2 [ RunTime:0.054971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42254440 ORDER BY `minOrder` ASC [ RunTime:0.002135s ]
select * from pdf where partno='BZW04-102-E3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.029569s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZW04-102-E3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.009685s ]
SELECT `id` FROM `stock` WHERE `id` <> 42254440 AND `partno` = 'BZW04-102-E3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.031643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670831 [ RunTime:0.017802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42245112 LIMIT 5 [ RunTime:0.058223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245112 ORDER BY `minOrder` ASC [ RunTime:0.040806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42245112 ORDER BY `unit` DESC [ RunTime:0.062567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42245112 LIMIT 2 [ RunTime:0.057630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245112 ORDER BY `minOrder` ASC [ RunTime:0.000623s ]
select * from pdf where partno='BZW04-10-E3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.022791s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZW04-10-E3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.024372s ]
SELECT `id` FROM `stock` WHERE `id` <> 42245112 AND `partno` = 'BZW04-10-E3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.039267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670830 [ RunTime:0.026625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42228131 LIMIT 5 [ RunTime:0.002988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42228131 ORDER BY `minOrder` ASC [ RunTime:0.044628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42228131 ORDER BY `unit` DESC [ RunTime:0.020181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42228131 LIMIT 2 [ RunTime:0.025157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42228131 ORDER BY `minOrder` ASC [ RunTime:0.009472s ]
select * from pdf where partno='BZW04-10' and brandshort='STMicroelectronics' limit 1 [ RunTime:0.048520s ]
select foldpath,foldpath2,filename from pdf_file where id=505234 limit 1 [ RunTime:0.043618s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZW04-10' OR `brand` LIKE 'STMicroelectronics%' ) ) LIMIT 1 [ RunTime:0.015292s ]
SELECT `id` FROM `stock` WHERE `id` <> 42228131 AND `partno` = 'BZW04-10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.032905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914362 [ RunTime:0.049110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42211000 LIMIT 5 [ RunTime:0.047282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42211000 ORDER BY `minOrder` ASC [ RunTime:0.042504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42211000 ORDER BY `unit` DESC [ RunTime:0.045060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42211000 LIMIT 2 [ RunTime:0.017164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42211000 ORDER BY `minOrder` ASC [ RunTime:0.013089s ]
select * from pdf where partno='BZW04-10H' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.088038s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZW04-10H' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.035918s ]
SELECT `id` FROM `stock` WHERE `id` <> 42211000 AND `partno` = 'BZW04-10H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.067923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668822 [ RunTime:0.013942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42210999 LIMIT 5 [ RunTime:0.048557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42210999 ORDER BY `minOrder` ASC [ RunTime:0.021501s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42210999 ORDER BY `unit` DESC [ RunTime:0.024706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42210999 LIMIT 2 [ RunTime:0.035180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42210999 ORDER BY `minOrder` ASC [ RunTime:0.039370s ]
select * from pdf where partno='BZW04-102H' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.026877s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZW04-102H' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.021771s ]
SELECT `id` FROM `stock` WHERE `id` <> 42210999 AND `partno` = 'BZW04-102H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.025896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13912271 [ RunTime:0.041796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42210998 LIMIT 5 [ RunTime:0.021904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42210998 ORDER BY `minOrder` ASC [ RunTime:0.025160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42210998 ORDER BY `unit` DESC [ RunTime:0.029988s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42210998 LIMIT 2 [ RunTime:0.032747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42210998 ORDER BY `minOrder` ASC [ RunTime:0.013974s ]
select * from pdf where partno='BZW04-102' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.021921s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZW04-102' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.017807s ]
SELECT `id` FROM `stock` WHERE `id` <> 42210998 AND `partno` = 'BZW04-102' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.005158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808752 [ RunTime:0.020818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42209462 LIMIT 5 [ RunTime:0.016626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42209462 ORDER BY `minOrder` ASC [ RunTime:0.014496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42209462 ORDER BY `unit` DESC [ RunTime:0.006867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42209462 LIMIT 2 [ RunTime:0.008124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42209462 ORDER BY `minOrder` ASC [ RunTime:0.001655s ]
select * from pdf where partno='BZW04-10BH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.009522s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZW04-10BH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.012713s ]
SELECT `id` FROM `stock` WHERE `id` <> 42209462 AND `partno` = 'BZW04-10BH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.015144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668549 [ RunTime:0.003578s ]
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 'BZW04-10%' OR `brand` LIKE 'BZW04-10%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006473s ]
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 'BZW04-10%' OR `brand` LIKE 'BZW04-10%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003345s ]
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 'BZW04-10%' OR `brand` LIKE 'BZW04-10%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007466s ]
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 'BZW04-10%' OR `brand` LIKE 'BZW04-10%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007767s ]
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 'BZW04-10%' OR `brand` LIKE 'BZW04-10%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005595s ]
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 'BZW04-10%' OR `brand` LIKE 'BZW04-10%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002850s ]
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 'BZW04-10%' OR `brand` LIKE 'BZW04-10%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008763s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'BZW04-10%' OR `brand` LIKE 'BZW04-10%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.022112s ]