SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545766 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545766 [ RunTime:0.002062s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (392760,298997,8575,270581,961911,335367,197491,27169,348788,612214,653993,36039,212011,1046189,504881,143251,723098,413771,592272,877981,858282,687169,147451,531062,896211,346458,569683,996979,578404,273910,353012,854485,932579,895228,736484,380114,638235,1007573,662995,182197,994820,651750,398293,514214,563524,395704,874636,348825,942907,530347,411415,316192,986491,733181,356834,15159,74040,811295,339644,711115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545766 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545766 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]