SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 679540 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 679540 [ RunTime:0.001739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (143936,857391,270850,310039,845768,826450,808709,402740,1018774,983681,576361,560170,214702,320453,386151,309309,315476,461221,474329,221497,301112,956235,1012342,714413,535960,1011208,46376,253016,1015188,660,1028953,639168,133199,351634,268241,806686,600244,740272,904200,815130,525633,833021,316654,267613,968707,595234,374933,1037926,491946,936361,975292,445354,573779,384745,237771,334926,543146,523150,558515,593663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 679540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 679540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]