SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001525s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543631 LIMIT 1 [ RunTime:0.000471s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543631 [ RunTime:0.002263s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035064,29322,137887,123299,643386,174940,84311,472725,1034435,226528,351541,397777,384790,310946,57839,539130,302714,69918,859411,134260,541892,1012580,76766,589532,209314,944707,719771,579043,74694,639100,487017,498429,847141,1011977,299019,143017,843442,336480,646393,572633,526731,1015030,360625,642207,749315,116098,462435,1046262,981215,751504,556421,211765,914565,305188,904282,615936,774134,753243,235901,962449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543631 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543631 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001158s ]