SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411583 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411583 [ RunTime:0.001968s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (305325,874648,170297,792556,1002743,646591,3485,88903,311529,1001848,740749,224441,697359,768391,790931,488358,890930,278092,435352,491575,1033298,17289,470785,113394,121903,972528,537622,477939,692286,1014172,250067,551912,586043,18101,755729,994337,873303,827953,882691,508180,483443,813119,308228,435845,713689,230050,288624,730098,958896,596857,851144,1025461,871124,137465,511271,161003,614333,59571,455075,358453) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]