SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50764 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50764 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (665138,1021785,798661,407709,1039228,630507,418910,172035,314638,373454,153032,532237,196312,272099,532730,46765,958335,838512,368119,1033212,50245,852266,135844,245757,765320,114393,171738,970582,712166,670255,827850,99270,490055,244509,902485,158020,633713,863386,742036,87188,563407,475454,479525,56826,739886,841926,817630,734630,69293,918262,928467,468395,765413,290164,128310,89824,145621,320967,406889,906239) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50764 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50764 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000366s ]