SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 56206 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 56206 [ RunTime:0.002464s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199072,131403,1031570,556316,78169,930311,642333,563910,510489,189001,497207,1040511,788414,809245,826810,332470,185433,27181,512844,678821,387556,530953,668855,251129,980929,119802,523932,755206,105699,860309,620054,643607,832872,426716,573335,774297,43886,384698,337660,472311,514787,177891,159380,681797,493464,329690,61906,305758,287462,998088,1040655,149331,929200,340682,55366,1009791,271161,538517,903361,1034707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001817s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 56206 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 56206 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001186s ]