SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591001 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591001 [ RunTime:0.002008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (788153,365757,238139,38796,1018235,430282,783433,663559,434765,826633,608279,529774,542464,175526,52226,370859,473884,814014,499139,505572,440129,385223,212204,38590,307646,88043,77504,273069,692911,185057,268001,203136,77598,149687,297078,499477,538571,360433,690342,601776,295012,120242,640425,871977,903013,455666,265816,876525,612743,261135,559896,19667,357284,901134,331966,753147,877516,995237,65067,742792) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001868s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000698s ]