SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420512 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420512 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (442851,590952,256120,977720,806141,246199,1035547,957738,288791,971428,74956,999343,611425,541140,408525,625863,314200,883309,733462,710856,263415,990147,25140,50463,814197,816239,18377,242060,761821,825106,685923,233487,563927,523457,126294,372877,560306,1020483,591884,259895,662652,272884,618462,941868,231021,751592,852892,864586,577473,303227,31994,219412,449021,116419,101237,310808,558640,48912,83788,187132) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]