SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 835591 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 835591 [ RunTime:0.001546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030987,151751,500082,577993,936754,500079,715105,533167,355238,1008656,461783,346476,148389,1001831,347811,540577,314722,509300,797685,859061,186575,872422,708052,557479,243024,516232,324105,227086,524047,705073,1039351,432978,245036,793208,1006031,290186,931120,331604,343716,609137,319623,1037856,933645,472424,558397,924142,756002,861802,425762,737837,143640,622704,158039,352124,1042880,567426,960653,407505,31662,14672) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 835591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 835591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]