SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 645409 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 645409 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (943652,605231,383648,261411,679284,496905,192206,425458,112996,396404,333180,47387,1024602,822178,399141,338737,797624,236316,912407,871177,809267,923800,821087,583712,433889,490005,616411,287293,214892,884114,800336,594944,987768,211523,879210,733644,478821,340625,976575,366426,1002589,371536,250492,373492,720710,108737,475221,301287,2988,652541,100965,27643,506981,729244,396032,904636,822788,986000,362292,1037593) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 645409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 645409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]