SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002679s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40105 LIMIT 1 [ RunTime:0.002458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40105 [ RunTime:0.004259s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (213511,604769,712848,527037,429951,591067,977138,103673,8900,309126,913033,202981,122839,376314,900002,575043,864973,976505,205353,864051,815482,338109,898609,718245,176463,623314,1021383,32372,321416,225138,4172,470294,162961,385962,725162,953524,68021,520420,712839,824643,626248,580207,336822,657412,356707,658934,643426,608274,444196,355185,628630,44006,873200,916044,560789,369908,476418,1016369,344766,206133) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]