SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002652s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512011 LIMIT 1 [ RunTime:0.004009s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512011 [ RunTime:0.002632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425479,183880,438485,981953,490079,709459,249123,516847,71908,219117,497923,179107,812633,852989,640156,379466,860353,835628,351239,775816,939733,677212,331320,573368,176637,620879,867498,624948,89636,942596,268288,633837,457960,660227,588491,533473,342898,921103,939165,1015985,212400,689468,85180,195622,661335,491678,231881,695039,43563,547072,961356,546180,563257,583060,739784,393431,66327,342941,814214,1042921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.037784s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001888s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004518s ]