SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413974 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413974 [ RunTime:0.001569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121307,958514,361577,900444,202648,617251,555834,596914,742723,945036,307776,819549,695538,557280,62442,746853,892029,104633,843027,744605,121717,767543,574687,355809,197465,889436,568505,1034839,59781,634944,871596,476077,742478,439423,151745,409933,762123,274173,140890,1045791,731926,209590,346633,768542,249209,23800,125300,567653,135970,107850,907862,949614,839871,901135,374180,712295,815281,976032,340187,71706) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]