SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51351 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51351 [ RunTime:0.003432s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585706,17087,197546,324718,271829,352583,123495,23206,560481,46400,729689,597269,222118,609176,367165,174145,720129,58742,126199,792034,538275,177724,425937,761665,488405,456965,337529,139800,572987,195778,307546,633591,376646,154455,19332,335518,394923,52343,1044272,306457,1026656,702736,301091,217778,388209,59407,150670,962435,1020163,969045,111228,332003,670354,508064,822770,402923,316797,446807,884980,74275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51351 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51351 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]