SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4994 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4994 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (805478,529885,231592,928983,506320,154522,118890,1028861,460511,348073,660528,54316,1020672,507296,906707,212982,659820,11048,109680,537351,946510,269383,543170,162222,624736,112715,591837,168671,84378,712862,792391,551555,867443,658355,20147,167778,506565,77182,511594,324785,510240,549400,668870,888170,871238,493829,41002,777109,724206,731814,650076,8706,928198,951122,937201,123656,586477,138362,461842,1017721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4994 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4994 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]