SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 250015 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 250015 [ RunTime:0.002613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (262544,367382,666443,346646,25421,203001,739297,287265,282736,414871,183279,84557,1040867,68808,264310,177360,61422,305160,302016,176113,258419,642085,109884,121878,472193,756629,152937,36701,43552,768512,158467,43097,1002420,282608,924845,47381,502369,521274,971634,554099,435683,573746,22963,227795,315015,867669,595009,407620,198969,802927,430567,510684,865941,677061,790443,115975,610021,547459,960414,100308) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 250015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 250015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]