SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.008108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467919 LIMIT 1 [ RunTime:0.004484s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467919 [ RunTime:0.005078s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (697948,537124,767009,206301,1002389,394548,955992,442754,95005,236359,427443,774994,52224,553858,19118,1033545,33680,545499,225479,845652,540609,1004832,313823,829343,738617,337783,184093,847055,359195,318731,214107,239095,383942,830478,834267,800500,502661,250757,115078,454394,416757,405425,276297,198885,902299,916076,827197,150603,776817,170125,346077,53517,688304,598204,925468,426065,156581,275692,745594,635682) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001728s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467919 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467919 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000763s ]