SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503916 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503916 [ RunTime:0.001967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042263,224440,1036884,374200,841587,578539,678021,872625,882330,838435,958097,978602,326099,869818,780573,90859,70050,543818,57462,747412,882849,190599,292222,835752,163863,282668,442702,497375,173619,975603,264220,568981,110797,391654,217148,489953,814831,872269,814292,399432,185409,939114,413600,945815,229124,190619,556337,521035,875107,147033,808951,948234,777733,120822,590421,83476,694827,291383,286538,4260) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]