SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 982510 LIMIT 1 [ RunTime:0.000887s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 982510 [ RunTime:0.006792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (275090,52178,490053,531252,860770,728761,100017,649236,376308,5105,475339,943760,685895,271415,265973,452717,578222,692112,304747,281907,8099,688941,409946,356863,861781,902557,382929,107035,794786,469984,845857,284435,963798,441937,1037365,764876,162561,90709,477468,783127,535765,563446,898551,65133,314592,12971,65546,809212,227689,991937,594032,453365,784490,28596,177913,191338,95648,870918,746995,540226) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 982510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 982510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000889s ]