SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016645 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016645 [ RunTime:0.002869s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506712,9194,149705,54025,383835,547317,506218,286665,946405,1045659,246916,316281,101937,234482,383234,807414,805298,250698,741414,161521,162012,825898,671568,954677,334961,979614,961732,582696,237121,763084,918070,434202,752332,782058,55877,836916,10410,281124,555033,552550,496582,558434,431053,194552,879857,340609,176844,504739,429686,112751,20541,644840,987669,890844,303467,154579,761132,99204,836460,140941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016645 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016645 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]