SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027404 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027404 [ RunTime:0.001540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (732719,644777,73189,416106,229010,224540,771993,767475,1016134,878650,444176,703157,923806,249006,542797,678543,385616,70350,286099,369900,729415,491032,250863,257862,750883,892741,215952,905241,988157,713478,362093,924122,750028,408198,429124,764533,102444,413053,187431,451295,307479,455215,218457,1028431,940764,912831,628501,168183,750077,292936,529126,206730,270200,381318,850195,663109,147074,594945,490659,652020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]