SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538595 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538595 [ RunTime:0.001566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031469,961401,898545,990879,766501,761688,107057,846339,304907,406245,950526,725927,924355,177512,967076,512977,455008,991118,50520,885511,316852,636731,48005,975106,209120,601483,589636,537910,28697,425179,451218,872193,133156,956536,194101,10037,920109,31919,896564,918587,862562,989789,419795,501640,693326,758793,931006,730943,624007,498938,809189,838786,316166,749654,199940,589375,477968,471939,329350,570379) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538595 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538595 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001144s ]