SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500521 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500521 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113473,821351,218880,827591,803525,72336,844430,410853,516026,525882,285595,201061,735486,548122,90093,115609,905158,345772,986059,711528,521177,978873,380185,991205,1002088,860015,585511,99293,193936,324457,856865,991742,406309,36557,164082,782378,504518,853590,743483,610173,367972,775669,81076,800026,291331,472124,424353,262234,864668,1026526,692550,449521,93840,468657,839043,152475,857844,308801,692060,846775) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]