SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 265405 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 265405 [ RunTime:0.001512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (992203,13419,383698,831843,639075,262233,831101,205531,1030606,226613,827071,958978,164785,69479,2926,766418,919035,382049,94918,198344,649689,82164,971759,188647,844470,380485,732863,355012,318182,771312,81499,189690,275409,420029,637,521570,600452,975610,1037116,209303,50413,705127,321434,855090,414154,692823,952224,899231,388235,1025131,835724,19514,996200,450157,262226,539530,741308,702081,234482,408019) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 265405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 265405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]