SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004675s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311903 LIMIT 1 [ RunTime:0.005432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311903 [ RunTime:0.002002s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (259608,743778,438470,268494,199510,187714,975983,927756,184605,114796,491474,262277,991838,1030527,1028049,952394,281279,239110,188693,984768,495716,376477,178359,511771,477954,293890,277060,591400,778580,903257,551680,979377,627682,628180,979634,113961,530860,145367,403781,114736,953003,223032,561892,240663,767385,789524,748539,884026,966159,622212,707244,40447,423431,228083,99800,500146,655270,644534,890497,202449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311903 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311903 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]