SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 712110 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 712110 [ RunTime:0.002822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (860816,442583,233149,913095,840143,1004031,307039,614016,957376,133745,89758,643102,175821,437741,883171,559838,704775,497045,404308,207636,411718,890659,125751,504112,293715,749939,451374,677100,690246,349133,473665,514346,624431,46674,235080,561074,259725,349249,272290,980120,533277,732798,864144,769981,284183,1013376,140564,211010,145849,87510,843315,297682,986663,515318,56458,402907,819209,997881,794121,859851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 712110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 712110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]