SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031580 LIMIT 1 [ RunTime:0.001216s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031580 [ RunTime:0.001725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201138,422634,861844,503371,1028187,799102,524658,572015,324059,191994,657019,320622,998261,685497,887706,276685,337654,721008,665957,364490,218474,818054,409668,193759,132891,119883,233076,448427,611043,719776,850863,244471,776549,231186,664615,32338,348350,314351,1016513,941157,139708,220260,457949,570478,854817,450125,1000548,315847,963376,560381,957435,343529,235155,27526,286907,325698,353783,173118,106173,664184) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000867s ]