SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 610701 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 610701 [ RunTime:0.002528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282643,599301,674451,288475,577275,1029759,250179,622848,285974,209310,689454,918363,781310,107844,677224,735359,374312,1007940,1004158,513158,368748,920596,788914,362184,324977,533646,739339,18202,961962,323312,796634,643151,1018063,105308,95202,468218,288656,10880,753884,262746,661252,534945,1024070,832085,590109,1036104,28572,401278,988236,547751,855824,123716,908477,533761,1047831,453926,591932,197744,703686,191360) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 610701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 610701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]