SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201006 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201006 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102440,18178,892304,729680,302137,815548,654411,663340,257343,580490,239584,879443,238451,868424,428508,59899,156017,261411,770460,75768,450655,451324,813935,339839,829847,705033,40061,199961,831560,707956,204676,560078,804420,116879,312243,395927,679776,913423,307995,38733,4689,117620,710557,19288,232255,320199,305836,389305,937220,617216,565511,865161,1043871,596858,439080,502758,1000511,65292,152824,1033248) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000628s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]