SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340083 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340083 [ RunTime:0.001942s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (763088,728962,538822,15815,553229,416075,923865,204609,937837,6459,485110,731696,627527,221492,586038,363053,31208,330260,98203,95738,1019734,976210,129105,967609,713308,98399,133654,351238,756722,283015,18969,376840,380839,549961,892830,664383,615749,691016,962927,668273,528480,154973,953851,910437,711817,522632,338318,1040044,361568,64052,830819,54250,882564,29505,67400,1004973,352727,381667,698741,833294) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001781s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001986s ]