SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554314 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554314 [ RunTime:0.002458s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (687890,235680,1036406,281550,101288,230400,559729,761735,704414,822863,449849,873025,601188,436393,419999,553804,505179,100248,279542,462037,424801,622708,321481,659204,880256,378923,943050,378128,292337,899992,226932,361739,612402,845322,786889,719967,418893,25635,906571,840228,413407,339891,93599,228341,847169,826307,2905,450798,438198,841626,659163,216669,809500,893040,209801,888376,560723,471124,908939,1037717) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]