SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 588091 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 588091 [ RunTime:0.002179s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (381338,964605,835181,487130,496747,1007971,20132,347654,206960,566450,889496,590611,524530,267908,685593,322298,595227,490672,210404,410458,948869,422477,287702,314327,511193,352086,558008,962359,732726,306802,898396,655722,219058,573741,386079,877688,106359,985295,935279,273581,217512,416485,360043,122364,112288,608198,244727,878824,967391,489848,190917,190858,628520,964023,378100,605258,518372,934113,583153,570675) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001834s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 588091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 588091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]