SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533104 LIMIT 1 [ RunTime:0.000471s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533104 [ RunTime:0.001497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (832701,722150,300913,1008342,699669,41810,111080,892947,40873,467233,760483,434722,797730,149429,573339,810004,464764,445199,220019,2842,584034,422573,937754,277461,285988,306438,82230,583131,109820,498474,255622,108610,790865,965637,830664,181887,159417,695550,311211,230885,542715,709198,226806,12911,911203,418438,521572,640371,258450,530899,945088,403918,438384,441126,505646,516058,821353,30832,725081,880209) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000855s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000855s ]