SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 333911 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 333911 [ RunTime:0.002438s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (231346,740031,987952,53983,90261,43564,156142,772602,323236,548817,557027,257377,695669,426149,488990,789420,331759,524346,246989,909007,201148,776222,872003,783045,216252,32618,781405,178430,747261,737624,527582,644744,417376,1039409,245601,448697,704261,490605,133890,659811,672182,542421,89354,562822,376438,533304,1027656,676264,622279,183620,626298,671839,834499,249676,394386,345928,1038055,910305,376503,566709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 333911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 333911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]