SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433816 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433816 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (221349,64888,8846,426938,463293,623689,895352,472962,499800,466736,366755,1024768,430878,835899,768157,138558,815581,912594,232013,942112,308511,843045,643846,690277,861820,675459,299628,304483,805592,6864,1020357,881443,118322,186965,926967,894250,119180,649730,841383,1010890,75288,117296,886174,930828,859793,170465,357533,618161,14780,505211,713501,5666,4028,446392,926467,168314,84304,119071,687328,674324) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000408s ]