SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400801 LIMIT 1 [ RunTime:0.001080s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400801 [ RunTime:0.001805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (719943,935633,717792,196632,597952,607759,997199,693237,95384,1004064,989607,978179,544899,622433,1029142,861226,822145,801003,860583,412686,857410,754673,399506,570152,21149,274833,947758,405712,630762,248090,462395,1039141,621298,1028793,217486,919085,210753,197308,303503,367220,903475,717364,656101,766336,999767,362469,719326,872470,743362,563323,756260,349019,412623,572529,484512,1039193,570022,594250,403885,796228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]