SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001955s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532620 LIMIT 1 [ RunTime:0.002016s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532620 [ RunTime:0.002224s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614234,926254,111744,75964,526414,1048233,272463,152932,746012,823777,979518,128736,1043910,286061,897528,1026270,575241,93977,525973,842715,479930,923101,429459,563880,162303,754807,247368,406062,953726,585908,986275,432400,199531,660757,699482,764242,1018082,800169,159482,327590,645816,90227,395057,513569,128743,243839,230712,789547,512915,87521,490067,59710,481340,88699,354382,1034962,791989,96522,983899,624066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532620 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000748s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532620 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]