SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44013 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44013 [ RunTime:0.003381s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (177645,958507,671719,393467,86787,585328,657076,584228,243468,712874,273605,764952,758359,73766,541724,225577,520549,201067,180978,881277,871613,97773,768685,589701,807985,214528,346193,364019,62875,924398,271036,59390,286997,848864,949570,649258,548035,796063,547267,722405,129206,775963,21525,607889,329320,146591,274310,320117,338142,827167,678887,885589,330345,759590,202525,603138,773589,336910,642523,36563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]