SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530052 LIMIT 1 [ RunTime:0.002972s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530052 [ RunTime:0.003240s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (752527,668830,677004,950039,170592,736391,404704,450333,771815,853724,342902,404881,876437,594894,574951,139246,604790,699262,70029,730847,167818,843573,175056,438755,499533,906291,523111,53338,969467,753011,630348,882025,637031,76144,417169,984313,429139,619500,533107,585062,988240,417793,169443,677874,305458,321590,223016,363486,551338,798008,1026678,560507,369942,935694,447698,379112,1038782,774303,201210,931363) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530052 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003589s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530052 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001258s ]