SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002448s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596357 LIMIT 1 [ RunTime:0.001129s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596357 [ RunTime:0.004803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201595,391893,131763,91074,324067,841975,822196,901939,425676,654948,722318,576118,832920,866167,870377,409533,466054,108851,481512,1024459,1020448,767883,327678,552970,261213,927868,7347,839939,836722,670065,370509,889251,250686,524872,122096,490004,976158,438058,700807,131436,664959,325324,243889,957642,204774,816162,216455,61350,417444,941799,877483,685099,234237,596686,646426,379502,661884,297389,5094,234045) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596357 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596357 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]