SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516976 LIMIT 1 [ RunTime:0.001626s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516976 [ RunTime:0.001536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (818916,804817,338988,439471,59889,664148,510974,244624,650383,518088,144172,373298,112861,3464,533907,216861,83459,32416,231761,999711,644140,674457,473033,847893,720296,437917,462282,819457,669835,952238,981192,220904,596308,126501,819281,310151,831219,134593,481779,245271,21384,821094,627877,1032522,230457,380146,255090,951870,618335,732226,1027072,357274,206674,370037,851291,376644,10759,104782,597316,647585) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516976 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516976 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]