SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511311 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511311 [ RunTime:0.003531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (551576,377243,109213,256071,966364,149277,201906,525462,326249,782269,73322,764151,281230,601835,159041,115849,347696,177023,146320,939660,615283,1047046,534137,602892,963113,45681,293782,461526,706488,945356,693783,95008,726441,936212,847485,268500,13128,660529,139528,663465,753128,804064,245027,501253,558200,413687,300076,745276,26486,283403,243234,122253,317245,99051,813542,195751,259746,712871,802042,333235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]