SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508712 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508712 [ RunTime:0.003697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (932850,59241,241710,258756,80448,84751,1021190,130360,448134,693002,741264,917814,168009,798676,470661,342523,603792,972606,609575,620469,701141,861067,635439,324048,1010232,2368,863945,723954,180972,478178,105690,44249,843892,847331,960302,889334,404541,508254,589210,523283,551118,815335,841601,738702,925531,919517,914022,650207,482214,561428,237360,268894,417438,243857,294281,670418,127687,985425,978734,563394) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000752s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]