SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001525s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402293 LIMIT 1 [ RunTime:0.001039s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402293 [ RunTime:0.009452s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (53807,41753,384367,465100,517445,95772,512141,881286,517638,50357,817427,808056,951004,685090,752868,61576,762278,308562,278310,883403,976229,286751,875690,59362,283161,675771,207287,115016,428637,76389,888572,620946,350765,660211,91727,725245,534240,610020,932804,629267,95149,707757,656555,520874,376315,291877,760061,823744,496421,378535,592908,592139,560601,163114,898261,330254,996493,552223,74852,389134) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003691s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402293 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402293 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001021s ]