SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003929s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 986802 LIMIT 1 [ RunTime:0.004598s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 986802 [ RunTime:0.002606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (613799,406073,950497,580176,933194,796926,1011384,339713,775747,532002,362837,119552,284914,672288,474554,129402,817680,502292,514303,468747,414566,173671,282174,825882,482543,366591,843841,777455,560367,549002,794614,448752,604528,472356,970521,981916,995969,973894,44121,328066,248554,509903,345053,745647,317938,1002112,879632,237491,432019,578618,366791,950728,506332,794739,996047,518591,480257,901758,956419,353267) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 986802 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000799s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 986802 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]