SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001764s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003009 LIMIT 1 [ RunTime:0.004747s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003009 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (718253,305193,390681,999947,471237,130521,275293,147810,633190,683349,953770,218243,420241,812641,743242,38106,205344,510479,44665,898420,527253,580133,367740,28675,772523,454546,744075,378353,258315,786021,26149,441390,943375,738151,358694,664477,226188,704641,1010224,755554,614054,180649,333651,704881,385535,999950,541963,857313,585632,493248,651191,778108,167510,768878,534242,831327,728962,103125,505605,772938) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000644s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002804s ]