SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534059 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534059 [ RunTime:0.002022s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (804585,42341,556458,255088,862701,330497,265815,825864,946618,79744,275981,257846,357682,324932,619238,833360,500151,494207,630285,488639,814585,809091,728657,436806,435602,701448,238956,618456,447345,817601,248181,15866,861441,982008,638001,820623,454092,728576,371942,868570,87161,42199,624982,977110,802638,557336,645104,956310,613394,861497,525537,795818,226021,482052,1014399,268359,270404,986041,277821,9133) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534059 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534059 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000946s ]