SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001440s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.142' , `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=JXD63B300&search=1' [ RunTime:0.001844s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001285s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002053s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001623s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.142' ) [ RunTime:0.004407s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001375s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000318s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001352s ]
SELECT * FROM `stock_search` WHERE `partno` = 'JXD63B300' LIMIT 1 [ RunTime:0.002543s ]
UPDATE `stock_search` SET `count` = 6 , `updatetime` = '2026-08-02 04:30:15' WHERE `partno` = 'JXD63B300' [ RunTime:0.002534s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001602s ]
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 'JXD63B300%' OR `brand` LIKE 'JXD63B300%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004818s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14750715 LIMIT 5 [ RunTime:0.002440s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14750715 ORDER BY `minOrder` ASC [ RunTime:0.003589s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14750715 ORDER BY `unit` DESC [ RunTime:0.001204s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002236s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14750715 LIMIT 2 [ RunTime:0.012868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14750715 ORDER BY `minOrder` ASC [ RunTime:0.002912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14750705 LIMIT 5 [ RunTime:0.001164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14750705 ORDER BY `minOrder` ASC [ RunTime:0.010909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14750705 ORDER BY `unit` DESC [ RunTime:0.003127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14750705 LIMIT 2 [ RunTime:0.013060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14750705 ORDER BY `minOrder` ASC [ RunTime:0.017930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14750685 LIMIT 5 [ RunTime:0.012004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14750685 ORDER BY `minOrder` ASC [ RunTime:0.005038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14750685 ORDER BY `unit` DESC [ RunTime:0.023494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14750685 LIMIT 2 [ RunTime:0.029759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14750685 ORDER BY `minOrder` ASC [ RunTime:0.008644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14750681 LIMIT 5 [ RunTime:0.008896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14750681 ORDER BY `minOrder` ASC [ RunTime:0.022169s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14750681 ORDER BY `unit` DESC [ RunTime:0.015448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14750681 LIMIT 2 [ RunTime:0.012651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14750681 ORDER BY `minOrder` ASC [ RunTime:0.003397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14750652 LIMIT 5 [ RunTime:0.016548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14750652 ORDER BY `minOrder` ASC [ RunTime:0.036004s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14750652 ORDER BY `unit` DESC [ RunTime:0.011027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14750652 LIMIT 2 [ RunTime:0.002837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14750652 ORDER BY `minOrder` ASC [ RunTime:0.011491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14750650 LIMIT 5 [ RunTime:0.014431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14750650 ORDER BY `minOrder` ASC [ RunTime:0.017657s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14750650 ORDER BY `unit` DESC [ RunTime:0.012803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14750650 LIMIT 2 [ RunTime:0.011507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14750650 ORDER BY `minOrder` ASC [ RunTime:0.000858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14750566 LIMIT 5 [ RunTime:0.012640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14750566 ORDER BY `minOrder` ASC [ RunTime:0.046292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14750566 ORDER BY `unit` DESC [ RunTime:0.028920s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14750566 LIMIT 2 [ RunTime:0.072646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14750566 ORDER BY `minOrder` ASC [ RunTime:0.018832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14750548 LIMIT 5 [ RunTime:0.060309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14750548 ORDER BY `minOrder` ASC [ RunTime:0.042608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14750548 ORDER BY `unit` DESC [ RunTime:0.027114s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14750548 LIMIT 2 [ RunTime:0.007235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14750548 ORDER BY `minOrder` ASC [ RunTime:0.006763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14750398 LIMIT 5 [ RunTime:0.030972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14750398 ORDER BY `minOrder` ASC [ RunTime:0.025816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14750398 ORDER BY `unit` DESC [ RunTime:0.042356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14750398 LIMIT 2 [ RunTime:0.036493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14750398 ORDER BY `minOrder` ASC [ RunTime:0.036465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14750225 LIMIT 5 [ RunTime:0.042864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14750225 ORDER BY `minOrder` ASC [ RunTime:0.030442s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14750225 ORDER BY `unit` DESC [ RunTime:0.023066s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14750225 LIMIT 2 [ RunTime:0.056686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14750225 ORDER BY `minOrder` ASC [ RunTime:0.029067s ]
select * from pdf where partno='JXD63B300BP' and brandshort='Siemens' limit 1 [ RunTime:0.061953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13857168 LIMIT 5 [ RunTime:0.038025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13857168 ORDER BY `minOrder` ASC [ RunTime:0.011600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13857168 ORDER BY `unit` DESC [ RunTime:0.033899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13857168 LIMIT 2 [ RunTime:0.029884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13857168 ORDER BY `minOrder` ASC [ RunTime:0.015463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13857163 LIMIT 5 [ RunTime:0.040247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13857163 ORDER BY `minOrder` ASC [ RunTime:0.032068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13857163 ORDER BY `unit` DESC [ RunTime:0.045406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13857163 LIMIT 2 [ RunTime:0.019136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13857163 ORDER BY `minOrder` ASC [ RunTime:0.013911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13857161 LIMIT 5 [ RunTime:0.043873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13857161 ORDER BY `minOrder` ASC [ RunTime:0.097000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13857161 ORDER BY `unit` DESC [ RunTime:0.033190s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13857161 LIMIT 2 [ RunTime:0.050255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13857161 ORDER BY `minOrder` ASC [ RunTime:0.012635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13857138 LIMIT 5 [ RunTime:0.031679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13857138 ORDER BY `minOrder` ASC [ RunTime:0.026701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13857138 ORDER BY `unit` DESC [ RunTime:0.026192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13857138 LIMIT 2 [ RunTime:0.067733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13857138 ORDER BY `minOrder` ASC [ RunTime:0.023170s ]
select * from pdf where partno='JXD63B300HAFAFBF' and brandshort='Siemens' limit 1 [ RunTime:0.056880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13857117 LIMIT 5 [ RunTime:0.016576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13857117 ORDER BY `minOrder` ASC [ RunTime:0.050777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13857117 ORDER BY `unit` DESC [ RunTime:0.029591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13857117 LIMIT 2 [ RunTime:0.034957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13857117 ORDER BY `minOrder` ASC [ RunTime:0.012540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13857035 LIMIT 5 [ RunTime:0.042668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13857035 ORDER BY `minOrder` ASC [ RunTime:0.043170s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13857035 ORDER BY `unit` DESC [ RunTime:0.051068s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13857035 LIMIT 2 [ RunTime:0.005267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13857035 ORDER BY `minOrder` ASC [ RunTime:0.000407s ]
select * from pdf where partno='JXD63B300PSR' and brandshort='Siemens' limit 1 [ RunTime:0.016031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13856979 LIMIT 5 [ RunTime:0.028609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13856979 ORDER BY `minOrder` ASC [ RunTime:0.034145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13856979 ORDER BY `unit` DESC [ RunTime:0.020739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13856979 LIMIT 2 [ RunTime:0.013012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13856979 ORDER BY `minOrder` ASC [ RunTime:0.024153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13856947 LIMIT 5 [ RunTime:0.028050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13856947 ORDER BY `minOrder` ASC [ RunTime:0.042743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13856947 ORDER BY `unit` DESC [ RunTime:0.023856s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13856947 LIMIT 2 [ RunTime:0.033270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13856947 ORDER BY `minOrder` ASC [ RunTime:0.006289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13856883 LIMIT 5 [ RunTime:0.008231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13856883 ORDER BY `minOrder` ASC [ RunTime:0.037199s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13856883 ORDER BY `unit` DESC [ RunTime:0.023141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13856883 LIMIT 2 [ RunTime:0.012290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13856883 ORDER BY `minOrder` ASC [ RunTime:0.009566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13856857 LIMIT 5 [ RunTime:0.011931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13856857 ORDER BY `minOrder` ASC [ RunTime:0.049097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13856857 ORDER BY `unit` DESC [ RunTime:0.019953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13856857 LIMIT 2 [ RunTime:0.011103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13856857 ORDER BY `minOrder` ASC [ RunTime:0.011972s ]
select * from pdf where partno='JXD63B300P' and brandshort='Siemens' limit 1 [ RunTime:0.049768s ]
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 'JXD63B300%' OR `brand` LIKE 'JXD63B300%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020396s ]
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 'JXD63B300%' OR `brand` LIKE 'JXD63B300%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42081239 LIMIT 5 [ RunTime:0.026828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42081239 ORDER BY `minOrder` ASC [ RunTime:0.051313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42081239 ORDER BY `unit` DESC [ RunTime:0.044456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42081239 LIMIT 2 [ RunTime:0.016478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42081239 ORDER BY `minOrder` ASC [ RunTime:0.000675s ]
select * from pdf where partno='JXD63B300HAFSA' and brandshort='Siemens' limit 1 [ RunTime:0.011382s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002383s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JXD63B300HAFSA' OR `brand` LIKE 'Siemens%' ) ) LIMIT 1 [ RunTime:0.017698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42081232 LIMIT 5 [ RunTime:0.020942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42081232 ORDER BY `minOrder` ASC [ RunTime:0.039990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42081232 ORDER BY `unit` DESC [ RunTime:0.028399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42081232 LIMIT 2 [ RunTime:0.018194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42081232 ORDER BY `minOrder` ASC [ RunTime:0.034830s ]
select * from pdf where partno='JXD63B300HAESA' and brandshort='Siemens' limit 1 [ RunTime:0.028478s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JXD63B300HAESA' OR `brand` LIKE 'Siemens%' ) ) LIMIT 1 [ RunTime:0.039945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42081230 LIMIT 5 [ RunTime:0.034452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42081230 ORDER BY `minOrder` ASC [ RunTime:0.019777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42081230 ORDER BY `unit` DESC [ RunTime:0.029567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42081230 LIMIT 2 [ RunTime:0.025216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42081230 ORDER BY `minOrder` ASC [ RunTime:0.022529s ]
select * from pdf where partno='JXD63B300HAESB' and brandshort='Siemens' limit 1 [ RunTime:0.020510s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JXD63B300HAESB' OR `brand` LIKE 'Siemens%' ) ) LIMIT 1 [ RunTime:0.023158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42081188 LIMIT 5 [ RunTime:0.031750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42081188 ORDER BY `minOrder` ASC [ RunTime:0.036335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42081188 ORDER BY `unit` DESC [ RunTime:0.028344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42081188 LIMIT 2 [ RunTime:0.065958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42081188 ORDER BY `minOrder` ASC [ RunTime:0.011652s ]
select * from pdf where partno='JXD63B300HAFAFBF' and brandshort='Siemens' limit 1 [ RunTime:0.010043s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JXD63B300HAFAFBF' OR `brand` LIKE 'Siemens%' ) ) LIMIT 1 [ RunTime:0.066462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42081155 LIMIT 5 [ RunTime:0.039044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42081155 ORDER BY `minOrder` ASC [ RunTime:0.072805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42081155 ORDER BY `unit` DESC [ RunTime:0.039078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42081155 LIMIT 2 [ RunTime:0.030927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42081155 ORDER BY `minOrder` ASC [ RunTime:0.027468s ]
select * from pdf where partno='JXD63B300HP00S01' and brandshort='Siemens' limit 1 [ RunTime:0.011900s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JXD63B300HP00S01' OR `brand` LIKE 'Siemens%' ) ) LIMIT 1 [ RunTime:0.049574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42081043 LIMIT 5 [ RunTime:0.041648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42081043 ORDER BY `minOrder` ASC [ RunTime:0.041668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42081043 ORDER BY `unit` DESC [ RunTime:0.025368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42081043 LIMIT 2 [ RunTime:0.062901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42081043 ORDER BY `minOrder` ASC [ RunTime:0.018632s ]
select * from pdf where partno='JXD63B300L1S01' and brandshort='Siemens' limit 1 [ RunTime:0.028573s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JXD63B300L1S01' OR `brand` LIKE 'Siemens%' ) ) LIMIT 1 [ RunTime:0.056801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42081036 LIMIT 5 [ RunTime:0.012414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42081036 ORDER BY `minOrder` ASC [ RunTime:0.050949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42081036 ORDER BY `unit` DESC [ RunTime:0.029349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42081036 LIMIT 2 [ RunTime:0.007163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42081036 ORDER BY `minOrder` ASC [ RunTime:0.017216s ]
select * from pdf where partno='JXD63B300LAESB' and brandshort='Siemens' limit 1 [ RunTime:0.029708s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JXD63B300LAESB' OR `brand` LIKE 'Siemens%' ) ) LIMIT 1 [ RunTime:0.012866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42080998 LIMIT 5 [ RunTime:0.036637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42080998 ORDER BY `minOrder` ASC [ RunTime:0.038213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42080998 ORDER BY `unit` DESC [ RunTime:0.043342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42080998 LIMIT 2 [ RunTime:0.037375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42080998 ORDER BY `minOrder` ASC [ RunTime:0.037608s ]
select * from pdf where partno='JXD63B300P1S01' and brandshort='Siemens' limit 1 [ RunTime:0.020049s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JXD63B300P1S01' OR `brand` LIKE 'Siemens%' ) ) LIMIT 1 [ RunTime:0.031397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42080993 LIMIT 5 [ RunTime:0.032402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42080993 ORDER BY `minOrder` ASC [ RunTime:0.052104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42080993 ORDER BY `unit` DESC [ RunTime:0.042261s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42080993 LIMIT 2 [ RunTime:0.038964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42080993 ORDER BY `minOrder` ASC [ RunTime:0.019192s ]
select * from pdf where partno='JXD63B300ACSD' and brandshort='Siemens' limit 1 [ RunTime:0.036346s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JXD63B300ACSD' OR `brand` LIKE 'Siemens%' ) ) LIMIT 1 [ RunTime:0.061018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42080838 LIMIT 5 [ RunTime:0.049017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42080838 ORDER BY `minOrder` ASC [ RunTime:0.087292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42080838 ORDER BY `unit` DESC [ RunTime:0.039715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42080838 LIMIT 2 [ RunTime:0.032187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42080838 ORDER BY `minOrder` ASC [ RunTime:0.010781s ]
select * from pdf where partno='JXD63B300LSN' and brandshort='Siemens' limit 1 [ RunTime:0.022195s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JXD63B300LSN' OR `brand` LIKE 'Siemens%' ) ) LIMIT 1 [ RunTime:0.014425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42080836 LIMIT 5 [ RunTime:0.034935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42080836 ORDER BY `minOrder` ASC [ RunTime:0.012847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42080836 ORDER BY `unit` DESC [ RunTime:0.041077s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42080836 LIMIT 2 [ RunTime:0.017258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42080836 ORDER BY `minOrder` ASC [ RunTime:0.005215s ]
select * from pdf where partno='JXD63B300L00S01' and brandshort='Siemens' limit 1 [ RunTime:0.023405s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JXD63B300L00S01' OR `brand` LIKE 'Siemens%' ) ) LIMIT 1 [ RunTime:0.036057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42080791 LIMIT 5 [ RunTime:0.040065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42080791 ORDER BY `minOrder` ASC [ RunTime:0.035003s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42080791 ORDER BY `unit` DESC [ RunTime:0.018773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42080791 LIMIT 2 [ RunTime:0.023317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42080791 ORDER BY `minOrder` ASC [ RunTime:0.028307s ]
select * from pdf where partno='JXD63B300PSR' and brandshort='Siemens' limit 1 [ RunTime:0.004583s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JXD63B300PSR' OR `brand` LIKE 'Siemens%' ) ) LIMIT 1 [ RunTime:0.043360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42080394 LIMIT 5 [ RunTime:0.017235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42080394 ORDER BY `minOrder` ASC [ RunTime:0.047822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42080394 ORDER BY `unit` DESC [ RunTime:0.045886s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42080394 LIMIT 2 [ RunTime:0.056583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42080394 ORDER BY `minOrder` ASC [ RunTime:0.025574s ]
select * from pdf where partno='JXD63B300HP' and brandshort='Siemens' limit 1 [ RunTime:0.034568s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JXD63B300HP' OR `brand` LIKE 'Siemens%' ) ) LIMIT 1 [ RunTime:0.024686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42080375 LIMIT 5 [ RunTime:0.023456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42080375 ORDER BY `minOrder` ASC [ RunTime:0.030244s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42080375 ORDER BY `unit` DESC [ RunTime:0.085362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42080375 LIMIT 2 [ RunTime:0.072838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42080375 ORDER BY `minOrder` ASC [ RunTime:0.029463s ]
select * from pdf where partno='JXD63B300L1' and brandshort='Siemens' limit 1 [ RunTime:0.045845s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JXD63B300L1' OR `brand` LIKE 'Siemens%' ) ) LIMIT 1 [ RunTime:0.130001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42080230 LIMIT 5 [ RunTime:0.133704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42080230 ORDER BY `minOrder` ASC [ RunTime:0.091733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42080230 ORDER BY `unit` DESC [ RunTime:0.071939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42080230 LIMIT 2 [ RunTime:0.098951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42080230 ORDER BY `minOrder` ASC [ RunTime:0.044712s ]
select * from pdf where partno='JXD63B300H' and brandshort='Siemens' limit 1 [ RunTime:0.032274s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JXD63B300H' OR `brand` LIKE 'Siemens%' ) ) LIMIT 1 [ RunTime:0.025468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42080216 LIMIT 5 [ RunTime:0.024159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42080216 ORDER BY `minOrder` ASC [ RunTime:0.031332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42080216 ORDER BY `unit` DESC [ RunTime:0.025898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42080216 LIMIT 2 [ RunTime:0.044149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42080216 ORDER BY `minOrder` ASC [ RunTime:0.025903s ]
select * from pdf where partno='JXD63B300P1' and brandshort='Siemens' limit 1 [ RunTime:0.071302s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JXD63B300P1' OR `brand` LIKE 'Siemens%' ) ) LIMIT 1 [ RunTime:0.028779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42080012 LIMIT 5 [ RunTime:0.018928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42080012 ORDER BY `minOrder` ASC [ RunTime:0.022235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42080012 ORDER BY `unit` DESC [ RunTime:0.049085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42080012 LIMIT 2 [ RunTime:0.043920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42080012 ORDER BY `minOrder` ASC [ RunTime:0.032714s ]
select * from pdf where partno='JXD63B300L' and brandshort='Siemens' limit 1 [ RunTime:0.028716s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JXD63B300L' OR `brand` LIKE 'Siemens%' ) ) LIMIT 1 [ RunTime:0.037912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42079958 LIMIT 5 [ RunTime:0.023916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42079958 ORDER BY `minOrder` ASC [ RunTime:0.095516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42079958 ORDER BY `unit` DESC [ RunTime:0.020264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42079958 LIMIT 2 [ RunTime:0.052189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42079958 ORDER BY `minOrder` ASC [ RunTime:0.015679s ]
select * from pdf where partno='JXD63B300P' and brandshort='Siemens' limit 1 [ RunTime:0.000617s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JXD63B300P' OR `brand` LIKE 'Siemens%' ) ) LIMIT 1 [ RunTime:0.063988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42079800 LIMIT 5 [ RunTime:0.067836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42079800 ORDER BY `minOrder` ASC [ RunTime:0.024462s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42079800 ORDER BY `unit` DESC [ RunTime:0.032333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42079800 LIMIT 2 [ RunTime:0.050979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42079800 ORDER BY `minOrder` ASC [ RunTime:0.032989s ]
select * from pdf where partno='JXD63B300' and brandshort='Siemens' limit 1 [ RunTime:0.062726s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JXD63B300' OR `brand` LIKE 'Siemens%' ) ) LIMIT 1 [ RunTime:0.123952s ]
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 'JXD63B300%' OR `brand` LIKE 'JXD63B300%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.087572s ]
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 'JXD63B300%' OR `brand` LIKE 'JXD63B300%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.080653s ]
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 'JXD63B300%' OR `brand` LIKE 'JXD63B300%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.144782s ]
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 'JXD63B300%' OR `brand` LIKE 'JXD63B300%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023632s ]
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 'JXD63B300%' OR `brand` LIKE 'JXD63B300%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.058899s ]
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 'JXD63B300%' OR `brand` LIKE 'JXD63B300%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.071420s ]
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 'JXD63B300%' OR `brand` LIKE 'JXD63B300%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.104879s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'JXD63B300%' OR `brand` LIKE 'JXD63B300%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.020135s ]