SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575571 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575571 [ RunTime:0.002376s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (494267,722061,795944,47637,984997,946711,938012,166363,925703,633321,861405,628240,132145,325226,299584,13362,887375,94304,491264,1027582,520258,117016,676344,836211,1014616,809124,117933,683489,324228,595380,39067,535650,560442,449948,744149,822876,994483,1039282,609290,59578,345358,819592,175646,609617,144694,854829,127527,426404,982724,502514,777055,925092,926493,377506,761255,872782,38385,559974,47764,945456) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000976s ]