SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 980421 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 980421 [ RunTime:0.002017s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512610,895216,165883,339559,732761,972494,261608,894637,299021,843372,963202,388092,520660,335633,204052,39489,649803,327923,815390,898348,440257,592343,870401,875600,687629,749843,106085,947222,597110,395520,867895,273356,530784,474535,866335,569341,894190,181972,601401,188055,123852,842212,238123,811804,546633,970015,170665,170300,606139,1033667,115549,1022598,291806,280576,201398,78418,536575,521758,867638,14983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 980421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 980421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]