SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544313 LIMIT 1 [ RunTime:0.003594s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544313 [ RunTime:0.002686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (994282,1020272,3307,178798,307535,195753,986331,233706,617843,245280,148856,474603,403876,183441,235524,784568,223248,585113,78530,355133,1033013,614759,991366,310315,869336,983022,602724,939074,87977,682126,533550,379691,94706,98578,13904,397262,802302,587276,952117,617197,148052,481346,133375,976903,119619,76849,346724,730153,986474,843122,177987,447521,630887,359865,329944,98393,802851,676516,440631,603969) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]