SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472913 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472913 [ RunTime:0.004229s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261492,545862,608333,571736,376840,930501,25558,2663,380942,778457,386611,333218,912807,633024,909285,356322,1045807,785577,231288,524952,291631,541959,75972,714117,401786,308830,219609,983558,274909,368328,865400,263639,656621,327779,663618,522803,531995,648908,561518,81992,923327,86027,125601,757732,916509,756278,251532,870918,498162,437709,171502,426327,347007,510030,1010325,143661,1010643,930016,295897,409890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001677s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]