SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 980611 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 980611 [ RunTime:0.001739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (288365,877677,435808,166977,686217,191860,110896,755142,988544,442986,440703,420316,988865,355031,778816,902594,833958,732126,211660,574044,838972,958120,1018837,558279,1013825,451588,301086,960845,426399,912666,17632,428882,827352,180240,269410,170963,470837,106303,782734,61514,431475,767826,864174,94419,575923,578480,544752,152949,709922,3839,847860,144193,551384,209114,516582,708583,701017,834239,616788,597005) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 980611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 980611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]