SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580012 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580012 [ RunTime:0.001406s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (303338,352667,236717,280238,242690,958917,459972,621723,280413,701933,654826,247094,929422,552080,594018,992008,928863,205851,862413,199347,450738,752471,825978,771017,311020,723718,814750,523693,601241,542387,174271,983129,448193,848211,378381,971930,210124,862341,1011039,292189,788715,1011609,151660,825738,80250,507887,402598,699706,694944,739990,941319,298235,250143,855412,61205,532008,541616,628953,369497,851183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]