SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001601s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201159 LIMIT 1 [ RunTime:0.002619s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201159 [ RunTime:0.009264s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (724083,646850,268704,629285,317537,313139,102417,635061,168278,238103,364059,469378,732830,1036982,582527,686342,60510,136771,1029830,207910,740111,490969,1002687,583628,1021968,483401,864667,538765,810053,980509,524287,883109,984944,423919,366532,932111,827121,848391,145687,261903,923925,696690,461697,710800,290562,848593,30907,206472,95974,823188,398850,933022,64375,382782,55382,911251,175935,958839,277277,41549) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001635s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201159 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003639s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201159 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000720s ]