SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565959 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565959 [ RunTime:0.001873s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (609500,522811,120496,229659,287409,243463,930981,299926,814960,984517,902239,337586,489859,501075,1028302,836093,506190,918255,829130,976421,566187,999479,676047,955847,313516,321145,502179,106454,683167,1038538,229770,709003,809980,547131,514263,526997,534562,716334,278984,1013576,252475,408011,309381,657355,643690,507498,847205,545008,502787,613408,164245,12977,561049,148339,775037,673047,172545,307120,390146,176283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565959 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565959 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000979s ]