SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 825481 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 825481 [ RunTime:0.001880s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043857,255022,1019093,511761,24128,434564,328657,168444,58406,356905,581766,316151,448615,393723,318458,761816,228639,781447,593176,583321,282580,874114,479088,728437,413790,635633,111943,451519,1004139,464161,734082,672210,999240,885086,445999,609667,295004,732506,426757,155496,229534,500849,149292,496573,377623,273399,474737,589618,913939,959341,912404,612847,1033881,600237,43626,815434,616347,971659,2540,688844) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002738s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 825481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 825481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]