SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401040 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401040 [ RunTime:0.001943s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (882898,397805,109223,847342,288212,142498,925767,225015,254982,928497,191486,508086,292790,238087,275562,24742,294099,23395,138224,940691,257315,109225,497656,860144,508983,549570,1045753,698229,675880,672877,172765,764581,885464,1894,750019,663278,810990,311678,973949,301893,873609,313665,158886,457446,815427,962198,911936,274422,312533,635769,161732,248176,161278,845529,500662,576232,733661,294449,374837,1010699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]