SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584829 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584829 [ RunTime:0.002717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (795104,90120,571992,547529,953348,231981,971105,384814,576295,676322,376673,526117,885051,828166,72818,272757,207760,669661,16366,75094,76532,916078,584617,646346,205298,152636,999628,157677,142296,774106,332080,706296,615461,718212,555902,645100,713775,394122,456910,277822,403914,629113,944802,543948,889590,729110,971912,468594,825517,315538,623399,9500,131655,655121,60314,4478,828394,666842,43706,185031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584829 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584829 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000862s ]