SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001463s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504404 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504404 [ RunTime:0.002663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356803,771458,523372,87272,930943,729639,463342,736796,434426,78846,108069,100333,465357,718211,655240,337121,59256,767762,53314,557004,403606,1047492,225509,902220,414771,267303,262982,323469,840937,5428,66633,988526,451677,97079,602845,665304,248852,808912,291433,198194,277556,909265,930156,609757,172878,510520,1002581,42654,283460,215848,804210,857625,818482,164090,579634,740588,822416,223565,580108,183315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]