SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001567s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 304080 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 304080 [ RunTime:0.002177s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (943221,165916,945469,784146,817914,53790,498172,985336,240011,506147,636405,856955,1001280,613850,187319,398600,433979,341654,477235,738308,113896,296647,336748,834613,13494,529212,463159,586094,523529,22918,429871,316334,325986,42020,176208,834449,778381,138912,34231,920665,849354,153657,890254,913513,907891,68840,556480,501193,1045930,30746,496580,205330,252686,546808,592090,476859,232097,88769,591822,801752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 304080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 304080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001293s ]