SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002334s ]
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=6A24-P20&search=1' [ RunTime:0.014503s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001418s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.016099s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001650s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.028859s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001345s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.015576s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001241s ]
SELECT * FROM `stock_search` WHERE `partno` = '6A24-P20' LIMIT 1 [ RunTime:0.044638s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-26 08:25:52' WHERE `partno` = '6A24-P20' [ RunTime:0.044831s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003273s ]
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 '6A24-P20%' OR `brand` LIKE '6A24-P20%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.101745s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.024606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14757048 LIMIT 5 [ RunTime:0.080903s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14757048 ORDER BY `minOrder` ASC [ RunTime:0.107019s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14757048 ORDER BY `unit` DESC [ RunTime:0.024081s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14757048 LIMIT 2 [ RunTime:0.077276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14757048 ORDER BY `minOrder` ASC [ RunTime:0.085955s ]
select * from pdf where partno='6A24-P20-I5-F-M' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.061761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13864184 LIMIT 5 [ RunTime:0.166322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13864184 ORDER BY `minOrder` ASC [ RunTime:0.194793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13864184 ORDER BY `unit` DESC [ RunTime:0.114864s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13864184 LIMIT 2 [ RunTime:0.050827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13864184 ORDER BY `minOrder` ASC [ RunTime:0.000464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16650782 LIMIT 5 [ RunTime:0.175438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650782 ORDER BY `minOrder` ASC [ RunTime:0.117073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16650782 ORDER BY `unit` DESC [ RunTime:0.230480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16650782 LIMIT 2 [ RunTime:0.098386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650782 ORDER BY `minOrder` ASC [ RunTime:0.084291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16650753 LIMIT 5 [ RunTime:0.108139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650753 ORDER BY `minOrder` ASC [ RunTime:0.064728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16650753 ORDER BY `unit` DESC [ RunTime:0.078351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16650753 LIMIT 2 [ RunTime:0.083159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650753 ORDER BY `minOrder` ASC [ RunTime:0.069364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16650752 LIMIT 5 [ RunTime:0.032978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650752 ORDER BY `minOrder` ASC [ RunTime:0.016865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16650752 ORDER BY `unit` DESC [ RunTime:0.105174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16650752 LIMIT 2 [ RunTime:0.048406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650752 ORDER BY `minOrder` ASC [ RunTime:0.063984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16650680 LIMIT 5 [ RunTime:0.043353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650680 ORDER BY `minOrder` ASC [ RunTime:0.038097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16650680 ORDER BY `unit` DESC [ RunTime:0.072951s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16650680 LIMIT 2 [ RunTime:0.035505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650680 ORDER BY `minOrder` ASC [ RunTime:0.022996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16650412 LIMIT 5 [ RunTime:0.024333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650412 ORDER BY `minOrder` ASC [ RunTime:0.032430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16650412 ORDER BY `unit` DESC [ RunTime:0.069242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16650412 LIMIT 2 [ RunTime:0.038144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650412 ORDER BY `minOrder` ASC [ RunTime:0.012115s ]
select * from pdf where partno='6A24-P20-25PPM-M-C' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.014727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16650358 LIMIT 5 [ RunTime:0.067055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650358 ORDER BY `minOrder` ASC [ RunTime:0.036559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16650358 ORDER BY `unit` DESC [ RunTime:0.048642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16650358 LIMIT 2 [ RunTime:0.030941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650358 ORDER BY `minOrder` ASC [ RunTime:0.012506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16650356 LIMIT 5 [ RunTime:0.018013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650356 ORDER BY `minOrder` ASC [ RunTime:0.014485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16650356 ORDER BY `unit` DESC [ RunTime:0.077154s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16650356 LIMIT 2 [ RunTime:0.056054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650356 ORDER BY `minOrder` ASC [ RunTime:0.029556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16650310 LIMIT 5 [ RunTime:0.015350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650310 ORDER BY `minOrder` ASC [ RunTime:0.122888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16650310 ORDER BY `unit` DESC [ RunTime:0.022511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16650310 LIMIT 2 [ RunTime:0.065290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650310 ORDER BY `minOrder` ASC [ RunTime:0.005442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16650276 LIMIT 5 [ RunTime:0.029468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650276 ORDER BY `minOrder` ASC [ RunTime:0.028940s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16650276 ORDER BY `unit` DESC [ RunTime:0.076906s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16650276 LIMIT 2 [ RunTime:0.014425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650276 ORDER BY `minOrder` ASC [ RunTime:0.003227s ]
select * from pdf where partno='6A24-P20-I5-25PPM-M-E' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.014893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16650275 LIMIT 5 [ RunTime:0.019628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650275 ORDER BY `minOrder` ASC [ RunTime:0.043017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16650275 ORDER BY `unit` DESC [ RunTime:0.087736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16650275 LIMIT 2 [ RunTime:0.068105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650275 ORDER BY `minOrder` ASC [ RunTime:0.029125s ]
select * from pdf where partno='6A24-P20-I10-25PPM-M-E' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.027052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16650239 LIMIT 5 [ RunTime:0.044694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650239 ORDER BY `minOrder` ASC [ RunTime:0.027075s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16650239 ORDER BY `unit` DESC [ RunTime:0.017562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16650239 LIMIT 2 [ RunTime:0.045031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650239 ORDER BY `minOrder` ASC [ RunTime:0.013567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16650190 LIMIT 5 [ RunTime:0.029242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650190 ORDER BY `minOrder` ASC [ RunTime:0.052646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16650190 ORDER BY `unit` DESC [ RunTime:0.024701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16650190 LIMIT 2 [ RunTime:0.034520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650190 ORDER BY `minOrder` ASC [ RunTime:0.033938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16650184 LIMIT 5 [ RunTime:0.022833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650184 ORDER BY `minOrder` ASC [ RunTime:0.004336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16650184 ORDER BY `unit` DESC [ RunTime:0.030926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16650184 LIMIT 2 [ RunTime:0.069312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650184 ORDER BY `minOrder` ASC [ RunTime:0.027126s ]
select * from pdf where partno='6A24-P20-I5-25PPM-F' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.049409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16650150 LIMIT 5 [ RunTime:0.009902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650150 ORDER BY `minOrder` ASC [ RunTime:0.056776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16650150 ORDER BY `unit` DESC [ RunTime:0.051352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16650150 LIMIT 2 [ RunTime:0.084044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650150 ORDER BY `minOrder` ASC [ RunTime:0.059170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16650088 LIMIT 5 [ RunTime:0.042155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650088 ORDER BY `minOrder` ASC [ RunTime:0.035005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16650088 ORDER BY `unit` DESC [ RunTime:0.102921s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16650088 LIMIT 2 [ RunTime:0.030386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16650088 ORDER BY `minOrder` ASC [ RunTime:0.014186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16649960 LIMIT 5 [ RunTime:0.042445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16649960 ORDER BY `minOrder` ASC [ RunTime:0.032198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16649960 ORDER BY `unit` DESC [ RunTime:0.030355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16649960 LIMIT 2 [ RunTime:0.025033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16649960 ORDER BY `minOrder` ASC [ RunTime:0.018753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16649947 LIMIT 5 [ RunTime:0.036668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16649947 ORDER BY `minOrder` ASC [ RunTime:0.009714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16649947 ORDER BY `unit` DESC [ RunTime:0.063326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16649947 LIMIT 2 [ RunTime:0.026817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16649947 ORDER BY `minOrder` ASC [ RunTime:0.018757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16649908 LIMIT 5 [ RunTime:0.026382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16649908 ORDER BY `minOrder` ASC [ RunTime:0.018576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16649908 ORDER BY `unit` DESC [ RunTime:0.015243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16649908 LIMIT 2 [ RunTime:0.065230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16649908 ORDER BY `minOrder` ASC [ RunTime:0.004927s ]
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 '6A24-P20%' OR `brand` LIKE '6A24-P20%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017485s ]
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 '6A24-P20%' OR `brand` LIKE '6A24-P20%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64307354 LIMIT 5 [ RunTime:0.006919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64307354 ORDER BY `minOrder` ASC [ RunTime:0.038598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64307354 ORDER BY `unit` DESC [ RunTime:0.012560s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64307354 LIMIT 2 [ RunTime:0.011789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64307354 ORDER BY `minOrder` ASC [ RunTime:0.004597s ]
select * from pdf where partno='6A24-P20-I5-F-M' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.007502s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002305s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6A24-P20-I5-F-M' OR `brand` LIKE 'ULTRAVOLT / Advanced Energy%' ) ) LIMIT 1 [ RunTime:0.026718s ]
SELECT `id` FROM `stock` WHERE `id` <> 64307354 AND `partno` = '6A24-P20-I5-F-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ultravolt / advanced energy%' ) [ RunTime:0.007871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14757048 [ RunTime:0.027280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64370707 LIMIT 5 [ RunTime:0.020238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64370707 ORDER BY `minOrder` ASC [ RunTime:0.021112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64370707 ORDER BY `unit` DESC [ RunTime:0.002840s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64370707 LIMIT 2 [ RunTime:0.031482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64370707 ORDER BY `minOrder` ASC [ RunTime:0.043056s ]
select * from pdf where partno='6A24-P20-I10-F' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.021936s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6A24-P20-I10-F' OR `brand` LIKE 'ULTRAVOLT / Advanced Energy%' ) ) LIMIT 1 [ RunTime:0.018774s ]
SELECT `id` FROM `stock` WHERE `id` <> 64370707 AND `partno` = '6A24-P20-I10-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ultravolt / advanced energy%' ) [ RunTime:0.047522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13864184 [ RunTime:0.034650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64371120 LIMIT 5 [ RunTime:0.027895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64371120 ORDER BY `minOrder` ASC [ RunTime:0.019277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64371120 ORDER BY `unit` DESC [ RunTime:0.028127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64371120 LIMIT 2 [ RunTime:0.039630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64371120 ORDER BY `minOrder` ASC [ RunTime:0.052814s ]
select * from pdf where partno='6A24-P20-C' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.040084s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6A24-P20-C' OR `brand` LIKE 'ULTRAVOLT / Advanced Energy%' ) ) LIMIT 1 [ RunTime:0.034732s ]
SELECT `id` FROM `stock` WHERE `id` <> 64371120 AND `partno` = '6A24-P20-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ultravolt / advanced energy%' ) [ RunTime:0.069174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16649619 [ RunTime:0.052398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64370742 LIMIT 5 [ RunTime:0.062514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64370742 ORDER BY `minOrder` ASC [ RunTime:0.043446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64370742 ORDER BY `unit` DESC [ RunTime:0.020212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64370742 LIMIT 2 [ RunTime:0.009327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64370742 ORDER BY `minOrder` ASC [ RunTime:0.021193s ]
select * from pdf where partno='6A24-P20-I5' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.040091s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6A24-P20-I5' OR `brand` LIKE 'ULTRAVOLT / Advanced Energy%' ) ) LIMIT 1 [ RunTime:0.040285s ]
SELECT `id` FROM `stock` WHERE `id` <> 64370742 AND `partno` = '6A24-P20-I5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ultravolt / advanced energy%' ) [ RunTime:0.018507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14787149 [ RunTime:0.025545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64370741 LIMIT 5 [ RunTime:0.032463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64370741 ORDER BY `minOrder` ASC [ RunTime:0.042902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64370741 ORDER BY `unit` DESC [ RunTime:0.006430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64370741 LIMIT 2 [ RunTime:0.034122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64370741 ORDER BY `minOrder` ASC [ RunTime:0.029640s ]
select * from pdf where partno='6A24-P20-I10' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.039570s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6A24-P20-I10' OR `brand` LIKE 'ULTRAVOLT / Advanced Energy%' ) ) LIMIT 1 [ RunTime:0.015603s ]
SELECT `id` FROM `stock` WHERE `id` <> 64370741 AND `partno` = '6A24-P20-I10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ultravolt / advanced energy%' ) [ RunTime:0.026566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13892825 [ RunTime:0.037177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64370500 LIMIT 5 [ RunTime:0.047166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64370500 ORDER BY `minOrder` ASC [ RunTime:0.068854s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64370500 ORDER BY `unit` DESC [ RunTime:0.041709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64370500 LIMIT 2 [ RunTime:0.075966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64370500 ORDER BY `minOrder` ASC [ RunTime:0.007251s ]
select * from pdf where partno='6A24-P20' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.039010s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6A24-P20' OR `brand` LIKE 'ULTRAVOLT / Advanced Energy%' ) ) LIMIT 1 [ RunTime:0.042909s ]
SELECT `id` FROM `stock` WHERE `id` <> 64370500 AND `partno` = '6A24-P20' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ultravolt / advanced energy%' ) [ RunTime:0.095825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14786820 [ RunTime:0.033966s ]
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 '6A24-P20%' OR `brand` LIKE '6A24-P20%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028485s ]
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 '6A24-P20%' OR `brand` LIKE '6A24-P20%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040951s ]
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 '6A24-P20%' OR `brand` LIKE '6A24-P20%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028605s ]
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 '6A24-P20%' OR `brand` LIKE '6A24-P20%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037222s ]
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 '6A24-P20%' OR `brand` LIKE '6A24-P20%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035513s ]
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 '6A24-P20%' OR `brand` LIKE '6A24-P20%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036047s ]
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 '6A24-P20%' OR `brand` LIKE '6A24-P20%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033820s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '6A24-P20%' OR `brand` LIKE '6A24-P20%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.017712s ]