SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424748 LIMIT 1 [ RunTime:0.001152s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424748 [ RunTime:0.001825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (977170,677531,955239,250122,670043,53265,802935,973095,688785,372657,337522,44843,796030,305055,338339,839681,185624,926090,1011369,173821,332116,271137,927363,121543,854234,413187,703308,40389,502077,709595,766769,957640,902024,277020,59736,173635,253410,185131,716324,713289,800301,207702,608127,581081,329805,911650,862860,75684,64415,245537,520156,1007008,568721,919944,559204,101839,1012738,52486,198548,710747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.020248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000885s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000893s ]