SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526482 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526482 [ RunTime:0.002380s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314864,249247,872862,816390,156491,778562,1015635,734975,895197,799562,546114,953387,732592,606627,670008,824540,300049,470096,917244,723399,969507,989535,834917,469108,836204,729390,315200,99491,587730,54514,975458,216292,1016563,275335,533269,256974,522827,251916,265478,287693,789980,8679,280147,640525,418668,848588,263647,645640,867688,489519,696932,531379,88575,360487,278037,854208,464130,473363,814584,1016429) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]