SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393641 LIMIT 1 [ RunTime:0.000696s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393641 [ RunTime:0.002675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (636602,113724,488178,195038,401663,1014035,604387,627856,375434,319881,782879,76897,959431,868512,420354,53726,599382,416275,886215,467017,76588,761340,339398,324534,160098,730909,463035,564502,244302,112273,595819,159797,745798,350082,733496,319357,512118,110368,250862,907095,1324,1046315,656242,972076,748678,299604,923446,800239,594348,520504,780588,914341,598591,851629,263282,362629,414085,97412,10633,362637) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]