SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001627s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505124 LIMIT 1 [ RunTime:0.000462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505124 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (115909,504156,401820,1042169,1012941,870415,286759,684593,794704,609129,760972,891601,642207,914579,705403,473564,387863,1010962,857469,83440,621082,126603,529337,485485,317808,945372,26713,753079,802478,107618,844636,656247,345404,170732,563021,74281,604225,373653,978265,479699,485126,45987,754674,804154,542399,892419,52078,602515,462119,510978,452288,715485,266072,234208,636873,11801,9682,921831,149751,462828) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505124 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505124 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001204s ]