SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481031 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481031 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (307263,86410,155051,320528,446700,848669,251710,337956,829310,917427,934837,197239,925682,773963,107112,435822,155571,488108,952769,730570,751736,760119,788520,280317,346514,74962,123856,339233,1033363,123335,720839,423220,648625,274574,499557,682325,827688,566587,1040754,12370,82861,104803,710799,248563,972941,612190,273188,458479,964285,61049,628555,124481,514236,583135,869860,671988,468822,969726,784052,596720) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000932s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]