SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498945 LIMIT 1 [ RunTime:0.002696s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498945 [ RunTime:0.006296s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (456047,775252,338526,876439,518111,103408,203862,8598,489865,571397,1043276,100348,875190,73442,142138,177272,389644,651669,362760,260080,322241,316713,687494,236351,4625,476092,78468,906280,896117,1040304,689193,1025522,955645,572904,454264,59142,182764,319193,383125,912125,508788,70160,73573,651176,341441,376319,392371,167786,596406,388188,61616,182417,598389,521157,967742,593012,306517,474258,336039,338083) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498945 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001885s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498945 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]