SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48106 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48106 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (772587,458751,300798,816994,500814,940426,697119,79787,210490,990373,342897,500509,470601,568592,612592,678837,273813,629856,479628,919907,932705,316139,760010,769920,672072,910967,702373,830327,674549,924955,407365,988193,352270,70179,95142,561665,928257,843595,597842,520744,955963,153261,640956,286834,160045,90633,597486,223759,838531,102972,1047827,150664,865112,318303,66481,1022283,833706,738743,1014384,536546) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]