SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489405 LIMIT 1 [ RunTime:0.000764s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489405 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (798560,201293,611913,627923,915090,2000,353617,278155,974767,968499,734898,288324,683188,641744,920877,234655,257630,530269,903479,348701,593509,490850,521378,324995,137843,152805,339338,131353,537158,683073,359600,454304,819123,1033872,984570,749517,1003921,1033249,76819,971077,368289,755037,299296,783542,4681,977213,150300,498638,506203,3165,1009116,632560,1026960,528996,108491,780533,244771,855372,769036,395315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001219s ]