SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563481 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563481 [ RunTime:0.001493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284497,586788,716815,745769,609411,246362,430641,78758,685315,541477,383528,344634,93313,895765,792755,682132,172179,556668,813636,168641,880427,311740,234977,867952,825465,349637,329622,676495,938968,1015413,299991,900663,616955,364297,114841,835295,973482,548455,483413,274329,1025712,497314,701023,965937,506936,859272,357368,204308,330500,370397,468937,1018140,885059,634306,821242,1014199,81738,168777,546179,103731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000936s ]