SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 586694 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586694 [ RunTime:0.002997s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (76909,567879,905454,86641,509550,660599,240718,45907,778806,682153,586386,773626,148524,97957,852182,539391,545061,142281,448501,500303,499512,67393,36101,38466,805946,489014,582059,883025,403411,474001,432553,615184,928134,128670,226338,678863,995533,945731,1043624,40510,414409,698351,648755,1010734,674141,237555,972650,541746,93903,347311,88774,964702,217356,824819,111194,464155,898427,786732,602940,473457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000680s ]