SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530651 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530651 [ RunTime:0.001946s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101002,113264,157715,662687,453458,976102,609724,21994,837581,415980,852458,583232,353651,751364,1027933,759497,530157,877804,301816,689148,157288,884775,737519,175470,735454,614936,108726,199715,250368,383997,648374,172073,57955,1048172,517860,763011,842469,673422,970628,760948,967285,269291,883229,961320,308851,378841,992092,635681,311832,653415,157538,577909,945386,996381,1021364,255437,960058,880188,838321,748610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]