SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 352222 LIMIT 1 [ RunTime:0.000277s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 352222 [ RunTime:0.001578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (341163,804972,845245,88198,304403,789288,406109,236085,295049,590818,835457,103504,744681,628419,946701,869168,130253,716213,604280,494332,737948,349653,250784,456153,651497,560247,380022,125897,397523,253185,1041219,421251,1023257,632179,927066,108924,575480,106475,424150,328711,18776,698835,107153,354930,1002553,385322,604258,220844,119014,501252,961237,274570,126610,857253,686462,347636,119584,85186,453297,128435) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 352222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 352222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000795s ]